Page 1 of 1

installing phpMyAdmin 3.x with advanced features

Posted: Thu Dec 04, 2008 9:59 am
by mindplay
I have spent several evenings trying to configure phpMyAdmin 3.x to run with the new advanced features, particularly the Design tab, with no luck.

I have tried both the latest version from SVN (3.2-dev) and the current release version (3.1), no luck with either of them.

My configuration file looks like this:

Code: Select all

 
/* Servers configuration */
$i = 0;
 
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['nopassword'] = true;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '...........';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
 
/* End of servers configuration */
 
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = dirname(__FILE__) . "/upload";
$cfg['SaveDir'] = dirname(__FILE__) . "/save";
$cfg['TempDir'] = dirname(__FILE__) . "/temp";
$cfg['blowfish_secret'] = '........................';
$cfg['MaxRows'] = 100;
 
I've read through the manual, and I believe this configuration should work?

I've installed the tables from 'scripts/create_tables.sql', and I've double-checked the privileges:

Code: Select all

 
mysql --user=pma --password=.... phpmyadmin
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 232
Server version: 5.0.67-community-nt MySQL Community Edition (GPL)
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from pma_relation;
Empty set (0.00 sec)
 
The table is there, and the 'pma' user clearly has access.

The manual says to double-check on Windows, that mysql isn't configured to use lower-case table and column names... it was, but I changed it, prior to installing the tables:

Code: Select all

 
mysql> show variables like '%lower_case%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | ON    |
| lower_case_table_names | 0     |
+------------------------+-------+
2 rows in set (0.02 sec)
 
It seems like those instructions may be outdated, though? I don't see any upper-case table or column names in any of the tables in the 'scripts/create_tables.sql' file.

It all looks right to me? Yet, no trace of the design tab, or any other advanced features - or even the link that the manual says is supposed to show up ... supposedly, this link would help you figure out why it's not working, but I don't see that link anymore - it was there at one point, but now it's gone, and still no advanced features.

Any clue what I'm doing wrong?

Re: installing phpMyAdmin 3.x with advanced features

Posted: Fri Dec 05, 2008 1:12 pm
by mindplay
Answer: Restart MySQL, Restart Apache.

Gah!

That was an interesting way to waste an evening ;-)

Re: installing phpMyAdmin 3.x with advanced features

Posted: Fri Dec 05, 2008 1:30 pm
by airy
I see you config phpmyadmin with user:root but login mysql with pma, WHY?