- # grant all privileges on dbname.tablename to 'userName'@'%';
- # 比如想给用户nacos赋予数据库test所有的表的权限并且不限制nacos用户的连接地址，代码如下
- CREATE USER 'omind'@'%' IDENTIFIED BY 'omind';
- grant all privileges on *.* to 'omind'@'%';
- # 刷新权限
- flush privileges;
- use mysql;
- alter user 'omind'@'%' IDENTIFIED WITH mysql_native_password BY 'omind2023';
|
