mysql创建表格会提示错误_mysql创建系统表出错怎么解决？

我用的系统是红旗 之前有个rpm装的mysql 我用rpm -e卸载了 还有一个依赖关系 记得是mysql-test把 我也把他卸了

然后我刚装好了mysql 没有任何报错 权限问题也设置得没什么问题 就是启动不了

报错

[root@localhost ~]# /usr/local/mysql/bin/mysqld_safe --user=mysql &

[1] 7256

[root@localhost ~]# nohup: ignoring input and redirecting stderr to stdout

Starting mysqld daemon with databases from /usr/local/mysql/var

STOPPING server from pid file /usr/local/mysql/var/localhost.localdomain.pid

101111 01:25:39  mysqld ended

[1]+  Done                    /usr/local/mysql/bin/mysqld_safe --user=mysql

[root@localhost ~]#

我的步骤

我的详细步骤如下

[root@localhost ~]# bash configure -prefix=/usr/local/mysql

[root@localhost ~]# make

[root@localhost ~]# make install

[root@localhost ~]# cp support-files/my-medium.cnf /etc/my.cnf

[root@localhost ~]# chown -R root.mysql /usr/local/mysql/

[root@localhost ~]# mkdir /usr/local/mysql/var

[root@localhost ~]# chown -R mysql /usr/local/mysql/var/

到了这步报错了

[root@localhost mysql-5.0.56]# /usr/local/mysql/bin/mysql_install_db -user=mysql

Installing MySQL system tables...

101111  0:10:52 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

101111  0:10:52 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

101111  0:10:52 [ERROR] Fatal error: Can't change to run as user 'ser=mysql' ;  Please check that the user exists!

101111  0:10:52 [ERROR] Aborting

101111  0:10:52 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /usr/local/mysql/var for more information.

You can try to start the mysqld daemon with:

/usr/local/mysql/libexec/mysqld --skip-grant &

and use the command line tool

/usr/local/mysql/bin/mysql to connect to the mysql

database and look at the grant tables:

shell> /usr/local/mysql/bin/mysql -u root mysql

mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log

gives you a log in /usr/local/mysql/var that may be helpful.

The latest information about MySQL is available on the web at

http://www.mysql.com

Please consult the MySQL manual section: 'Problems running mysql_install_db',

and the manual section that describes problems on your OS.

Another information source is the MySQL email archive.

Please check all of the above before mailing us!

And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug script!

[root@localhost ~]# echo "/usr/local/mysql/lib/mysql/" >> /etc/ld.so.conf

[root@localhost ~]# ldconfig

启动也失败了如下

[root@localhost ~]# /usr/local/mysql/bin/mysqld_safe --user=mysql &

[1] 7256

[root@localhost ~]# nohup: ignoring input and redirecting stderr to stdout

Starting mysqld daemon with databases from /usr/local/mysql/var

STOPPING server from pid file /usr/local/mysql/var/localhost.localdomain.pid

101111 01:25:39  mysqld ended

[1]+  Done                    /usr/local/mysql/bin/mysqld_safe --user=mysql

[root@localhost ~]#