MySQL: ERROR 1044 (42000) Access denied for user ''@'localhost' to database 'aliendatabase'
程序员文章站
2024-02-16 18:07:34
...
新手轻喷。小弟在看head first 的 PHP & MySQL,第二章用命令行创建数据库:
tony@Tony-Laptop-Ubuntu$ ~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 41 Server version: 5.5.29-0ubuntu0.12.04.1 (Ubuntu) Copyright (c) 2000, 2012, 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 aliendatabase; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'aliendatabase'
求大神解释加解决方案~小弟拜谢!
回复内容:
新手轻喷。小弟在看head first 的 PHP & MySQL,第二章用命令行创建数据库:
tony@Tony-Laptop-Ubuntu$ ~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 41 Server version: 5.5.29-0ubuntu0.12.04.1 (Ubuntu) Copyright (c) 2000, 2012, 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 aliendatabase; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'aliendatabase'
求大神解释加解决方案~小弟拜谢!
没权限,用root登录:
mysql -uroot
如果root有密码:
mysql -uroot -p
推荐阅读
-
MySQL: ERROR 1044 (42000) Access denied for user ''@'localhost' to database 'aliendatabase'
-
ERROR 1044 (42000): Access denied for user ''@'localhost' to
-
MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passw
-
ERROR 1044 (42000): Access denied for user ''
-
Mysql Access denied for user ''@'localhost' to database 的一种解决方法
-
ubuntu18.0.4安装mysql并解决ERROR 1698 (28000): Access denied for user ''root''@''localhost''
-
Docker容器安装的mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
-
提示:ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'的错误如何解决?
-
MySQL无法登录问题-"ERROR 1045 (28000): Access denied for user 'root'@'localhost'"-之解决方法-密码重置
-
mysql:mysql error:Access denied for user 'root'@'localhost' (using password: YES)