![]() Help technology for teaching, learning and assessment for courses taught at Oxford & at a distance.Technology for teaching, learning and assessment: assistance and software development. For security, you should set a password for the MySQL admin user in the XAMPP Security panel: Categories Technical Tags mysql, password, phpmyadin, roo, xampp You can then login to MySQL/PHPMyAdmin using the username root and no password. ![]() ![]() Run resetroot.bat – this should reset the MySQL root password and privileges.Change the datadir parameter to the path to your data directory – the one shown is the default. Add “–datadir=c:/xampp/mysql/data” into the “mysql\bin\mysqld.exe…” line (line 18), after “–no-defaults”.Open mysql/resetroot.bat in a text editor.The instructions boil down to the following: I did the usual thing of searching for solutions online, and after trying a few different things involving the command line and MySQL Workbench, I came across this Apache Friends forum thread. ![]() While setting up a wordpress site locally for testing, I managed to remove the global privileges of the root user in PHPMyAdmin, thinking it was the user for the wordpress database. It’s still annoying when I lock myself out of all my databases though! We use XAMPP for our local development (on Windows), and I have a habit of messing around with the database and doing bad things by mistake, because it’s only for local development, so it doesn’t matter that much. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |