dimoshougary的博客

mysql -h 192.168.5.116 -u root -p

mysql -uroot -prootMySQL5.7 mysql.user表没有password字段改 authentication_string；一. 创建用户:命令:CREATE USER 'username'@'host' IDENTIFIED BY 'password';例子:CREATE USER 'dog'@'localhost' IDENTIFIED BY '1234...

1，mysql -u root -p2，use mysql；3，查询用户表命令：select User,authentication_string,Host from user4，GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' 这里的123456为你给新增权限用户设置的密码，%代表所有主...

DROP USER 'guest'@'%';CREATE USER 'swgk_admin'@'%' IDENTIFIED BY '123456';GRANT all privileges ON swgk.* TO 'swgk_admin'@'%'flush privileges;