1.mysql> CREATE DATABASE AA;
ERROR 1044 (42000): Access denied for user "@ ' localhost ' to database ' AA '
This is the meaning of the anonymous user ~ ~ ~ Although you think you are the root login
Workaround: Change to Real root login
F:\softwares\mysql5\mysql-5.6.24-winx64\bin>mysql--user=root-penter password:welcome to the MySQL monitor. Commands End With; or \g.your MySQL connection ID is 12Server version:5.6.24 mysql Community Server (GPL) Copyright (c) +, Oracle an d/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.mysql> create database DBB; Query OK, 1 row Affected (0.00 sec)
Note that MySQL--user=root-p is to allow you to log in as root, so the following password is the root password, default is null, direct enter.
F:\softwares\mysql5\mysql-5.6.24-winx64\bin>mysql--user=root-penter Password: ******error 1045 (28000): Access Denied for user ' root ' @ ' localhost ' (using Password:yes)
This means that the password is incorrect.
MySQL some pain in the comprehension