mysql添加新用户

一、先登录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;