以下的文章主要是对MySQL 5安装的过程中遇到的相关问题的解决,本文主要是以代码的方式来对MySQL 5安装的相关问题的详细解析,如果你对其实际的操作有兴趣的话,你就可以 浏览以下的文章了。
成都创新互联从2013年创立,是专业互联网技术服务公司,拥有项目网站建设、成都做网站网站策划,项目实施与项目整合能力。我们以让每一个梦想脱颖而出为使命,1280元宽甸做网站,已为上家服务,为宽甸各地企业和个人服务,联系电话:028-86922220
1、[root@localhost bin]# ./MySQLd_safe –skip-grant-tables
出现以下信息:
- Installing MySQL system tables…
- 090724 12:05:13 [Warning] option ‘max_join_size’:
unsigned value 18446744073709551615 adjusted to 4294967295- 090724 12:05:13 [Warning] option ‘max_join_size’:
unsigned value 18446744073709551615 adjusted to 4294967295- ERROR: 1062 Duplicate entry ‘localhost-’ for key 1
- 090724 12:05:13 [ERROR] Aborting
- 090724 12:05:13 [Note] /usr/local/MySQL5/libexec/MySQLd: Shutdown complete
- Installation of system tables failed!
- Examine the logs in /var/lib/MySQL5 for more information.
- You can try to start the MySQLd daemon with:
- /usr/local/MySQL5/libexec/MySQLd –skip-grant &
- and use the command line tool
- /usr/local/MySQL5/bin/MySQL to connect to the MySQL
- database and look at the grant tables:
- http://www.knowsky.com/
- shell> /usr/local/MySQL5/bin/MySQL -u root MySQL
- MySQL> show tables
- Try ‘MySQLd –help’ if you have problems with paths. Using –log
- gives you a log in /var/lib/MySQL5 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/MySQL5/bin/MySQLbug script!
2、[root@localhost bin]# /usr/local/MySQL5/libexec/MySQLd –skip-grant &
出现以下信息:
- [1] 6633
- [root@localhost bin]# 090724 12:05:34 [Warning] option ‘max_join_size’:
unsigned value 18446744073709551615 adjusted to 4294967295- 090724 12:05:34 [Warning] option ‘max_join_size’:
unsigned value 18446744073709551615 adjusted to 4294967295- 090724 12:05:34 [ERROR] Fatal error: Please read “Security”
section of the manual to find out how to run MySQLd as root!- 090724 12:05:34 [ERROR] Aborting
- 090724 12:05:34 [Note] /usr/local/MySQL5/libexec/MySQLd: Shutdown complete
- [1]+ Exit 1 /usr/local/MySQL5/libexec/MySQLd –skip-grant
解决办法:在/etc/my.conf中的MySQLd这一节中加入:user=MySQL,以上的相关内容就是对MySQL 5安装遇到的问题的介绍,望你能有所收获。
新闻标题:MySQL5安装过程中遇到的问题的解决
地址分享:http://www.36103.cn/qtweb/news38/39938.html
网站建设、网络推广公司-创新互联,是专注品牌与效果的网站制作,网络营销seo公司;服务项目有等
声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源: 创新互联