关于MySQL服务器启动的一个问题
时间:2011-12-19
来源:互联网
我是MySQL菜鸟,刚刚开始接触MySQL。
今天官网下了个MySQL的5.5.19最新源码包,使用CMake编译成vs2010的sln解决方案了,按照这个链接进行了编译工作(http://hi.baidu.com/phenixnote/blog/item/4dfd5aecf703f85378f055ef.html),编译成功完成,很是兴奋。
然后在cmd下进入到sql\Debug目录,启动mysqld服务器, mysqld --debug,进程就跑了一会儿就自动退出了,后来网上搜索了下,加上--console选项,出现以下错误信息:
E:\MySQL\mysql-5.5.19\sql\Debug>mysqld --debug --console
mysqld: Table 'mysql.plugin' doesn't exist
111219 16:51:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
111219 16:51:57 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
111219 16:51:57 InnoDB: The InnoDB memory heap is disabled
111219 16:51:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111219 16:51:57 InnoDB: Compressed tables use zlib 1.2.3
111219 16:51:57 InnoDB: Initializing buffer pool, size = 128.0M
111219 16:51:57 InnoDB: Completed initialization of buffer pool
111219 16:51:57 InnoDB: highest supported file format is Barracuda.
111219 16:51:58 InnoDB: Waiting for the background threads to start
111219 16:51:59 InnoDB: 1.1.8 started; log sequence number 1595675
111219 16:51:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
E:\MySQL\mysql-5.5.19\sql\Debug>
按照出错信息的提示,我觉得应该是没有运行mysql_upgrade,于是我运行mysql_upgrade,信息提出如下:
E:\MySQL\mysql-5.5.19\client\Debug>mysql_upgrade -u root -p
Enter password: ****
Looking for 'mysql.exe' as: E:\MySQL\mysql-5.5.19\client\Debug\mysql.exe
Looking for 'mysqlcheck.exe' as: E:\MySQL\mysql-5.5.19\client\Debug\mysqlcheck.e
xe
Running 'mysqlcheck with default connection arguments
E:\MySQL\mysql-5.5.19\client\Debug\mysqlcheck.exe: Got error: 2003: Can't connec
t to MySQL server on 'localhost' (10061) when trying to connect
FATAL ERROR: Upgrade failed
E:\MySQL\mysql-5.5.19\client\Debug>
提示的意思大致是,MySQL服务器没启动,我晕了。。。。MySQL服务当然没启动,因为启动不了嘛,这不是死锁了么。。。。
有点迷茫,求高手解答,先谢过了。。。
今天官网下了个MySQL的5.5.19最新源码包,使用CMake编译成vs2010的sln解决方案了,按照这个链接进行了编译工作(http://hi.baidu.com/phenixnote/blog/item/4dfd5aecf703f85378f055ef.html),编译成功完成,很是兴奋。
然后在cmd下进入到sql\Debug目录,启动mysqld服务器, mysqld --debug,进程就跑了一会儿就自动退出了,后来网上搜索了下,加上--console选项,出现以下错误信息:
E:\MySQL\mysql-5.5.19\sql\Debug>mysqld --debug --console
mysqld: Table 'mysql.plugin' doesn't exist
111219 16:51:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgr
ade to create it.
111219 16:51:57 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
111219 16:51:57 InnoDB: The InnoDB memory heap is disabled
111219 16:51:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111219 16:51:57 InnoDB: Compressed tables use zlib 1.2.3
111219 16:51:57 InnoDB: Initializing buffer pool, size = 128.0M
111219 16:51:57 InnoDB: Completed initialization of buffer pool
111219 16:51:57 InnoDB: highest supported file format is Barracuda.
111219 16:51:58 InnoDB: Waiting for the background threads to start
111219 16:51:59 InnoDB: 1.1.8 started; log sequence number 1595675
111219 16:51:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
E:\MySQL\mysql-5.5.19\sql\Debug>
按照出错信息的提示,我觉得应该是没有运行mysql_upgrade,于是我运行mysql_upgrade,信息提出如下:
E:\MySQL\mysql-5.5.19\client\Debug>mysql_upgrade -u root -p
Enter password: ****
Looking for 'mysql.exe' as: E:\MySQL\mysql-5.5.19\client\Debug\mysql.exe
Looking for 'mysqlcheck.exe' as: E:\MySQL\mysql-5.5.19\client\Debug\mysqlcheck.e
xe
Running 'mysqlcheck with default connection arguments
E:\MySQL\mysql-5.5.19\client\Debug\mysqlcheck.exe: Got error: 2003: Can't connec
t to MySQL server on 'localhost' (10061) when trying to connect
FATAL ERROR: Upgrade failed
E:\MySQL\mysql-5.5.19\client\Debug>
提示的意思大致是,MySQL服务器没启动,我晕了。。。。MySQL服务当然没启动,因为启动不了嘛,这不是死锁了么。。。。
有点迷茫,求高手解答,先谢过了。。。
作者: calrincalrin 发布时间: 2011-12-19
建议你还是装个rpm包得mysql得 别用源码编译得了
作者: rucypli 发布时间: 2011-12-19
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28