一、先登录mysql
mysql -h hostip -u username -p ‘yourpassword’;
二、选择mysql数据库
usemysql;
三、添加用户
insert into user(Host,User,Password) values(‘localhost’,’youruser’,password(‘youpassword’));
四、赋予数据库权限
赋予用户所有数据库的本地访问权限
grant all privileges on . to youruser@localhost identified by ‘yourpassword’;
赋予用户特定数据库特定表的特定地址访问权限,localhost可以换成ip(特定ip)或%(所有地址)
grant all privileges on yourdb.yourtable to yourpassword@localhost identified by ‘yourpassword’;
刷下权限,否则不立即失效
flush privileges;