What should I do if mysql fails to add users?-1024programmer

The solution to the failure of mysql to add users: first find the bin folder in the mysql installation directory; then cmd to the directory and log in; then start to create users and grant permissions; finally exit and log in again Can.

The solution to the failure of mysql to add users:

1. Find the bin file in the mysql installation directory folder

2, cmd to this directory

C:\Program Files\MySQL\MySQL Server 8.0\bin>

3. Login: (enter password)

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p
 Enter password: *********

4. Start creating users and grant permissions

mysql> use mysql;
 Database changed
 mysql> delete from user where user='gao';
 Query OK, 1 row affected (0.30 sec)
 mysql> flush privileges;
 Query OK, 0 rows affected (0.04 sec)
 mysql> create user gao@localhost identified by '1998';#Start creating users
 Query OK, 0 rows affected (0.09 sec)
 mysql> flush privileges; # refresh privileges
 Query OK, 0 rows affected (0.04 sec)
 mysql> quit
 Bye

5. Log out and log in again

More related free learning recommendations:mysql tutorial(Video)

The above are the details of what to do if mysql fails to add users. For more information, please pay attention to other related articles on 1024programmer.com!