1.使用root登录
mysql -uroot -p
# 回车后输入密码
2. 创建账户并授予所有权限
grant select on *.* to 'mak'@'localhost' identified by '12345678'
3.更改root密码
update user set authentication_string=password('12345678') where user='root';
flush privileges;
4.退出root账户
exit
5.用mak账户登录
mysql -umak -p