MariaDB

新增用户

添加一个用户，并赋予pichome数据库的所有权限

CREATE USER 'new_user'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON pichome.* TO 'new_user'@'%';
FLUSH PRIVILEGES;

修改用户host

SELECT Host, User FROM mysql.user;
RENAME USER 'root'@'%' TO 'root'@'localhost';
FLUSH PRIVILEGES;