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.

You may also be interested in:

How to create a MySQL database and support Chinese characters
Introduction to adding new users to MySql, creating databases for users, and assigning permissions to users
mysql create database, add users, user authorization practical method
Two ways to create a MySQL database
Create database and database table code with MySQL
Example of creating a database using PHP
Create database php code and write your own BLOG system with PHP
PHP Desktop Center (I) Creating a database
MySQL and PHP basics and application topics: creating database tables

<<: HTML+VUE paging to achieve cool IoT large screen function

>>: harborRestart operation after modifying the configuration file