mysql 创建用户,修改密码
1.创建用户root,并赋予密码,例如:
CREATE USER 'root'@'localhost' IDENTIFIED BY '88888888';
如果用户已经存在,只是修改密码:
<span style="color:#dcc6e0">ALTER</span> <span style="color:#dcc6e0">USER</span> <span style="color:#abe338">'root'</span>@<span style="color:#abe338">'localhost'</span> IDENTIFIED <span style="color:#dcc6e0">BY</span> <span style="color:#abe338">'88888888'</span>;2.给该用户所有权限:
<span style="color:#dcc6e0">GRANT</span> <span style="color:#dcc6e0">ALL</span> PRIVILEGES <span style="color:#dcc6e0">ON</span> *.* <span style="color:#dcc6e0">TO</span> <span style="color:#abe338">'root'</span>@<span style="color:#abe338">'localhost'</span> <span style="color:#dcc6e0">WITH</span> <span style="color:#dcc6e0">GRANT</span> OPTION;3.刷新权限:
FLUSH PRIVILEGES;