MySQL访问拒绝错误

Question

我试图在MacOS10.8上安装mySQL并设置一个用户帐户。注意，当涉及到在终端窗口中使用命令行时，我是abs初学者。

我使用以下说明来安装：http://www.macminivault.com/mysql-mountain-lion/

我在这里为所有用户设置了自己的密码：

 GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY 'mypass' WITH GRANT OPTION;
quit

每当我试图在命令行上以根用户的身份执行mySQL时，我都会得到以下内容：

Ciarans-MacBook-Pro:~ callanmooneys$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

我在网上读到很多东西，包括尝试改变密码：

mysqladmin -u root -pyourcurrentmysqlrootpassword password yournewmysqlrootpassword,
it returns -> 
    -> USE mysql
    -> 

如果我只需输入“mySQL”并启动mySQL监视器，那么尝试创建一个用户帐户：

mysql> USE mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
mysql> 

在论坛上也尝试回答：access is denied for user 'root'@localhost mysql error 1045返回'root@127.0.0.1命令未找到

和MySQL - ERROR 1045 - Access denied

Ciarans-MacBook-Pro:~ callanmooneys$ mysqld_safe --skip-grant-tables
131105 21:44:41 mysqld_safe Logging to '/usr/local/mysql/data/Ciarans-MacBook-Pro.local.err'.
131105 21:44:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: line 129: /usr/local/mysql/data/Ciarans-MacBook-Pro.local.err: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 166: /usr/local/mysql/data/Ciarans-MacBook-Pro.local.err: Permission denied
131105 21:44:41 mysqld_safe mysqld from pid file /usr/local/mysql/data/Ciarans-MacBook-Pro.local.pid ended
/usr/local/mysql/bin/mysqld_safe: line 129: /usr/local/mysql/data/Ciarans-MacBook-Pro.local.err: Permission denied
Ciarans-MacBook-Pro:~ callanmooneys$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Ciarans-MacBook-Pro:~ callanmooneys$

反馈意见很受欢迎。

Answer 1

有点混乱，但删除的mySQL和所有相关文件，重新安装，设置根密码，登录为mysql -u根-p (密码)，它工作良好。

对于任何遇到类似问题的人，我建议在这里使用官方网站，网络上有很多资源可能会让人感到困惑：

http://dev.mysql.com/doc/refman/5.1/en/access-denied.html