Mysql>GRANT SELECT ON mysql.db TO SELECT (Host, User, 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, Shut_db_priv, Super_priv, create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv) ON er TO SELECT (Host,Db, User,Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO & MYSQLĪpache, PHP, and MySQL Installation - Method AĪpache, PHP, and MySQL Installation - Method BĪrrays II - adding, removing, and merging elementsĬreating Dynamic Content II - Form ValuesĬookies and Sessions I - Setting and Getting CookiesĬookies and Sessions II - Access Limit and Starting a SessionĬookies and Sessions III - Cookie vs SessionĬreating MySQL Database and Table II - Table and QueryĬreating MySQL Database and Table III - Retrieving and Sorting DataĬreating MySQL Database and Table IV - mysqldump etc. Mysql>GRANT USAGE ON mysql.* TO IDENTIFIED BY 'pmapass' If we have edited for Muti-User(untrusted) environment then go to mysql command prompt and perform the following steps to create mysql user - 'pma' identfied by pass 'pmapass'.For a multiuser (untrusted) environment, update as:.If we type in into the browser, we can bypass login sesstion and go directly into myadmin: For a single-user (root or trusted) environment (This is my case), update as:.For a personal server running behind a firewall, config may be desirable whereas a multi-user facility (such as an ISP) will want to use cookie or http. There are a number of authentication methods we may want to choose depending on our specific needs.
0 kommentar(er)
