求助！！！mysql启动时错误

myr

090604 11:18:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090604 11:18:23 [ERROR] Can't find messagefile '/usr/local/mysql/var/share/mysql/english/errmsg.sys'
090604 11:18:23 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ee-bin' to avoid this problem.
/usr/local/mysql/libexec/mysqld: Unknown error 1036
090604 11:18:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090604 11:18:23 [ERROR] Aborting
090604 11:18:23 [Note]
090604 11:18:23 mysqld_safe mysqld from pid file /usr/local/mysql/var/ee.xjtu.edu.cn.pid ended

myr

090604 11:46:36 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
090604 11:46:37 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ee-bin' to avoid this problem.
/usr/local/mysql/libexec/mysqld: Table 'plugin' is read only
090604 11:46:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090604 11:46:37 [ERROR] Can't start server : Bind on unix socket: Permission denied
090604 11:46:37 [ERROR] Do you already have another mysqld server running on socket: /usr/local/mysql/lib/mysql.sock ?
090604 11:46:37 [ERROR] Aborting
090604 11:46:37 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
090604 11:46:37 mysqld_safe mysqld from pid file /usr/local/mysql/var/ee.xjtu.edu.cn.pid ended

我有正在使用的数据库

xiaoyu9805119

错误ms是重复启动，还是权限有问题呢？

myr

原帖由 xiaoyu9805119 于 2009-6-4 17:16 发表
错误ms是重复启动，还是权限有问题呢？

可以说的清楚点吗？


开始的那个错误我在my.cnf中加入
user=mysql
就变成第二个错误了

my997559

/usr/local/mysql/var
mysql对这个目录有没有权限呀？

myr

原帖由 my997559 于 2009-6-4 22:53 发表
/usr/local/mysql/var
mysql对这个目录有没有权限呀？

[root@ee var]# cd /usr/local/mysql
[root@ee mysql]# ll
总用量 44
drwxr-xr-x    2 mysql    root         4096  6月  3 20:14 bin
drwxr-xr-x    2 mysql    root         4096  5月 31 20:24 docs
drwxr-xr-x    3 mysql    root         4096 2005-10-07  include
drwxr-xr-x    2 mysql    root         4096 2005-10-08  info
drwxr-xr-x    3 mysql    root         4096  6月  3 09:42 lib
drwxr-xr-x    2 mysql    root         4096  5月 31 20:25 libexec
drwxr-xr-x    3 mysql    root         4096 2005-10-07  man
drwxr-xr-x   10 mysql    root         4096  5月 31 20:25 mysql-test
drwxr-xr-x    5 mysql    root         4096  5月 31 19:23 share
drwxr-xr-x    5 mysql    root         4096  5月 31 20:25 sql-bench
drwx------  105 mysql    root         4096  6月  4 21:53 var

Coolriver

是不是你的mysql这个库是从别的地方CP过来的。另外是不是改过机器的名字？

如果你是从mysql4X的数据CP到mysql5的话，需要参考一下升级的说明。