设置PHPmyadmin用cookie或http认证登录.不使用config方式. 即config.inc.php中设置: $cfg['Servers'][$i]['auth_type'] = 'cookie';// 或等于http在数据库的mysql数据库中的db表中设置.数据库和用户的对应关系.将有%的行删除.即: Db User -------------------- netvt netvt pmaster pmaster . . -------------------- 其他的字段为主机及某种操作的相应权限. 这样用PHPMYADMIN登录后,netvt只能访问netvt数据库.pmaster只能访问pmaster数据库.
grant,看grant语句,mysql手册。 如grant all on test.* to 'chiny'@'localhost' identified by 'lovexinli' 这个语句的意思就就是将test库的所有权限付给chiny,密码位'lovexinli',只能在本机 造作。当然可以将all换成具体的privilege.如grant select,update就是chiny只 允许select,update.
即config.inc.php中设置:
$cfg['Servers'][$i]['auth_type'] = 'cookie';// 或等于http在数据库的mysql数据库中的db表中设置.数据库和用户的对应关系.将有%的行删除.即:
Db User
--------------------
netvt netvt
pmaster pmaster
.
.
--------------------
其他的字段为主机及某种操作的相应权限.
这样用PHPMYADMIN登录后,netvt只能访问netvt数据库.pmaster只能访问pmaster数据库.
如grant all on test.* to 'chiny'@'localhost' identified by 'lovexinli'
这个语句的意思就就是将test库的所有权限付给chiny,密码位'lovexinli',只能在本机
造作。当然可以将all换成具体的privilege.如grant select,update就是chiny只
允许select,update.
INSERT INTO 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, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections) VALUES ('localhost', 'root', '6d097e022307831f', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0);
INSERT INTO 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, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections) VALUES ('localhost', 'user1', '6d097e022307831f', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0);
INSERT INTO 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, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections) VALUES ('localhost', 'user2', '034a8e457a676f03', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0);DB表:
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv) VALUES ('localhost', 'user1', 'user1', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv) VALUES ('localhost', 'user2', 'user2', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'Y');
我要实现一个功能:把一个.txt文件导入到mysql中,就像phpmyadmin工具里面的“从文本文件中提取数据,插入到表”的功能一样!l因为我PHP太差了,改PHPMYADMIN改了几天也不行!
可以吗?