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">&#39;root&#39;</span>@<span style="color:#abe338">&#39;localhost&#39;</span> IDENTIFIED <span style="color:#dcc6e0">BY</span> <span style="color:#abe338">&#39;88888888&#39;</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">&#39;root&#39;</span>@<span style="color:#abe338">&#39;localhost&#39;</span> <span style="color:#dcc6e0">WITH</span> <span style="color:#dcc6e0">GRANT</span> OPTION;

3.刷新权限:

FLUSH PRIVILEGES;