How to install MySQL on Linux server (an instruction)


+1 vote
Good day to you!

Please, post a detailed instruction on how to install MySQL on Linux. What is necessary for doing that? Which problems may I face?
asked Sep 12, 2016 in System administration by Andrea

1 Answer

0 votes

Hello!
Installing MySQL on a Linux server – is a very simple procedure, which won’t take you longer than 5 minutes (including after-installation setting).

Before installing MySQL

  1. The latest versions of MySQL by Oracle Company cannot boast either operating speed or stability; however, there is an excellent substitution – MariaDB. This is a free instance of MySQL, from the author of MySQL, fully compatible with MySQL. If you have no special reasons for installing MySQL by Oracle itself, then, I recommend you installing MariaDB. We have a detailed article on installing MariaDB: How to install MariaDB on Linux server - a guide.
  2. In case you require a server with Apache+PHP+MySQL, there is no need to install MySQL separately. Install Webmin all at once, and in about 5-10 minutes you will get a ready server for web hosting or programming. You will find more details in our article: How to install Webmin and Virtualmin on any Linux server.
  3. If you haven’t chosen a server yet, I recommend using affordable and high quality virtual servers by DigitalOcean. A minimal server costs 5$ per month, you will be given 10$ as a gift for registration (proceed to DigitalOcean hosting).

Installing MySQL

The instruction is sized for Linux distro CentOS, but will be suitable for many others as well. Why CentOS? It’s solid, reliable and free – which makes it perfect for web servers.

 1. Run a command:

yum install mysql-server

Installing MySQL in a process

The YUM packet manager will offer you to install MySQL server itself and supporting software. Reply “y” and click Enter button.
 

2. Installation will take a few seconds; MySQL server, libraries and client will be installed. If you require additional libraries, for example, PHP support – you can install them separately: 

yum install php-mysql

That’s it, MySQL has been installed, now you can perform its initial setting.
 

3. To define or alter root password for MySQL, run a special script:

/usr/bin/mysql_secure_installation

Follow the instructions, everything is quite simple there.


If you have any questions or need more details – please, ask a question or leave a comment. I always will be pleased to help you!

answered Sep 12, 2016 by Expert Brian (5,370 points)
Welcome to Help Desk, here you can ask any questions and receive answers from our experts and other members of the community.

If you have any questions, please do not hesitate to contact our help desk!

Make a question!