我刚刚通过Homebrew在OS X Lion上安装了MySQL,并按照安装后的说明进行了操作。现在我需要创建一个数据库:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 22
Copyright (c) 2000, 2011,): Access denied for user &
当我登录到我的根linux帐户时,我尝试在" root“mysql帐户上登录到mysql。然后我就可以登录到mysql了。那里一切都很好。问题是,当我尝试使用完全相同的creds从"user1“linux帐户登录mysql "root”用户时(无)。在mysql帐户上没有密码),我收到一条错误消息,上面写着:
ERROR 1045 (28000): Access denied for user
Warning: mysql_connect(): Access denied for user 'msuparam_17'@'localhost' (using password: YES) in /17database/Formfeed/Formreg.php on line 11
Could not connect: Access denied for user 'msuparam_17'@'localhost
我通过命令行以root身份登录本地Mysql。'root'@'localhost' to database 'some_db'GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost();
这证实了我是以'root'@'localhost‘登录的。为什么在以root身份登录时,我无