問題
Ubuntu18.04 安裝mysql(5.7)時沒有提示設(shè)置root密碼,裝完怎么登錄呢?
解決
找到初始賬號和密碼
sudo cat /etc/mysql/debian.cnf添加賬號并設(shè)置密碼
mysql -u debian-sys-maint -p
輸入第1步查到的密碼
創(chuàng)建本地訪問用戶
create user wcf@localhost identified by '123456';
創(chuàng)建任意ip訪問用戶
create user 'wcf'@'%' identified by '123456';
修改用戶密碼
set password for wcf@localhost = password('wcf')
本地連接授權(quán),<dbname>的所有權(quán)限
grant all privileges on dbname.* to wcf@localhost identified by '123456';
所有連接授權(quán),<dbname>的所有權(quán)限
grant all privileges on dbname.* to 'wcf'@'%' identified by 'wcf';
刷新權(quán)限
flush privileges;
- 如有必要,刪掉原來的賬號
