1.创建用户
命令:CREATE USER 'face'@'%' IDENTIFIED BY 'Asdf@1111';
%:所有远程账号,localhost:本地账号
2.给用户授权
命令:
GRANT all privileges ON face_recognition.* TO 'face'@'%';
flush privileges;
3.退出当前账号(root)exit; 用新账号(face)登陆确认数据授权是否成功
命令:show databases;
成功截图:
参考链接:
https://www.cnblogs.com/xujishou/p/6306765.html