[MySQL] – 更改密碼後，無法登入phpmyadmin

Posted by 夕口 on Tuesday, September 15, 2009 · 1 Comment 

問題：

# ./mysql -V
./mysql  Ver 14.7 Distrib 4.1.22, for unknown-linux-gnu (x86_64) using readline 4.3

更改密碼後，無法登入phpmyadmin
但 commend 確可以?

解答：
問題在 編碼要使用舊式的

# rm -rf /usr/local/mysql/data/mysql/
#/usr/local/mysql/bin/mysqldump -uroot -p showdown
# /usr/local/mysql/scripts/mysql_install_db –user=mysql
# /usr/local/mysql/bin/mysqld_safe –user=mysql >/dev/null &
# /usr/local/mysql/bin/mysqladmin -uroot password new-password
#/usr/local/mysql/bin/mysql -uroot -p
> SET PASSWORD FOR  ‘root’@'localhost’ = OLD_PASSWORD(’新密碼‘);

Filed under MySQL, PHPMyAdmin · Tagged with

Comments

One Response to “[MySQL] – 更改密碼後，無法登入phpmyadmin”

Trackbacks

Check out what others are saying about this post...
  1. obycyhukecet says:
    September 26, 2009 at 4:29 am

    obycyhukecet…

    marvel and dc chars for mugen …



Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!