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? Quote 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. Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/22546-phpmyadmin-problem/#findComment-101283 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.