[求助] 無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設置正確

tszfzz

錯誤提示
* MySQL manager or server PID file could not be found!
Starting MySQL
. * Manager of pid-file quit without updating file.
下面是錯誤日志
130702 01:31:25 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var
130702  1:31:25 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!
130702  1:31:25 [ERROR] Aborting
130702  1:31:25 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete
130702 01:31:25 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/ubuntu.pid ended
130702 01:45:44 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var
130702  1:45:44 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!
130702  1:45:44 [ERROR] Aborting
130702  1:45:44 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete
130702 01:45:44 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/ubuntu.pid ended
130702 01:53:31 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var
130702  1:53:31 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!
130702  1:53:31 [ERROR] Aborting
130702  1:53:31 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete
130702 01:53:31 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/ubuntu.pid ended
130702 18:24:56 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.63/var
130702 18:24:56 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!
130702 18:24:56 [ERROR] Aborting
130702 18:24:56 [Note] /www/wdlinux/mysql-5.1.63/libexec/mysqld: Shutdown complete
130702 18:24:56 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.63/var/ubuntu.pid ended

tszfzz

在線求助  重裝也不行

admin

useradd mysql
chown -R mysql.mysql /www/wdlinux/mysql-5.1.63/var
service mysqld restart

tszfzz

root@ubuntu:~# useradd mysql
useradd: group mysql exists - if you want to add this user to that group, use -g.
root@ubuntu:~# chown -R mysql.mysql /www/wdlinux/mysql-5.1.63/var
chown: invalid user: `mysql.mysql'
root@ubuntu:~# service mysqld restart
* MySQL manager or server PID file could not be found!
Starting MySQL
. * Manager of pid-file quit without updating file.

tszfzz

ubuntu12.04 64位系統

tszfzz

mysql 已經成功啟動 ok

tszfzz

下載 (26 KB)
phpmyadmin

2013-7-2 19:50

這是要輸入 什么密碼  mysql？不對。文件權限？  也不對啊

tszfzz

:8080/phpmyadmin

tszfzz

已經解決 root密碼 不正確  不知道是什么 sh /www/wdlinux/tools/mysql_root_chg.sh  搞定。然后恢復wdcpdb.sql

tszfzz

不對啊 wdcpdb.sql  就這？

-- MySQL dump 10.13  Distrib 5.1.63, for unknown-linux-gnu (x86_64)
--
-- Host: localhost    Database: wdcpdb
-- ------------------------------------------------------
-- Server version        5.1.63

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2013-07-02 21:47:10

tszfzz

找到一個 sql文件 /root/lanmp/www/wdlinux/wdcp  ok

tszfzz

為什么 wdcp 修改文件 創(chuàng)建文件都失敗呢