Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What if there is an error when phpmyadmin configures the connection mysql

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article is to share with you what to do when there are errors in phpmyadmin configuration and connection mysql. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Error occurred in phpmyadmin configuration connection mysql (transfer) [@ more@] Hello, I'm doing it again.

I encountered the following error when configuring the connection mysql with phpmyadmin:

Warning: Theme path not found for theme! In/ var/www/phpmyadmin/libraries/Theme_Manager.class.php on line 219

Fatal error: Call to a member function getName () on a non-object in/ var/www/phpmyadmin/libraries/common.lib.php on line 3135

My mysql,php,apache2, it all works.

Here are the changes to my config.ini.php configuration

/ *! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD!! * /

/ * $Id: config.default.php,v 1.8 14:07:10 on 2005-12-16 lem9 Exp $* /

/ / vim: expandtab sw=4 ts=4 sts=4:

/ * *

* phpMyAdmin default configuration, you can copy values from here to your

* config.inc.php

*

* All directives are explained in Documentation.html

, /

/ * *

* Your phpMyAdmin URL.

*

* Complete the variable below with the full url ie

* http://www.your_web.net/path_to_your_phpMyAdmin_directory/

*

* It must contain characters that are valid for a URL, and the path is

* case sensitive on some Web servers, for example Unix-based servers.

*

* In most cases you can leave this variable empty, as the correct value

* will be detected automatically. However, we recommend that you do

* test to see that the auto-detection code works in your system. A good

* test is to browse a table, then edit a row and save it. There will be

* an error message if phpMyAdmin cannot auto-detect the correct value.

, /

$cfg ['PmaAbsoluteUri'] =' http://192.168.1.120';

/ * *

* Disable the default warning that is displayed on the DB Details Structure page if

* any of the required Tables for the relationfeatures could not be found

, /

$cfg ['PmaNoRelation_DisableWarning'] = FALSE

/ * *

* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If

* at least one server configuration uses' cookie' auth_type, enter here a

* passphrase that will be used by blowfish. The maximum length seems to be 46

* characters.

, /

$cfg ['blowfish_secret'] =' cookie'

/ * *

* Server (s) configuration

, /

$I = 0

/ / The $cfg ['Servers'] array starts with $cfg [' Servers'] [1]. Do not use

/ / $cfg ['Servers'] [0]. You can disable a server config entry by setting host

/ / to'. If you want more than one server, just copy following section

/ (including $I incrementation) serveral times. There is no need to define

/ / full server array, just define values you need to change.

$iTunes +

$cfg ['Servers'] [$I] [' host'] = 'localhost'; / / MySQL hostname or IP address

$cfg ['Servers'] [$I] [' port'] =''; / / MySQL port-leave blank for default port

$cfg ['Servers'] [$I] [' socket'] =''; / / Path to the socket-leave blank for default socket

$cfg ['Servers'] [$I] [' connect_type'] = 'tcp'; / / How to connect to MySQL server (' tcp' or 'socket')

$cfg ['Servers'] [$I] [' extension'] = 'mysql'; / / The php MySQL extension to use (' mysql' or 'mysqli')

$cfg ['Servers'] [$I] [' compress'] = FALSE; / / Use compressed protocol for the MySQL connection

/ / (requires PHP > = 4.3.0)

$cfg ['Servers'] [$I] [' controluser'] =''; / / MySQL controluser settings

/ / (this user must have read-only

$cfg ['Servers'] [$I] [' controlpass'] =''; / / access to the "mysql/user"

/ / and "mysql/db" tables.

/ / The controluser is also

/ / used for all relational

/ / features (pmadb)

$cfg ['Servers'] [$I] [' auth_type'] = 'cookie'; / / Authentication method (config, http or cookie based)?

$cfg ['Servers'] [$I] [' user'] = 'root'; / / MySQL user

$cfg ['Servers'] [$I] [' password'] =''; / / MySQL password (only needed

/ / with 'config' auth_type)

$cfg ['Servers'] [$I] [' only_db'] =''; / / If set to a db-name, only

/ / this db is displayed in left frame

/ / It may also be an array of db-names, where sorting order is

The above is what to do when there are errors in phpmyadmin configuration and connection to mysql. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report