永久黄网站色视频免费直播,yy6080三理论日本中文,亚洲无码免费在线观看视频,欧美日韩精品一区二区在线播放

標(biāo)題: [求助] 無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設(shè)置正確 [打印本頁]

作者: tszfzz 時間: 2013-7-2 18:32 標(biāo)題: 無法連接mysql，請檢查mysql是否已啟動及用戶密碼是否設(shè)置正確

錯誤提示
* 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 時間: 2013-7-2 18:32

在線求助重裝也不行

作者: admin 時間: 2013-7-2 19:14

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

作者: tszfzz 時間: 2013-7-2 19:32

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 時間: 2013-7-2 19:33

ubuntu12.04 64位系統(tǒng)

作者: tszfzz 時間: 2013-7-2 19:42

mysql 已經(jīng)成功啟動 ok

作者: tszfzz 時間: 2013-7-2 19:51

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

圖片附件: [phpmyadmin] phpmysql.jpg (2013-7-2 19:50, 26 KB) / 下載次數(shù) 9115
http://www.fsowen.com/bbs/attachment.php?aid=3171&k=203a006d1b30867dfaea91833734c309&t=1743836324&sid=1qmt33

作者: tszfzz 時間: 2013-7-2 19:52

:8080/phpmyadmin

作者: tszfzz 時間: 2013-7-2 20:37

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

作者: tszfzz 時間: 2013-7-2 21:52

不對啊 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 時間: 2013-7-2 22:06

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

作者: tszfzz 時間: 2013-7-2 23:42

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

歡迎光臨 WDlinux官方論壇 (http://www.fsowen.com/bbs/)