解决误删mysql.user中user:root host:localhost那一行
来源:互联网 发布:网络拓扑结构包括 编辑:程序博客网 时间:2024/06/02 07:27
导致从本地输入Mysql -uroot -p 显示:ERROR 1045 (28000): Access denied for user root@localhost(也就是从本地不能登录以root身份登录)
首先我的系统是ubuntu14.04 64位,重建后用户和密码都是root
1、Service mysql stop(停止mysql服务)
2、mysqld_safe --user=mysql --skip-grant-tables --skip-networking (--skip-grant-tables:不启动grant-tables(授权表),跳过权限控制。
--skip-networking :跳过TCP/IP协议,)
3、mysql -u root mysql
4、insert into mysql.user (host, user, password,ssl_cipher,x509_issuer,x509_subject) values ('localhost', 'root', password('root'),'','','');
5、flush privileges;
6、 grant all privileges on *.* to 'root'@'localhost' identified by 'root';如果报错试试执行这句话
(update user set Host='localhost',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';)
7、flush privileges;
8、service mysql start
这样在linux界面下输入mysql -uroot -p 就可以登陆了
- 解决误删mysql.user中user:root host:localhost那一行
- Host='localhost' and User='root';
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- 解决mysql“Access denied for user 'root'@'localhost'”
- mysql“Access denied for user 'root'@'localhost'”问题的解决
- 解决mysql“Access denied for user ‘root’@'localhost’”
- 解决mysql“Access denied for user root@localhost”
- 解决mysql“Access denied for user root@localhost”
- github的https换为ssh
- 进程与线程
- JSON字符串与 JSON对象
- 熄灯问题_POJ
- javascript 解惑
- 解决误删mysql.user中user:root host:localhost那一行
- LeetCode[50]分治算法求解power(double,int)问题
- 图片列表:鼠标移入移出改变图片的透明度
- uva 548 (二叉树)(不知数的多少进行数的一整行输入)
- UVA 10047 The Monocycle(bfs)
- 第一届天梯赛八道水题
- 删除倒数第n个词
- Synchronized总结
- Java中的数组和成员变量的默认值