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 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 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 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?