我进行以下操作:1,killall -TERM mysqld
2,/usr/local/mysql/bin/mysqld_safe --skip-grant-tables&出现以下报错:
[1] 2951
[root@localhost bin]# chown: `mysql': invalid user
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid
080130 15:30:35 mysqld ended
3,进入/usr/local/mysql/data打开 vi localhost.localdomain.err 里面内容如下:080130 15:17:54 mysqld started
080130 15:17:58 InnoDB: Started; log sequence number 0 43634
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.15-standard' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
080130 15:19:27 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown080130 15:19:27 InnoDB: Starting shutdown...
080130 15:19:28 InnoDB: Shutdown completed; log sequence number 0 43634
080130 15:19:28 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete080130 15:19:28 mysqld ended080130 15:30:35 mysqld started
080130 15:30:35 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!080130 15:30:35 [ERROR] Aborting080130 15:30:35 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete080130 15:30:35 mysqld ended
请高手指教
2,/usr/local/mysql/bin/mysqld_safe --skip-grant-tables&出现以下报错:
[1] 2951
[root@localhost bin]# chown: `mysql': invalid user
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/localhost.localdomain.pid
080130 15:30:35 mysqld ended
3,进入/usr/local/mysql/data打开 vi localhost.localdomain.err 里面内容如下:080130 15:17:54 mysqld started
080130 15:17:58 InnoDB: Started; log sequence number 0 43634
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.15-standard' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
080130 15:19:27 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown080130 15:19:27 InnoDB: Starting shutdown...
080130 15:19:28 InnoDB: Shutdown completed; log sequence number 0 43634
080130 15:19:28 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete080130 15:19:28 mysqld ended080130 15:30:35 mysqld started
080130 15:30:35 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!080130 15:30:35 [ERROR] Aborting080130 15:30:35 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete080130 15:30:35 mysqld ended
请高手指教
useradd mysql -g mysql
080131 06:39:38 mysqld started
080131 6:39:38 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
080131 06:39:38 mysqld ended
为你的/ibdata1设置权限。
chown -R mysql:mysql /ibdata1
080131 15:46:34 mysqld started
080131 15:46:34 InnoDB: Started; log sequence number 0 43634
080131 15:46:34 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/localhost.localdomain.pid' (Errcode: 13)
080131 15:46:34 [ERROR] Can't start server: can't create PID file: Permission denied
080131 15:46:34 mysqld ended
先杀死mysqld进程先,再启
再测试
cd 你的MYSQL安装目录
chown -R root .
chown -R mysql data/
chgrp -R mysql .