In pset7 I've created the database successfully in phpmyadmin but when I click on "users" to open the table I get an error message:
"#1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist.
I've found some solutions but they all involve modifying settings I'm not confortable with.
I've tried update50 but the problem is still there.
What should I do?
2 Answers
Just had the same problem. The comments give clues and partial answers, but not complete details. curiouskiwi provided a complete solution:
1) run sudo dpkg-reconfigure phpmyadmin
in a terminal window.
IMPORTANT: ACCEPT ALL DEFAULTS GIVEN. Changing defaults may not result in a complete fix.
2) Next, run sudo service apache2 restart
This is described at https://cs50x.slack.com/files/curiouskiwi/F04CWT6RN/Problem_Set_7_PHPMYADMIN_problems
I was also having this problem. The fixes:
sudo dpkg-reconfigure -f noninteractive phpmyadmin
and sudo service apache2 restart
were not working.
I duckedduckedgo a bit, tried a few suggestions and the one that solved it was this one here:
Modifiy the configuration file config.inc.php.
Change:
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
into:
$cfg['Servers'][$i]['pma__table_uiprefs'] = ‘pma__table_uiprefs’;
-
-
Just type
sudo gedit /etc/phpmyadmin/config.inc.php
at a terminal window. Save and you should be good to go :)– JoséNov 16, 2015 at 13:12 -
mysql -u <your mysql username> -p
. You will be prompted for a password. Enter your mysql password and you are in. Just type your queries as normally.sudo dpkg-reconfigure phpmyadmin
in your terminal and answeryes
for a request to re-install PMA. Then restart apache withsudo service apache2 restart
.shell
,bash
,terminal
etc. are alternative names for your command line interface. So, "On the shell:locate create_tables.sql
" means: run commandlocate create_tables.sql
in your terminal window.