首頁 > mysql, 未分類 > mysql忘記root密碼修改辦法

:mysql忘記root密碼修改辦法

2019年2月7日 發表評論 閱讀評論
 鸿运彩票app www.chqvd.icu [[email protected] default]# mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[[email protected] default]# sudo /usr/local/mysql/support-files/mysql.server stop 
Shutting down MySQL.                                       [  確定  ]
[[email protected] default]# cd /usr/local/mysql/bin
[[email protected] bin]# sudo su
[[email protected] bin]# ./mysqld_safe --skip-grant-tables &
[1] 2690
[[email protected] bin]# 190207 14:03:01 mysqld_safe Logging to '/usr/local/mysql/var/izj6c4danzl2zg703g6apoz.err'.
190207 14:03:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

[[email protected] bin]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 85
Server version: 5.5.48-log Source distribution

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> set password for 'root'@'localhost'=password('[email protected]');
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
除非注明,本站文章均為: 鸿运彩票app原創,轉載請注明本文地址: //www.chqvd.icu/4873.html

--完--

分類: mysql, 未分類 標簽:
  1. 本文目前尚無任何評論.
  1. 本文目前尚無任何 trackbacks 和 pingbacks.

福建时时计划群 三公棋牌游戏可提现 双色球预测最准确的 万人炸金花下载2014 北京单场过关投注方式 下载app送22元彩金 双色球玩赚尾号 重庆时时现场开奖结果软件 彩神时时彩计划全能版 全天北京pk10大小计划 牛牛看牌四张抢庄 重庆时时彩龙虎预测计划 中国竞彩网 十五码复式二中二多少组 北京pk赛车技巧论坛 送10元20元提现的棋牌