Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have installed phpMyAdmin and it works fine. At the bottom of the pages however, there is this error message:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

In that page, the only red row is this:

$cfg['Servers'][$i]['userconfig'] ... not OK [ Documentation ] User preferences: Disabled

In the configuration I have this:

$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

The pma_userconfig was missing from my phpmyadmin db so I found the create_tables.sql from my phpMyAdmin installation and I ran that, then restarted apache and mysql. The table has been created, but the error is not gone.

Thanks!

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

After a reboot it is now working.

So the trick was to manually execute create_tables.sql, you can just copy everything into the phpMyAdmin sql window and execute it. This created the missing tables.

share|improve this answer
    
how to manually run create_tables.sql, –  Poovizhirajan.N Sep 11 '13 at 12:57
    
@Poovizhirajan.N access phpmyadmin, click on the SQL tab (without selecting any database) and paste the file contents there. Otherwise, start mysql from command line and feed it the file. The file can be found in the PhpMyAdmin folder, depending on your installation. In Ubuntu it was /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz (need to uncompress to use) –  Palantir Sep 11 '13 at 13:37
    
mysql -u root -p < create_tables.sql is this right??? –  Poovizhirajan.N Sep 11 '13 at 13:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.