Reopen your my.ini SQL configuration file, and remove the skip-grant-tables line you added. Remember that security hole we opened in step two? Time to fix that. You should get some sort of message saying that one line (of database code) was affected, with some warnings (probably because you are messing with the root user.I think you can safely ignore these). Copy the following block of code and paste it at the prompt. Now open the MySQL console: click MySQL > MySQL ConsoleĪ "DOS-like" terminal window will open up (if it asks you for a password, simply press enter). Resume MySQL services in Wamp (click MySQL > Service > Start/Resume Service). This is a major security hole, so once we are done with our repairs, we'll need to undo this! Save the my.ini file. This tells the MySQL database that you want to override any restrictions such as root user or password parameters. Immediately after this entry, insert a new line containing the following command: Use a text editor, and scroll down in the my.ini file to. ClickĮdit your MySQL's my.ini file.that's your configuration file for your SQL database, and it's generally located in the root folder for your MySQL database (try looking in wamp > bin > mysql > mysql5.5 ). To give proper credit, I had to blend answers provided by two people: RiggsFolly's answer to this question on resetting the root password in wamp, which is what I'm using, and jm666's answer for this question on restoring a deleted root user in MySQL using MAMP on OS X.Ĭlick on the Wamp system tray icon to bring up the tray menu. Please keep in mind that I am a newbie at this! I am trying different things, but without any success.that is why I'll probably need step-by-step instructions. ![]() However, I have been unsuccessful in starting mysql with the -skip-grant-tables option from outside mysql.exe, and when I try to do it from within mysql.exe, I just get an odd prompt ("->") and no other commands seem to work. I've tried to access MySQL using a terminal connection: in the MySQL root folder there is a file called mysql.exe that seems to grant this when executed (there is no "mysql_safe.exe" as some solutions have suggested). ![]() There is no file called "resetroot.bat" anywhere in the wamp/sql folders, as someone suggested.so that option is out.I'd hate to see months of work go down the drain!ĮDIT: Using Windows, I've tried the following: However, it seems I can still move around in phpMyAdmin (maybe because I'm still logged in?).Ĭould someone please tell me step-by-step how (if?) I can re-add the root users using phpMyAdmin? I see instructions posted in various places, but they seem to address users who are using terminal windows or some other program. Immediately things stopped working.and now, when I click on the "Users" tab in phpMyAdmin, it simply returns a red bar that says "No Privileges".my specific superuser is gone. I thought that since I created my own superuser with "All Privileges," I didn't need the root users.so I deleted them. I was working in phpMyAdmin to change the password of a superuser I had set up with a login-name other than "root." While doing so, I saw three additional "root" users, and on the phpMyAdmin home page, a warning about these root users not having a password. I'm test-running a Joomla installation (locally, using WAMP) with an MySQL database supporting it.this is in preparation to moving everything online once I have it configured.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |