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

In order to demonstrate, find a test environment to operate, do not do this online

Pkill mysqld, shut down mysql.

Skip the permission table of MySQL to start the MySQL service:

-- skip-grant-tables starts mysql

/ usr/local/mysql8013/bin/mysqld_safe-defaults-file=/data/mysql8/my8.cnf-skip-grant-tables &

Leave the password blank:

Root@localhost [(none)] > update mysql.user set authentication_string='' where user= "root" and host= "localhost"; Query OK, 1 row affected (0.06 sec) Rows matched: 1 Changed: 1 Warnings: 0root@localhost [(none)] >

Pkill mysqld, shut down mysql.

Start the mysql service again

[root@localhost] # / usr/local/mysql8013/bin/mysqld-- defaults-file=/data/mysql8/my8.cnf &

Log in to the MySQL service without a password and set a new password:

Root@localhost [(none)] > select version (); +-+ | version () | +-+ | 8.0.13 | +-+ root@localhost [(none)] > alter user user () identified by 'jist558@wei'

[root@localhost ~] # mysql-uroot-paired jist558Wei'e "select version ();"

Mysql: [Warning] Using a password on the command line interface can be insecure.

+-+

| | version () |

+-+

| | 8.0.13 |

+-+

When the password is written into the .my.cnf file, mysql can log in directly to the mysql window:

[root@localhost ~] # cat .my.cnf [mysql] prompt= "\ u@\ h:\ p\ R:\ m:\ s [\ d] >" no-auto-rehashuser=rootpassword=jist558@wei [root@localhost ~] # mysql-e "select version ();" +-+ | version () | 8.0.13 | +-+

Demo completed.

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.