Question

linux mysql无法启动，很急啊。。。

一时冲动我把/web/data/ 这个删掉了，里面的localhost.localdomain.pid ，localhost.localdomain.err，mysql都删掉了，结果重装了下，还是不行，错误是
130426 10:05:54 mysqld_safe Starting mysqld daemon with databases from /web/data
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130426 10:05:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130426 10:05:54 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
130426 10:05:54 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130426 10:05:54 [ERROR] Aborting

130426 10:05:54 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
130426 10:05:54 mysqld_safe mysqld from pid file /web/data/localhost.localdomain.pid ended
130426 10:21:01 mysqld_safe mysqld from pid file /web/data/localhost.localdomain.pid ended
130426 10:23:21 mysqld_safe Starting mysqld daemon with databases from /web/data
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
130426 10:23:21 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130426 10:23:21 [ERROR] /usr/local/mysql/libexec/mysqld: Can't create/write to file '/web/data/localhost.localdomain.pid' (Errcode: 13)

Answer 1

scripts/mysql_install_db --user=mysql --basedir=xxx --datadir=/web/data

使用这个初始化脚本初始化一下吧

追问

初始化后再装？会不会还原其他的

追答

初始化后，就可以直接访问了

追问

意思是删掉的又回来吗，，-bash: scripts/mysql_install_db: 没有那个文件或目录

追答

意思是，把你的数据库初始他了一次
至于原来的数据你有备份就恢复过去，没有的话就没了

追问

-bash: scripts/mysql_install_db: 没有那个文件或目录
出现的错误。。是什么pid和mysql文件夹都被删掉了，重装还是没有这个。

追答

/usr/local/mysql/scripts/mysql_install_db

看看有没有这个脚本

Answer 2

ps aux |grep mysql |grep -v grep |awk '{print $2}' |while read line ;do kill -9 $line ;done

/etc/init.d/mysqld restart

Answer 3

130426 10:23:21 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130426 10:23:21 [ERROR] /usr/local/mysql/libexec/mysqld: Can't create/write to file '/web/data/localhost.localdomain.pid' (Errcode: 13)
这两个错误先解决把阿

Answer 4

没有覆盖原来的mysql文件，你要和原路径一样。

追问

具体怎么解决，最好是有命令，我是菜鸟啊，他是什么pid和mysql文件夹都被删掉了，重装还是没有这个。