1.创建用户
create user 'testtest'@'%' identified by '123';
2. 修改密码
mysql -u root -p
use mysql;
update user set password=password('234') where user='testtest';
flush privileges
exit;
3 创建用户
远程登录的用户
create user test@'%' identified by 'test';
grant all privileges on *.* to test@'%' identified by 'test';
flush privileges;
本机的
create user test@‘localhost' identified by 'test';
grant all privileges on *.* to test@'localhost' identified by 'test';
flush privileges;