What should I do if mysql fails to add users?

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!