Mysql installation and configuration optimization and modification of the root password, optimize the root

Mysql installation and configuration optimization and modification of the root password, optimize the root

I. Installation

Apt-get install mysql-server requires setting the account password

apt-get isntall mysql-clientapt-get libmysqlclient-dev

2. Run sudo netstat-tap | grep mysql to check whether the installation is successful.

Root @ xyz :~ # Netstat-tap | grep mysqltcp6 0 0 [:]: mysql [:]: * LISTEN 7510/mysqld --> Installation successful

2. Set mysql Remote Access

1. Edit the mysql configuration file and comment out bind-address = 127.0.0.1.

vi /etc/mysql/mysql.conf.d/mysqld.cnf 

2. Use root to enter the mysql command line and execute the following two commands. In the example, the root account and password of mysql are: root

grant all on *.* to root@'%' identified by 'root' with grant option;flush privileges;

3. Restart mysql

/etc/init.d/mysql restart

Iii. Methods for changing the root password of MySQL

Method 1: use the set password command

　　mysql -u root　　mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

Method 2: Use mysqladmin

　　mysqladmin -u root password "newpass"

If the root user has set a password, use the following method:

　mysqladmin -u root password oldpass "newpass"

Method 3: Use UPDATE to directly edit the user table

Mysql-u root mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD ('newpass') WHERE user = 'root'; mysql> flush privileges; when the root password is lost, mysqld_safe -- skip-grant-tables & mysql-u root mysql> UPDATE user set password = password ("new password ") WHERE user = 'root'; mysql> flush privileges;

Summary

The above section describes how to install, configure, optimize, and modify the root password for Mysql. I hope it will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!