Mysql Question 2

I was still very comfortable with the development in linux. I continued to record the problems in mysql. The root (localhost) password of mysql cannot be logged in according to the online tutorial yesterday, and the User's User is also deleted according to the online tutorial, finally, when I started to understand mysql's user and permission information, I am mysqld_safe -- us

I was still very comfortable with the development in linux. I continued to record the problems in mysql. The root (localhost) password of mysql cannot be logged in according to the online tutorial yesterday, and the User = User is also deleted according to the online tutorial, finally, when I started to understand mysql's user and permission information, I am mysqld_safe -- us

I was still very comfortable with the development in linux. I continued to record the problems in mysql.

The root (localhost) password of mysql cannot be logged in according to the online tutorial yesterday, and the User = ''is also deleted according to the online tutorial, finally, when I began to understand mysql's user and permissions, I am mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking & and then enter mysql to view the users of the system. I found that there are no users whose host name is localhost...

Although the root user password of other host names has been set to "* 23AE809DDACAF96AF0FD78ED04B6A265E05AA257", it is encrypted "123", but I try to use these user identities to log on without real root permissions. You can insert a root user whose host name is localhost and find that the permission is also incorrect...

Simply delete mysql and reinstall it. Review the deletion process:

Delete a software package: rpm-e mysql-server // This command is ordered. You must first delete a software package that does not depend on other software packages.

Delete a software package: rpm-e mysql ******* // otherwise, the system will prompt that the software cannot be deleted. In my impression, four software packages are deleted in sequence.

Delete a software package: rpm-e l ********

Delete a software package: rpm-e mysql *******

Sister's home network speed is very good, so the direct yum install mysql download speed is 600kb ~~~~

Oh, yum install mysql-devel and yum install mysql-server have been installed in dozens of seconds.

Start mysql: service mysqld start ...... Ah, the following error occurs: Redirecting to/bin/systemctl start mysqld. service.

Job failed. See system journal and 'systemctl status' for details. Let's take A look at the log:/var/log/mysqld. log: mysqld_safe A mysqld process already exists ....

I really don't know what this is, so I had to ps-A | grep mysql and then kill-9 process number.

Mysql-u root again. Well, I finally logged on to mysql again, but I still have to set a password.

I just found that the previous online update user set password = '000000' where user = "root" // This is incorrect. The password is not 123456.

Set password = password ('000000') where user = "root ";

Restart the mysql service and log in successfully with the root and password 123. Then:

Grant all privileges on *. * TO 'root' @ '%' identified by 'root' with grant option;

To grant all users the remote connection permission, and finally succeeded (* ^__ ^ *)