- 由于忘记了Ubuntu上MySQL的密码,经过一番百度,Google后折腾后终于更改了密码,并搜集整理了一些更改密码的方法,以备不时之需。
- 首先拿到操作系统的root权限,然后kill掉Mysql服务或者手动stop掉,这里我推荐使用手动stop;
sudo service mysql stop
然后执行
mysqld_safe --skip-grant-tables &
- &,表示在后台运行,不再后台运行的话,就再打开一个终端吧。接着登陆MySQL修改密码
ekanet@ubuntu-db:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.27 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, 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> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE user SET password=password("123456") WHERE user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 5 Changed: 2 Warnings: 0
mysql> exit;
Bye