Installation and use of mysql on Ubuntu (general version)

Regardless of which version of Ubuntu, installing the MySQL database is basically the same. The following are the specific installation steps:

1. Open the terminal and obtain root privileges

2. Enter in the terminal:

apt-get install mysql-server
apt-get install mysql-client
apt-get install libmysqlclient-dev

During the installation process, you need to enter "Y" to confirm where necessary.

After executing the above three commands, if you want to check whether MySQL is installed successfully, you can enter the following command to check:

netstat -tap | grep mysql

If the following figure appears, the installation is successful.

3. Realize remote control of mysql

(1) Edit the file /etc/mysql/mysql.conf.d/mysqld.cnf and comment out bind-address = 127.0.0.1

As shown in the following figure:

(2) Execute the authorization command under MySQL (authorize any remote computer to log in to the database)

Type mysql -uroot -p yourpassword in the terminal

After entering mysql, type the following command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your password' WITH GRANT OPTION;

Then refresh the configuration information and type the following command in the terminal:

flush privileges;

When you are finished, use exit to exit mysql.

4. After completing the above steps, restart the MySQL service. The command is as follows:

service mysql restart

After completing the above four steps, the MySQL database can basically be used normally. I hope this article was helpful to you!

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links