Shulou(Shulou.com)06/01 Report--

The specific methods are as follows:

First, we need to stop MySQL service by issuing the following command:

service mysql stop

Then, find [mysqld] in the/etc/my.cnf configuration file and add the configuration: skip-grant-tables

For example:

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockskip-name-resolveskip-grant-tables

Finally, we save the file.

Now, we can log in MySQL without a password, if you forget the password, you can now change the password.

The above is how mysql sets up password-free login details, more please pay attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.