nckswt Posted October 18, 2008 Share Posted October 18, 2008 I've been searching for hours to find a solution to the error that I receive whenever I attempt to access privileges in phpMyAdmin. I've tried running the mysql_fix_privilege_tables function, but every time I do, I'm met with: I've found the full text of the script I'm trying to run, and tried to simply copy/paste that and run it, but that leaves me with yet another error message. As much as I've tried to figure this out on my own, I'm fairly new when it comes to PHP and mySQL, and I can't seem to work this out. Can anyone help? Specs: Server version: 4.1.14 MySQL client version: 3.23.49 phpMyAdmin - 2.11.9 PHP MySQL library version 3.23.49 Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/ Share on other sites More sharing options...
nckswt Posted October 18, 2008 Author Share Posted October 18, 2008 If it helps, the way I'm trying to run the script is by simply writing mysql_fix_privilege_tables in the Run SQL query/queries on server "mysql" box that pops up when I click on SQL in the top left-hand corner of my screen. Is this the right way to run a script? Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-668737 Share on other sites More sharing options...
nckswt Posted October 19, 2008 Author Share Posted October 19, 2008 Also, I'm using phpMyAdmin on Yahoo, if that makes any difference, and (from what I understand) I'm using a console rather than a stripped-down command line interface (this thread deals with my exact problem, though I can't seem to solve it). Again, forgive my inexperience, but how do I create a .sql file on a mac? I haven't been able to figure that out either, and so I haven't been able to simply try uploading the mysql_fix_privilege_tables script. Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-669409 Share on other sites More sharing options...
Maq Posted October 20, 2008 Share Posted October 20, 2008 Seems like you have to run this in a command prompt, have you tried that? mysql -u username DB_NAME Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-670180 Share on other sites More sharing options...
Maq Posted October 20, 2008 Share Posted October 20, 2008 *** Make sure you're in the same directory as the .sql script. Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-670181 Share on other sites More sharing options...
fenway Posted October 20, 2008 Share Posted October 20, 2008 Open that .sql file and look at line 1. Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-670217 Share on other sites More sharing options...
nckswt Posted October 24, 2008 Author Share Posted October 24, 2008 Thanks for the help, but I've hit another roadblock. Now that I've uploaded the script and tried to run it, I get stuck with this error: Any suggestions? I really appreciate it. Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-673354 Share on other sites More sharing options...
fenway Posted October 24, 2008 Share Posted October 24, 2008 Hmmm..... did you select a DB? Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-673368 Share on other sites More sharing options...
nckswt Posted October 24, 2008 Author Share Posted October 24, 2008 Yeah, I've been trying that through my newly created 'wordpress' database. I used to have another database called 'wordpress' but I've been trying to reinstall it, so I removed the old one. If I try creating a separate database, say, "wp," the error changes to #1146 - Table 'wp.user' doesn't exist Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-673396 Share on other sites More sharing options...
fenway Posted October 24, 2008 Share Posted October 24, 2008 I'm not sure how you mean. Quote Link to comment https://forums.phpfreaks.com/topic/128992-upgrading-privilege-table-structure-help/#findComment-673779 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.