grant SELECT on *.* to 'visitor'@'%' identified by ‘123456';
注:mysql5.6版本要加这个,不然本地创建的数据库无法登录
grant SELECT on *.* to 'visitor'@'localhost' identified by ‘123456';
grant SELECT on *.* to 'visitor'@'%' identified by ‘123456';
注:mysql5.6版本要加这个,不然本地创建的数据库无法登录
grant SELECT on *.* to 'visitor'@'localhost' identified by ‘123456';