1. 在mysql中创建用户
mysql> CREATE USER demo IDENTIFIED BY "123456";
2.赋予任何主机访问数据的权限
mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'demo'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
3.刷新使更改生效
mysql> FLUSH PRIVILEGES;
1. 在mysql中创建用户
mysql> CREATE USER demo IDENTIFIED BY "123456";
2.赋予任何主机访问数据的权限
mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'demo'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;