无法连接mysql,请检查mysql是否已启动及用户密码是否设置正确

三 工具修复
可以直接使用工具检查,用ssh登录服务器,然后执行如下命令即可
sh /www/wdlinux/tools/mysql_wdcp_chg.sh 
更多可看  http://www.wdlinux.cn/bbs/thread-1607-1-1.html 



/www/wdlinux/wdcp/data/db.inc.php内容格式如下
  1. <?
  2. $dbhost = 'localhost';
  3. $dbuser = 'wdcp';
  4. $dbpw = '641cbb11';
  5. $dbname = 'wdcpdb';
  6. $pconnect = 0;
  7. $dbcharset = 'gbk';
  8. ?>
复制代码
 
 
 
//-----------------------------------------------------
 

[root@centos var]# service mysqld stop

MySQL manager or server PID file could not be found!       [FAILED]
解决办法:
首先查看一下进程
[root@centos mysql]# ps aux |grep mysq*
root      2643  0.0  0.2   4536  1224 ?        S    01:09   0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/centos.pid
mysql     2757  0.0  1.2  36976  6608 ?        Sl   01:09   0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --log-error=/usr/local/mysql/var/centos.err --pid-file=/usr/local/mysql/var/centos.pid --socket=/tmp/mysql.sock --port=3306
root      4788  0.0  0.1   3920   684 pts/2    R+   11:11   0:00 grep mysq*
如果看到上面的内容,那说明,Mysql的进程卡死了,这时用就要把这些卡死的进程都关闭
[root@centos mysql]# kill 2643
[root@centos mysql]# kill 2757
启动Mysql 就ok了
[root@centos mysql]# service mysqld start
Starting MySQL.