mysql

mariadb、mysql 创建用户、授权等

创建用户

CREATE USER 'my_user'@'%' IDENTIFIED BY '1q2w3e4r';

授权

GRANT ALL ON my_user_db.* TO 'my_user'@'%';

刷新权限

FLUSH PRIVILEGES;

mariadb

创建用户

CREATE USER 'collection_beauty'@'%' IDENTIFIED BY '1q2w3e4r';

授权

GRANT ALL ON collection_beauty_db.* TO 'collection_beauty'@'%';

mysql

CREATE USER 'nextcloud_001'@'xxx.xxx.xxx.xxx' IDENTIFIED BY '1q2w3e4r';
CREATE USER 'nextcloud'@'%' IDENTIFIED BY '!234qwer';
GRANT ALL ON *.* TO 'nextcloud'@'%';
GRANT ALL ON *.* TO 'nextcloud_001'@'39.101.150.249';