Hot answers tagged

12

I know this is something old -- so I'm posting here just in case someone stumbles in the same question. In the latest versions of phpMyAdmin the setting to flip is NavigationTreeEnableGrouping, i.e. in config.inc.php set: $cfg['NavigationTreeEnableGrouping'] = false; p.s. on localhost, config.inc.php is placed in /phpmyadminX.XX/ folder Or, for a ...


5

The package is called phpmyadmin3 for version 3.5 (on the epel repo). Read the doc to check about the recommended update procedure.


4

Using php7 and any OS packages will be difficult until distros (or third party repos) are updated to handle this and you really shouldn't do this on a production system. My advice is to not attempt this and wait until a PHP7 infrastructure is in place. You could work around by installing most things like PHPMyAdmin by hand, but this is not good system ...


4

The reason for this behavior are the dependencies of phpmyadmin (at least in Debian, and I think it's quite similar in Ubuntu): # apt-cache show phpmyadmin | grep Depends: libapache2-mod-php5 | libapache2-mod-php5filter | php5-cgi | php5-fpm | php5, php5-mysql | php5-mysqli | php5-mysqlnd, php5-mcrypt, php5-json, perl, debconf (>= 0.5) | debconf-2.0, ...


4

Took me a while to figure this out. Trick was to enable "table_info" in the config.inc.php, like so: $cfg['Servers'][$i]['table_info'] = 'pma_table_info';


2

You realize all the configuration lines are commented out? You need to uncomment and fill-in those fields for anything to happen. I think including this one would be sufficient (assuming you want it to prompt you for a username/password): $cfg['Servers'][$i]['auth_type'] = 'cookie';


2

You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. Find your config.inc.php file under the phpMyAdmin installation directory and update the line that looks like this: $cfg['Servers'][$i]['password'] = 'password'; ... ...


2

You can disable grouping by setting LeftFrameDBTree to false: $cfg['LeftFrameDBTree'] = false; UPDATE: the option was renamed to NavigationTreeEnableGrouping in phpMyAdmin 4.0.0.0 (2013-05-03).


2

I have resolved the issue. Indeed, my config file was being ignored. I had been copying config.inc.sample.php to config.inc.php in the top level directory of the website (/var/www/html/pma). However, on CentOS 6 there is a separate config directory -- /etc/phpMyAdmin/. Once I copied my config there, everything works ok.


2

The STABLE branch should always match the current release. That's the best branch to track if you wish to use git to stay updated but not on the development version (master, which is rarely actually broken but still not for general development use). I have no idea why you saw a delay on the update -- if it happens again, you should probably contact the ...


2

Apperently you also configured the Webtatic yum repository to get a newer version of PHP (php56w) than what is included by default in CentOS or provided by EPEL. That conflicts with the PHP version the EPEL phpMyAdmin package expects. It could well be that phpMyAdmin still works well with a (much) newer PHP version and then the suggested --skip-broken is a ...


2

The safest would be running it on a (sub)domain you own. This way you could request a CA signed certificate. If you really want to run phpMyAdmin on an IP over SSL you could install a self-signed certificate. However this means the users will get a warning the first time they visit the page and will need to accept the certificate manually. (This also means ...


1

Here is an example of a working configuration for nginx and phpMyAdmin http://pkgs.fedoraproject.org/cgit/phpMyAdmin.git/tree/phpMyAdmin.nginx This is the file include in the Fedora RPM (which cannot be in the CentOS package because of missing nginx configuration) Also see http://pkgs.fedoraproject.org/cgit/php.git/tree/nginx-php.conf ...


1

Look in the full processlist for the Host column of theses connections : show full processlist\G Take the host and port of one of theses connections. Then SSH to the source server, and search which process has make this connection : netstat -ntp |grep :theport At the end of the line you will have the pid/process name of your script.


1

I made it working with some changes in /opt/lampp/phpmyadmin/config.inc.php: Add a $i=1 after /* server parameters */ /* Server parameters */ $i = 1 AND fix tablespaces of phpMyAdmin as written in http://stackoverflow.com/a/11506495/2364405


1

just install an earlier version, I installed is http://sourceforge.net/projects/xampp/files/XAMPP%20Linux/5.6.12/


1

Reposting my comments above into an answer: Check /var/log/httpd/error_log for errors when you load the page - it might contain PHP error messages. Possibly also check /var/log/audit/audit.log for any SELinux block messages when you load that page. If there's anything useful in the logs, please add it to your question. -- update -- Check ...


1

Try set $cfg['Servers'][$i]['verbose'] $cfg['Servers'][$i]['verbose'] Type: string Default value: '' Only useful when using phpMyAdmin with multiple server entries. If set, this string will be displayed instead of the hostname in the pull-down menu on the main page. This can be useful if you want to show only certain databases on ...


1

you would need to use http://computerIP/phpmyadmin to access it. You will need to ensure that port 80 is open on the Firewall before attempting to connect.


1

http://www.phpmyadmin.net/documentation/#authentication_modes details that you would want to use 'config' authentication mode.


1

You need to set the appropriate SELinux boolean to allow the web server to communicate with MySQL. setsebool -P httpd_can_network_connect_db 1


1

(can't comment yet #*@%!) It seems relevant to precise that dependind on your linux distro, config file locations may vary. On my Debian (squeeze), /usr/share/phpmyadmin/config.inc.php contains a warning on the first lines, which I might well have missed : /** * Please, do not edit this file. The configuration file for Debian * is located in the ...


1

I had the same issue last night and was able to solve it. You'll need the gzrt package to repair the gzip. Here's how to fix it: Copy the beginning plaintext portion of your database.sql.gz file to a new file called database.sql Run gzrecover database.sql.gz Append the contents of database.sql.recovered into database.sql You might have to manually ...


1

There is a catalogue of problems with alias and try_files. You might want to consider using your old configuration hidden behind an internal rewrite: location /pma { rewrite ^/pma(.*)$ /phpmyadmin$1; } location /phpmyadmin { internal; ... }



Only top voted, non community-wiki answers of a minimum length are eligible