我是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 existE:\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 failedE:\MySQL\mysql-5.5.19\client\Debug>
提示的意思大致是,MySQL服务器没启动,我晕了。MySQL服务当然没启动,因为启动不了嘛,这不是死锁了么。
有点迷茫,求高手解答,先谢过了
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 existE:\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 failedE:\MySQL\mysql-5.5.19\client\Debug>
提示的意思大致是,MySQL服务器没启动,我晕了。MySQL服务当然没启动,因为启动不了嘛,这不是死锁了么。
有点迷茫,求高手解答,先谢过了
解决方案 »
- 导入数据报错
- 请问高手mysql每当午夜时truncate某张表的event或者proc怎么写啊!
- mysql master-master如何做监控和故障恢复
- mysql创建表的问题 高手指教 先谢过
- 复制环境 1亿的大表删除数据
- mysql_real_connect中写localhost能连上,但是写我本地的ip就不行了,为什么
- 谢谢推荐一个MySql图形界面工具
- Delphi下调用MySql的存储过程疑问:只能采用TQuery控件,而不能采用TADOStoredProc控件吗(采用它总是报语法错误)?
- VC插入图片到mysql
- 救援,关于php调用mysql的问题,急
- 新人求问 关于Mysql中代码关键字的大小写问题?????
- mysql 存储过程+临时表执行过程中提示临时表不存在
我只想试着自己在windows下编译源码(不在Linux环境下哦),熟悉熟悉流程,方便以后的学习 !
而且,至少应该有配置文件等等。编译只是前期工作。