Ubuntu18.10

先看下用戶列表

①select user,host from mysql.user;?

+------------------+-----------+
| user ? ? ? ? ? ? | host ? ? ?|
+------------------+-----------+
| appleyuchi ? ? ? | localhost |
| debian-sys-maint | localhost |
| mysql.session ? ?| localhost |
| mysql.sys ? ? ? ?| localhost |
| root ? ? ? ? ? ? | localhost |
+------------------+-----------+

②使用下面的用戶名和密碼登錄mysql

root@ubuntu:/home/appleyuchi# cat /etc/mysql/debian.cnf?
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host ? ? = localhost
user ? ? = debian-sys-maint
password = Dk4mVgDGDZFf7rRI
socket ? = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host ? ? = localhost
user ? ? = debian-sys-maint
password = Dk4mVgDGDZFf7rRI
socket ? = /var/run/mysqld/mysqld.sock
?

登錄：

mysql -u debian-sys-maint Dk4mVgDGDZFf7rRI password:Dk4mVgDGDZFf7rRI

③授予權(quán)限(下面不要照抄，根據(jù)①中的列表中的用戶名和IP來(lái)修改)

GRANT ALL PRIVILEGES ON *.* TO 'appleyuchi'@'localhost' WITH GRANT OPTION;

?

總結(jié)

以上是生活随笔為你收集整理的mysql重置密码以及授予权限的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。