解决mysql在Centos下遇到的问题

最近在折腾新的VPS，准备在现在的VPS到期后迁移博客到新的VPS上，然后就折腾新的系统和新的软件版本，目前安装CentOS 6.3 64bit系统，512M的内存还能凑合着用。

在安装了LNMP后试着把碰到几次mysql的问题，不断的删改然后重装系统再重来，现在总算找出问题的解决办法了。

1. 解决 phpmyadmin #2002 无法登录 MySQL 服务器

修改 php.ini : mysql.default_socket = /tmp/mysql.sock

重启lnmp搞定。摘自 http://jafy00.blog.51cto.com/2594646/693649

2. ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: NO)

用管理员身份登录mysql

# mysql -p

mysql> set password for ‘root’@’localhost’ =password(‘newpassword’);
flush privileges;

重启mysql搞定。摘自http://blog.csdn.net/rain2lyh/article/details/7940939

Tags: ,

This entry was posted on 星期四, 9 5 月, 2013 at 00:15 and is filed under 东东博客. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply