打开cmd,分别输入以下命令即可
msyql -u root -p; //以root用户登录
CREATE USER 'kme_15k'@'localhost' IDENTIFIED BY '123456'; //创建新用户,kme_15k是用户名,密码123456
GRANT ALL ON *.* TO 'kme_15k'@'localhost'; //添加所有权限
flush privileges; //最后这句必不可少,刷新数据库
如果想要修改密码,即可做如下操作:
SET PASSWORD FOR 'kme_15k'@'localhost' = PASSWORD('999999');
<pre name="code" class="sql">flush privileges; //最后这句必不可少,刷新数据库