Mysql anonymous login cannot create a database problem solution

Frequently asked questions

Access denied for user ''@'localhost' to database 'web02' //web02 is a database I created myself

Cause analysis: In the user table of the MySQL database, there is an account with an empty username, that is, an anonymous account. As a result, although the login is done as root, it is actually an anonymous login.

Below is a comparison of the two login methods

1)mysql -u root -p

It can be seen that this most primitive method is not safe, and the system does not know whether the user is anonymous.

2)mysql -hlocalhost -uroot -p

-h represents the server name, localhost represents the local; -u represents the database user name, root is the default user name of MySQL; -p represents the password. If a password is set, you can directly enter it after -p, such as: -p123456. If the user has not set a password, just press Enter when Enter password is displayed.

This method of entering the database can quickly resolve the problem.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.