➜ ✗ mysql
-uroot
-p
Enter password
:
Welcome to the MySQL monitor
. Commands end
with ; or \g
.
Your MySQL connection
id is 13
Server version
: 8.0.19 Homebrew
Copyright
(c
) 2000, 2020, 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
> select user
,host
from user
;
+------------------+-----------+
| user
| host
|
+------------------+-----------+
| mysql
.infoschema
| localhost
|
| mysql
.session
| localhost
|
| mysql
.sys
| localhost
|
| root
| localhost
|
+------------------+-----------+
4 rows
in set (0.00 sec
)
mysql
> alter user
'root'@
'localhost' identified
with mysql_native_password by
'password';
Query OK
, 0 rows affected
(0.01 sec
)
mysql
> exit
Bye
我是用的 Homebrew 安装的mysql 8.0.19版本，默认root 账户的密码是空，回车就能进入。 修改密码的具体操作步骤如上，需要注意的是:alter user ‘{user}’@’{host}’ identified …
