今天第一学mysql,在wmap的phpMyAdmin中不小心删除root@127.0.0.1账户,后面就出问题了
百度到解决方法
在Mysql的my.ini中添加skip-grant-tables如下
[mysqld]
port=3306
explicit_defaults_for_timestamp = TRUE
skip-grant-tables
然后启动Mysql控制台输入
mysql>insert into mysql.user(Host,User,Password) values("127.0.01","root",password("123456"));
mysql>
update user set Host=‘127.0.0.1’,select_priv=‘y', insert_priv=‘y',update_priv=‘y', Alter_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',create_user_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’ where user=‘root’;
貌似这一步不成功
后面退出
然后修改
[mysqld]
port=3306
explicit_defaults_for_timestamp = TRUE
#skip-grant-tables
保存后重启服务
修改C:\wamp\apps\phpmyadmin4.1.14 config.inc.php文件中
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '123456';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
保存重启所有服务,
就能进入phpMyAdmin
参考:
http://www.jb51.net/article/42418.htm
http://zhidao.baidu.com/question/136953013.html
http://zhidao.baidu.com/question/175813995.html?qbl=relate_question_0&word=%231045%20-%20Access%20denied%20for%20user%20%27root%27%40%27localhost%27%20%28using%20password:%20NO%29