无法诊断我的MySQL root用户问题 [英] Can't diagnose my MySQL root user problem

问题描述

我的MySQL设置中的MySQL根用户有问题，我一生都无法解决该问题.看来我已经以某种方式弄乱了root用户，现在对数据库的访问非常不稳定.

I have a problem with the MySQL root user in My MySQL setup, and I just can't for the life of me work out how to fix it. It seems that I have somehow messed up the root user, and my access to databases is now very erratic.

作为参考，我在OS X上使用MAMP提供MySQL服务器.我不确定这到底有多重要-我想我所做的任何事情都需要命令行修复才能解决.

For reference, I'm using MAMP on OS X to provide the MySQL server. I'm not sure how much that matters though - I'd guess that whatever I've done will require a command-line fix to solve it.

我可以像往常一样使用MAMP启动MySQL，并使用为PHP应用程序创建的标准"用户访问数据库.但是，我在MySQL GUI客户端以及phpMyAdmin中使用的root用户只能访问"information_schema"数据库以及我手动创建的两个数据库，并且大概(并且错误地)保留了开放的权限.我的root用户无法访问我的15个左右的其他数据库.当我加载phpMyAdmin时，主屏幕显示:创建新数据库:无权限".

I can start MySQL using MAMP as usual, and access databases using the 'standard' users I have created for my PHP apps. However, the root user, which I use in my MySQL GUI client, and also in phpMyAdmin, can only access the "information_schema" database, as well as two I have created manually, and presumably (and mistakenly) left permissions wide open for. My 15 or so other databases cannot be accessed my the root user. When I load up phpMyAdmin, the home screen says: "Create new database: No Privileges".

我肯定在某个阶段使用MAMP对话框更改了root用户的密码.但是我不记得我是否做过其他任何可能导致此问题的事情.我尝试再次更改密码，但问题似乎没有改变.

I certainly did at some stage change my root user's password using the MAMP dialog. But I don't remember if I did anything else which might have caused this problem. I've tried changing the password again, and there seems to be no change in the issue.

我也尝试过使用命令行重置root密码，包括使用--skip-grant-tables手动启动mysql，然后刷新privs，但同样，似乎没有任何方法可以解决该问题.

I've also tried resetting root password using the command line, including starting mysql manually with --skip-grant-tables then flushing privs, but again, nothing seems to fix the issue.

我已经完成了我的想法，并且非常感谢这里一位专家的一些逐步建议和诊断！

I've come to the end of my ideas, and would very much appreciate some step-by-step advice and diagnosis from one of the experts here!

非常感谢您的帮助.

推荐答案

那是因为MAMP和命令行mysql(以及除MAMP以外的所有mysql)是不同的.

Thats because MAMP and the command line mysql (and the mysql everything except MAMP) are different.

MAMP具有自己的内置mysql，您无法通过命令行访问它，只能通过phpmyadmin构建.

MAMP has its own built in mysql and you can't get to it via the command line, only the build in phpmyadmin.

这是我的经验，我有MAMP并使用其他mysql来代替ruby和其他东西上的红宝石.

this has been my experience, I have MAMP and use the other mysql for ruby on rails and other stuff.

这篇关于无法诊断我的MySQL root用户问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！