mahzkrieg Posted September 29, 2006 Share Posted September 29, 2006 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]ErrorSQL query: DocumentationEditSELECT label, idFROM `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 More sharing options...
Gaoshan Posted September 30, 2006 Share Posted September 30, 2006 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 More sharing options...
.josh Posted September 30, 2006 Share Posted September 30, 2006 FROM `phpmyadmin`.`pma_bookmark`you named your database phpmyadmin? Link to comment https://forums.phpfreaks.com/topic/22546-phpmyadmin-problem/#findComment-101283 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.