Shulou(Shulou.com)06/01 Report--

This article introduces the knowledge of "common problems in phpmyadmin installation in CentOS system". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Question 1:

Phenomenon: the CentOS system enters the top of the phpMyAdmin page and displays:

Deprecated: Function eregi () is deprecated in/ usr/local/apache/htdocs/phpmyadmin/libraries/select_lang.lib.php on line 146Deprecated: Function eregi () is deprecated in/ usr/local/apache/htdocs/phpmyadmin/libraries/select_lang.lib.php on line 147,

Reason: php version 5.3.0, eregi () function is not supported

Solution: replace the eregi () function in select_lang.lib.php with the preg_match () function

Prompt after running:

Warning: preg_match () [function.preg-match]: No ending delimiter'^ 'found in/ usr/local/apache/htdocs/phpmyadmin/libraries/select_lang.lib.php on line 146Warning: preg_match () [function.preg-match]: Unknown modifier' ('in/ usr/local/apache/htdocs/phpmyadmin/libraries/select_lang.lib.php on line 147'

You can add'/'at the beginning and end of the * parameters of preg_match in select_lang.lib.php. After modification, if there is no change in browsing, clear the cache and browse again, and the display will be normal.

Question 2:

Phenomenon: when the CentOS system enters the phpMyAdmin page, it displays: Wrong permissions on configuration file, should not be world writable

Reason: it is the problem of phpmyadmin directory permission setting. This prompt will appear if you put all the files of phpmyadmin chmod 777.

Solution: just modify the file attributes. Phpmyadmin should run under the permission of 755, and the terminal should run sudo chmod-R 755 phpmyadmin/.

Question 3:

Phenomenon: CentOS system login prompt "Host '221.5.8.141' is not allowed to connect to this MySQL server"

Reason: permission problem

Solution: > mysql-u root-p > 123mysql > use mysql mysql > grant select,insert,update,delete on *. * to root@'221.5.8.141' identified by '123'

Remarks: GRANT SELECT,INSERT,UPDATE,DELETE ON [db_name]. * TO [username] @ [ipadd] identified by'[password]'

[username]: user code for remote login

[db_name]: indicates that the database to be opened to users is called

[password]: user password for remote login

[ipadd]: IP address or DNS Name after IP check. Enter'60-24832-13.HINETcopyright IP.hinet.net' in this example, and quote (') in the package (actually, it is executed on the remote server. Enter the ip address of the local host. If you want to open all permissions, execute:

Mysql > update user set select_priv='Y',Insert_priv='Y',Update_priv='Y', delete_priv='Y',Create_priv='Y',Drop_priv='Y',Reload_priv='Y', shutdown_priv='Y',Process_priv='Y',File_priv='Y',Grant_priv='Y', references_priv='Y',Index_priv='Y', Alter_priv='Y', Show_db_priv='Y', Super_priv='Y' Create_tmp_table_priv='Y',Lock_tables_priv='Y', Execute_priv='Y',Repl_slave_priv='Y',Repl_client_priv='Y'where User=' [username]' This is the end of the content of "Common problems when installing phpmyadmin in CentOS system". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.