mysql创建和授权

create user ‘sopr‘@‘%‘ identified by ‘sopr‘;

GRANT ALL PRIVILEGES ON *.* TO ‘sopr‘@‘%‘ IDENTIFIED BY ‘sopr‘ WITH GRANT OPTION;  

flush privileges;

重启一下：sudo service mysqld restart

mysql创建和授权

标签：