请大伙看看这个MYSQL

发布于 2022-10-02 02:59:43 字数 2233 浏览 9 评论 0

请大伙帮帮忙。。。小弟在安装MYSQL源码时遇到了一个问题。。
debian:/usr/local/mysql/bin# ./mysql_install_db
Installing all prepared tables
ERROR: 1062  Duplicate entry '~' for key 2
ERROR: 1064  You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '"   BIT_AND(expr)\nReturns the bitwise AND of all bits in expr. The calculation ' at line 1
040531  8:15:21  Aborting

040531  8:15:21  /usr/local/mysql/libexec/mysqld: Shutdown Complete

Installation of grant tables failed!

Examine the logs in /usr/local/mysql/var for more information.
You can also try to start the mysqld daemon with:
/usr/local/mysql/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:

shell>; /usr/local/mysql/bin/mysql -u root mysql
mysql>; show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/var 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/mysql/bin/mysqlbug script!
每次安装编译完都很顺利。。。而且每次都是在初始化数库的时候出现这个错误。请大伙帮个忙。。解决一下这个问题。
debian:/usr/local/mysql/bin# ./mysql_install_db
Installing all prepared tables
ERROR: 1062  Duplicate entry '~' for key 2
ERROR: 1064  You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '"   BIT_AND(expr)\nReturns the bitwise AND of all bits in expr. The calculation ' at line 1
040531  8:15:21  Aborting

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文