mysql 的权限设置问题---小弟初学,望热心大虾指点
我创建了一个用户aaaa 我授给他所有权限,语句如下
INSERT INTO mysql.user (Host,User,Password,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,reload_priv,shutdown_priv,process_priv,file_priv,grant_priv,references_priv,index_priv,alter_priv,show_db_priv,super_priv,create_tmp_table_priv,lock_tables_priv,execute_priv,repl_slave_priv,repl_client_priv)
VALUES('localhost','aaaa',PASSWORD('aaaa'),'y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');
同时创建了一个匿名用户
INSERT INTO mysql.user (Host,User,Password,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,reload_priv,shutdown_priv,process_priv,file_priv,grant_priv,references_priv,index_priv,alter_priv,show_db_priv,super_priv,create_tmp_table_priv,lock_tables_priv,execute_priv,repl_slave_priv,repl_client_priv)
VALUES('%','aaaa',PASSWORD('aaaa'),'y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');
检查数据库两个用户都创建成功,没有问题,但是我用这个用户 aaaa:aaaa 从网页上访问我自己的数据库就会出现访问拒绝的信息:
数据库操作出错:1045 -> Access denied for user 'aaaa'@'computer' (using password: YES)
谢谢大虾指点。