+ -
当前位置:首页 → 问答吧 → 关于MySQL服务器启动的一个问题

关于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服务当然没启动,因为启动不了嘛,这不是死锁了么。。。。
有点迷茫,求高手解答,先谢过了。。。

作者: calrincalrin   发布时间: 2011-12-19

建议你还是装个rpm包得mysql得 别用源码编译得了

作者: rucypli   发布时间: 2011-12-19