mysql 新建用户单库授权

命令行  mysql -uroot -p

输入管理密码

给found库 新建用户 found  密码 Found@123 授权

本机可以访问

grant all on found.* to found@localhost identified by 'Found@123';

任何ip都可以访问，found 数据库

grant all on found.* to found@‘%’ identified by 'Found@123';

查看授权情况

select user,host from mysql.user;