Jump to content

phpMyAdmin problem


mahzkrieg

Recommended Posts

I'm learning PHP and MySQL with a book, and got phpMyAdmin to help me with the MySQL management. I've made some tables so far but whenever I click on the SQL tab, I get this error message. Seems like it'd be a common problem, and googling the #1146 line yields some results that don't exactly help me. I suppose it's some config problem.
-----

[pre][b]Error

SQL query: DocumentationEdit

SELECT label, id
FROM `phpmyadmin`.`pma_bookmark`
WHERE dbase = 'seasons'
AND (
user = 'root'
OR user = ''
)
ORDER BY label

[color=red]MySQL said: Documentation
#1146 - Table 'phpmyadmin.pma_bookmark' doesn't exist [/color][/b][/pre]

-----
In my config.inc.php file, I have:
-----
[pre][b]$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
[color=red]$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';[/color]
$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';[/b][/pre]
-----
What's wrong?
Link to comment
https://forums.phpfreaks.com/topic/22546-phpmyadmin-problem/
Share on other sites

You need to first create a user named pma, define it in config.inc.php (controluser/controlpass) and then run the file: create_tables_mysql_4_1_2+.sql (assuming your version of MySQL is 4.1.2 or higher, of course)

It is in the phpmyadmin scripts folder. That should take care of your problem.
Link to comment
https://forums.phpfreaks.com/topic/22546-phpmyadmin-problem/#findComment-101273
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.