问题描述
我不小心删除了在OS X上运行的MAMP/MySQL的本地开发设置中的root
用户.没有创建其他用户来返回MySQL.
I accidentally deleted the root
user on my local dev setup of MAMP/MySQL running on OS X. There are no other users created to get back into MySQL.
这是一个温和的噩梦,没有root
似乎什么也做不了.
This is a mild nightmare can't seem to do anything without root
.
发现了此内容: http://hack2live.blogspot.com/2009/04/restore-repair-reset-mysql-root.html 似乎正是我所需要的.
Found this: http://hack2live.blogspot.com/2009/04/restore-repair-reset-mysql-root.html which seems like exactly what I need.
我也不认为重新安装MAMP可以解决问题,因为我的许多粗略搜索都使尝试过的人失败了.
I also don't think a reinstall of MAMP will do the trick, as a lot of my cursory searches yielded people who had tried without success.
有人知道OSX友好的方法来将root
@ localhost
重新创建回MAMP的MySQL吗?我基本上只是不知道MySQL在MAMP中生活在哪里,或者不知道如何在终端中执行正确的命令来尝试对其进行修复.
Does anyone know of an OSX friendly way to recreate root
@ localhost
back into MAMP's MySQL? I basically just don't know where MySQL is living in MAMP or how to execute the correct commands in terminal to try and fix it.
更新
我尝试了以下几种方法来恢复root都无效,并决定恢复整个MAMP应用程序的备份.所以我已经回来了,我可以打开phpmyadmin等.
I tried several options below to restore root to no avail and decided to restore a backup of the entire MAMP application. So I've got root back, I can open phpmyadmin, etc.
推荐答案
我有一个快速而肮脏的方法
I have a quick and dirty way
找一个拥有SysAdmin权限的人,然后执行以下操作:
Get someone with SysAdmin rights and do the following:
-
在[mysqld]部分下的my.cnf中添加"skip-grant-tables"
Add 'skip-grant-tables' to my.cnf under the [mysqld] section
重新启动mysql
输入没有密码的mysql,然后按Enter键
type mysql with no password and hit enter
运行此:
DELETE FROM mysql.user
WHERE user = 'root'
AND host = 'localhost';
INSERT INTO mysql.user
SET user = 'root',
host = 'localhost',
password = Password('whatevernewpassword'),
Select_priv = 'y',
Insert_priv = 'y',
Update_priv = 'y',
Delete_priv = 'y',
Create_priv = 'y',
Drop_priv = 'y',
Reload_priv = 'y',
Shutdown_priv = 'y',
Process_priv = 'y',
File_priv = 'y',
Grant_priv = 'y',
References_priv = 'y',
Index_priv = 'y',
Alter_priv = 'y',
Show_db_priv = 'y',
Super_priv = 'y',
Create_tmp_table_priv = 'y',
Lock_tables_priv = 'y',
Execute_priv = 'y',
Repl_slave_priv = 'y',
Repl_client_priv = 'y',
Create_view_priv = 'y',
Show_view_priv = 'y',
Create_routine_priv = 'y',
Alter_routine_priv = 'y',
Create_user_priv = 'y',
Event_priv = 'y',
Trigger_priv = 'y',
Create_tablespace_priv = 'y';
从mysql退出
exit from mysql
从[mysqld]部分下的my.cnf中删除"skip-grant-tables"
remove 'skip-grant-tables' from my.cnf under the [mysqld] section
重新启动mysql
那应该是全部!
这篇关于恢复MySQL的已删除"root"用户和密码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!