无法使用MySQL的root密码登录phpMyAdmin(在Mac OS X Lion上) [英] Cannot log in to phpMyAdmin with my root password for mySQL (on Mac OS X Lion)
问题描述
因此,我尝试使用我的root密码(用户名:root密码:******)登录phpMyAdmin,但是,我仍然收到错误消息:#2002无法登录MySQL服务器>
我非常确定我知道root密码,因为我在Mac OS X的终端上输入以下行:
sudo /usr/local/mysql/support-files/mysql.server start
,并以"Password:"
行提示.我输入了密码,终端显示为:
Starting MySQL...SUCCESS!
这样服务器就启动了.我不确定为什么相同的密码不能用于phpMyAdmin.
我尝试使用以下命令在终端中设置密码:
/usr/local/mysql/bin/mysqladmin -u root password *******
但是我收到输出:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
非常感谢您的帮助.我为此无所适从.我已经尝试了几个网站,而mySQL指令在此问题上毫无用处.有关如何解决此问题的详细说明(在Mac OS X Lion上)将非常有帮助.谢谢你.
更新:
我一直在尝试重置root密码,并遵循以下说明:解决方案
在config.inc.php
中,将$cfg['Servers'][$i]['host']
键的localhost
更改为127.0.0.1
.
So I am trying to log in to phpMyAdmin using my root password (Username: root Password: ******), however, I continue to receive the error: #2002 Cannot log in to the MySQL server
I am pretty sure I know the root password, as I have typed into terminal on Mac OS X the line:
sudo /usr/local/mysql/support-files/mysql.server start
and was prompted with a "Password:"
line. I typed the password, and the terminal read:
Starting MySQL...SUCCESS!
And thus the server started up. I am not sure why the same password is not working for phpMyAdmin.
I have tried setting the password in terminal with the command:
/usr/local/mysql/bin/mysqladmin -u root password *******
But I receive the output:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
I would very much appreciate help. I am at my wits end with this. I have tried several websites, and the mySQL instructions are useless on this matter. A detailed explanation on how to solve this problem (on Mac OS X Lion) would be very helpful. Thank you.
Update:
I've been trying to reset the root password, and have been following these instructions: http://www.coolestguyplanet.net/how-to-change-the-mysql-root-password/
However, when I use the command: /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
I receive the following output:
111217 10:00:42 mysqld_safe Logging to '/usr/local/mysql/data/******-********-MacBook-Pro.local.err'.
111217 10:00:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: line 107: /usr/local/mysql/data/********-********-MacBook-Pro.local.err: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/*******-**********-MacBook-Pro.local.err: Permission denied
111217 10:00:42 mysqld_safe mysqld from pid file /usr/local/mysql/data/*********-********-MacBook-Pro.local.pid ended
/usr/local/mysql/bin/mysqld_safe: line 107: /usr/local/mysql/data/*******-*********-MacBook-Pro.local.err: Permission denied
**********-*********-MacBook-Pro:~ myname$
Why would my permission be denied??
In config.inc.php
change localhost
to 127.0.0.1
for $cfg['Servers'][$i]['host']
key.
这篇关于无法使用MySQL的root密码登录phpMyAdmin(在Mac OS X Lion上)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!