MySQL一些痛的领悟
来源：程序员人生 发布时间：2015-05-06 09:25:59 阅读次数：2727次
1.mysql> create database aa;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'aa'
这是匿名用户的意思~~~虽然你以为你是root登录
解决办法：改真实的root登录
F:Softwaresmysql5mysql⑸.6.24-winx64in>mysql --user=root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 12
Server version: 5.6.24 MySQL Community Server (GPL)
Copyright (c) 2000, 2015,
Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of
Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
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)
注意，mysql --user=root -p 是让你用root身份登录，所以下面出现的password是root的密码，默许为空，直接enter。
F:Softwaresmysql5mysql⑸.6.24-winx64in>mysql --user=root -p
Enter password: ******
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
这就表示密码毛病。
生活不易，码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
