What to do if mysql fails to add user

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

Solution to mysql failure to add user:

1. Find the bin folder in the mysql installation directory

2. Go to the directory with cmd

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

3. Log in: (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';#开始创建用户 Query OK, 0 rows affected (0.09 sec) mysql> flush privileges;#刷新权利 Query OK, 0 rows affected (0.04 sec) mysql> quit Bye

5. Just log out and log in again

More related free learning recommendations:mysql tutorial(Video )

The above is the detailed content of What to do if mysql fails to add user. For more information, please follow other related articles on the PHP Chinese website!