Unable to connect to MySQL, please check if MySQL is started and user password is set correctly

After installation, login background prompt Unable to connect to MySQL, please check if MySQL is started and user password is set correctly Check if MySQL starts NETSTAT-LNPT Is there a 3306 port? One has A Check to see if the/www/wdlinux/wdcp/data/db.inc.php file exists, And check the user password, no normal and login, can be logged in phpMyAdmin, or SSH MySQL Check for wdcpdb database and related data sheet after login Or B Check whether there are files under WDCPD directory and directory under/www/wdlinux/mysql/var/ If not Can manually create database wdcpdb database in phpMyAdmin, and WDCP user and save information to/www/wdlinux/wdcp/data/db.inc.php file Import the/www/wdlinux/wdcp/wdcpdb.sql file at the same time Complete two No Log in to the server with SSH Service mysqld Restart See if it starts up normally and puts the wrong information on it. if MySQL does not start up (with errors), perform the following Sed-i ' s/skip-innodb/#skip-innodb/g '/www/wdlinux/etc/my.cnf Again Service mysqld Restart Give it a try Three tools Repair You can use the tool to check, login to the server with SSH, and then execute the following command sh/www/wdlinux/tools/mysql_wdcp_chg.sh More to see http://www.wdlinux.cn/bbs/thread-1607-1-1.html Report /www/wdlinux/wdcp/data/db.inc.php content format is as follows <? $dbhost = ' localhost '; $dbuser = ' WDCP '; $DBPW = ' 641CBB11 '; $dbname = ' wdcpdb '; $pconnect = 0; $dbcharset = ' GBK '; ?> Copy Code

//-----------------------------------------------------

[[Email protected] var]# service mysqld stop

MySQL Manager or server PID file could not being found!       [FAILED] Workaround: First look at the process [[email protected] 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.pidmysql     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=3306root      4788  0.0  0.1   3920   684 PTS/2    r+   11:11   0:00 grep mysq* If you see the above, it means that the MySQL process is dead, and then the process of killing these cards will be closed [[email  Protected] mysql]# kill 2643[[email protected] mysql]# kill 2757 StartMove MySQL is ok [[email protected] mysql]# service mysqld startstarting mysql. 

Unable to connect to MySQL, please check if MySQL is started and user password is set correctly