1.创建用户 CREATE USER 'test'@'localhost' IDENTIFIED BY '123456'; 2.赋予操作权限 GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost'; 3.赋予远程访问权限 GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY '123456';