我无法设置 MySQL 的 root 密码
我刚刚使用 SuSE Server 10 设置了一个 LAMP 服务器。我想设置 MySQL 的 root 密码，因此我在终端中输入了以下内容：
mysqladmin -u root password MyPassword
输出为：
mysqladmin: Can't turn off logging; error: 'Access denied; you need SUPER
privilege for this operation'
I'm not true certain SUPER privilege is for mysqladmin ，我所有的谷歌搜索都没有结果。我可以从命令行使用 mysql，而无需输入如下密码：
mysql -u root
但我无法通过这种方式访问 mysql 数据库来更新 root 密码。这是输出：
mysql> USE mysql;
mysql> ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
任何帮助将不胜感激。谢谢。
I've just set up a LAMP server using SuSE Server 10. I want to set the root password for MySQL, so I entered the following in the terminal:
mysqladmin -u root password MyPassword
and the output is:
mysqladmin: Can't turn off logging; error: 'Access denied; you need SUPER
privilege for this operation'
I'm not really certain what SUPER privilege is for mysqladmin, and all my Google searches have been fruitless. I am able to use mysql from the command line without entering a password like this:
mysql -u root
But I can't access the mysql database to update the root password that way. Here is the output:
mysql> USE mysql;
mysql> ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
Any help would be greatly appreciated. Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我仍然不确定这个问题的解决方案是什么，但我想出的解决方案是安装 SuSE 11。现在一切正常。我认为我的初始安装有问题。
I am still unsure what the solution to this problem is, but the solution I came up with was to install SuSE 11. Everything is working now. I think there was just a problem with my initial install.