Server mysql installation

Server mysql installation

MySQL is a widely used open source relational database management system. It is used as the backend data storage of many web applications such as WordPress, one of the most popular website applications. . This article will provide a detailed tutorial for installing a MySQL database, fully applicable to the Linux operating system.

Step 1: Check dependencies

Before starting to install MySQL, you need to ensure that the following programs have been installed in the system. If not, please install them first:

1. A Non-root users
2. Install a Web server that supports MySQL. Both Apache and Nginx support connecting to MySQL. Creative Tim recommends installing Apache. Those who don't like it can choose by themselves.
3. Linux machine with wget (or network file downloader)
4. Command line shell interface

Step 2: Add MySQL source

Before installing MySQL, adding the MySQL source is a very important step. Please use the following command in the terminal to add the MySQL source. The following command is suitable for Ubuntu system. If you are using CentOS or other Linux distributions, please go to the MySQL official website to check the system source command.

wget mysql-apt-config_0.8.15-1_all.deb 
sudo dpkg -i mysql-apt-config*

When you run this command, the following prompt will appear, taking the Ubuntu 18.04 system as an example:

Select according to your needs, usually recommended Select MySQL Server & Cluster (your version).

Step 3: Update the repository

After adding the MySQL source, use the following command to update your system repository.

sudo apt-get update

Step 4: Install MySQL

After updating the warehouse, please use the following command to install MySQL:

sudo apt-get install mysql-server

Depending on your system version, there may be errors during the installation process. Different prompts and requirements, but just follow the system prompts to complete. Throughout the installation process, make sure you are using the "root" user or another user with administrator rights. During this time, you will be asked to enter your password to access the MySQL database later.

Step 5: Check MySQL Server Status

After installing MySQL, make sure it is running. Use the following command to check the status of the MySQL server.

sudo systemctl status mysql.service

If MySQL is running, this command tells you the server version that is running and the status of the MySQL server. If MySQL is not started, the command may prompt you to start the MySQL server.

Step 6: Check the MySQL version

After installing and starting the MySQL server, please use the following command to check the version of the MySQL server:

mysql -V

This command returns the version information of the MySQL server .

Step 7: Connect to MySQL

Finally, you can connect to the MySQL server and use it. Connect to the MySQL server using the following command:

mysql -u root -p

You should now be prompted to enter the password you created in step 4. Once completed, the following MySQL prompt will appear:

mysql>

Congratulations, you have now successfully installed the MySQL database server. Please continue using MySQL and start storing data.

The above is the detailed content of Server mysql installation. For more information, please follow other related articles on the PHP Chinese website!