mysql 更改数据库目录以后 不能启动！

dc10221203

121025 10:55:01 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 10:55:05 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 10:55:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 10:55:05  InnoDB: Initializing buffer pool, size = 16.0M
121025 10:55:05  InnoDB: Completed initialization of buffer pool
121025 10:55:05  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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 10:55:05 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 10:55:56 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 10:55:56 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 10:55:56  InnoDB: Initializing buffer pool, size = 16.0M
121025 10:55:56  InnoDB: Completed initialization of buffer pool
121025 10:55:56  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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 10:55:56 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 10:59:14 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 10:59:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 10:59:15  InnoDB: Initializing buffer pool, size = 16.0M
121025 10:59:15  InnoDB: Completed initialization of buffer pool
121025 10:59:15  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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 10:59:15 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended

dc10221203

军哥 出来看看哈


谢谢

licess

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
可能这个表没复制过去

/usr/local/mysql/bin/mysql_upgrade 执行试试，或重新将数据复制到新目录试试

dc10221203

121025 12:15:42 [Note] Event Scheduler: Purging the queue. 0 events
121025 12:15:42  InnoDB: Starting shutdown...
121025 12:15:48  InnoDB: Shutdown completed; log sequence number 0 44233
121025 12:15:48 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

121025 12:15:48 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 12:16:35 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
121025 12:16:35  InnoDB: Initializing buffer pool, size = 16.0M
121025 12:16:35  InnoDB: Completed initialization of buffer pool
121025 12:16:35  InnoDB: Started; log sequence number 0 44233
121025 12:16:35 [Note] Event Scheduler: Loaded 0 events
121025 12:16:35 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
121025 12:22:00 mysqld_safe A mysqld process already exists
121025 12:22:16 mysqld_safe A mysqld process already exists
121025 12:22:25 mysqld_safe A mysqld process already exists


重新复制CP  重启 还是有问题哦

licess

日志没错误

mysqld_safe A mysqld process already exists这个的话停掉mysql看看还有没有进程，有的话把mysql相关的进程都kill掉再启动

dc10221203

121025 14:12:50 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 14:12:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 14:12:50  InnoDB: Initializing buffer pool, size = 16.0M
121025 14:12:50  InnoDB: Completed initialization of buffer pool
121025 14:12:50  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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 14:12:50 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
121025 14:13:31 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql/var
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
121025 14:13:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
121025 14:13:34  InnoDB: Initializing buffer pool, size = 16.0M
121025 14:13:34  InnoDB: Completed initialization of buffer pool
121025 14:13:34  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 /home/data/mysql/var/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
121025 14:13:34 mysqld_safe mysqld from pid file /home/data/mysql/var/ubuntu.pid ended
军哥在那里呢

dc10221203

root@ubuntu:~# /root/lnmpa status
=========================================================================
Manager for LNMPA V0.9  ,  Written by Licess
=========================================================================
LNMPA is a tool to auto-compile & install Nginx+MySQL+PHP+Apache on Linux
This script is a tool to Manage status of LNMPA
For more information please visit http://www.lnmp.org

Usage: /root/lnmpa {start|stop|reload|restart|kill|status}
=========================================================================
Nginx is runing!
/etc/init.d/httpd: 112: /etc/init.d/httpd: lynx: not found
* MySQL running (1186)


现在数据库正常了 但是 httpd不能启动

dc10221203

root@ubuntu:~# /root/lnmpa status
=========================================================================
Manager for LNMPA V0.9  ,  Written by Licess
=========================================================================
LNMPA is a tool to auto-compile & install Nginx+MySQL+PHP+Apache on Linux
This script is a tool to Manage status of LNMPA
For more information please visit http://www.lnmp.org

Usage: /root/lnmpa {start|stop|reload|restart|kill|status}
=========================================================================
Nginx is runing!
/etc/init.d/httpd: 112: /etc/init.d/httpd: lynx: not found
* MySQL running (1186)


现在数据库正常了 但是 httpd不能启动

dc10221203

root@ubuntu:~# /root/lnmpa status
=========================================================================
Manager for LNMPA V0.9  ,  Written by Licess
=========================================================================
LNMPA is a tool to auto-compile & install Nginx+MySQL+PHP+Apache on Linux
This script is a tool to Manage status of LNMPA
For more information please visit http://www.lnmp.org

Usage: /root/lnmpa {start|stop|reload|restart|kill|status}
=========================================================================
Nginx is runing!
/etc/init.d/httpd: 112: /etc/init.d/httpd: lynx: not found
* MySQL running (1186)

licess

常见问题里都已经写过了，不用再重复说了。