Linux Mysql安装问题
#tar-zxvfmysql-5.0.67.tar.gz#cdmysql-5.0.67#groupaddmysql#useradd-gmysql-s/sbin/nolog...
# tar -zxvf mysql-5.0.67.tar.gz
# cd mysql-5.0.67
# groupadd mysql
# useradd -g mysql -s /sbin/nologin -M mysql
# ./configure --prefix=/usr/local/mysql --with-charset=gbk --with-extra-charset=all --
enable-thread-safe-client --enable-local-infile --with-low-memory
# make && make install
# cp support-files/my-medium.cnf /etc/my.cnf
# chown -R mysql.mysql /usr/local/mysql/
# /usr/local/mysql/bin/mysql_install_db --user=mysql
# chown -R root.root /usr/local/mysql/
# chown -R mysql.mysql /usr/local/mysql/var/
启动数据库服务,并添加到自启动
# /usr/local/mysql/bin/mysqld_safe --user=mysql &
安装以后执行mysqld_safe --user=mysql &命令报以下错误:
090815 00:37:24 mysqld_safe Logging to '/usr/local/mysql/data/hyf.pincn.com.err'.
090815 00:37:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
090815 00:37:24 mysqld_safe mysqld from pid file /usr/local/mysql/data/hyf.pincn.com.pid ended
日志中信息为:
090815 0:29:46 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
090815 00:29:46 mysqld_safe mysqld from pid file /usr/local/mysql/data/hyf.pincn.com.pid ended
090815 00:37:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090815 0:37:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090815 0:37:24 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-federated'
090815 0:37:24 [ERROR] Aborting
090815 0:37:24 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
090815 00:37:24 mysqld_safe mysqld from pid file /usr/local/mysql/data/hyf.pincn.com.pid ended
哪位高手能帮忙解决一下,对于成功安装过的朋友来说可能很简单,但这个问题困扰了我很久了!谢谢
谢谢各位,问题已解决,权限问题! 展开
# cd mysql-5.0.67
# groupadd mysql
# useradd -g mysql -s /sbin/nologin -M mysql
# ./configure --prefix=/usr/local/mysql --with-charset=gbk --with-extra-charset=all --
enable-thread-safe-client --enable-local-infile --with-low-memory
# make && make install
# cp support-files/my-medium.cnf /etc/my.cnf
# chown -R mysql.mysql /usr/local/mysql/
# /usr/local/mysql/bin/mysql_install_db --user=mysql
# chown -R root.root /usr/local/mysql/
# chown -R mysql.mysql /usr/local/mysql/var/
启动数据库服务,并添加到自启动
# /usr/local/mysql/bin/mysqld_safe --user=mysql &
安装以后执行mysqld_safe --user=mysql &命令报以下错误:
090815 00:37:24 mysqld_safe Logging to '/usr/local/mysql/data/hyf.pincn.com.err'.
090815 00:37:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
090815 00:37:24 mysqld_safe mysqld from pid file /usr/local/mysql/data/hyf.pincn.com.pid ended
日志中信息为:
090815 0:29:46 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
090815 00:29:46 mysqld_safe mysqld from pid file /usr/local/mysql/data/hyf.pincn.com.pid ended
090815 00:37:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090815 0:37:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090815 0:37:24 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-federated'
090815 0:37:24 [ERROR] Aborting
090815 0:37:24 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
090815 00:37:24 mysqld_safe mysqld from pid file /usr/local/mysql/data/hyf.pincn.com.pid ended
哪位高手能帮忙解决一下,对于成功安装过的朋友来说可能很简单,但这个问题困扰了我很久了!谢谢
谢谢各位,问题已解决,权限问题! 展开
3个回答
展开全部
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
问题应该出在这里!重新初始化下数据库看下能否解决问题!
# /usr/local/mysql/bin/mysql_install_db --user=mysql 不行你在去程序员网站上找找
问题应该出在这里!重新初始化下数据库看下能否解决问题!
# /usr/local/mysql/bin/mysql_install_db --user=mysql 不行你在去程序员网站上找找
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
问题应该出在这里!重新初始化下数据库看下能否解决问题!
# /usr/local/mysql/bin/mysql_install_db --user=mysql
问题应该出在这里!重新初始化下数据库看下能否解决问题!
# /usr/local/mysql/bin/mysql_install_db --user=mysql
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
yuguyh
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询