Drezard Posted June 2, 2007 Share Posted June 2, 2007 I made a big MySQL Mistake. I deleted all the users from PHPMyAdmin. So now I cant access my MySQL database from PHPMyAdmin. How else can I add localhost to the MySQL databases user list? Regards, Daniel Quote Link to comment https://forums.phpfreaks.com/topic/54000-mysql-skrewup/ Share on other sites More sharing options...
per1os Posted June 2, 2007 Share Posted June 2, 2007 Windows you run command line Start > Run > cmd type mysql -uroot -prootpassword it shoudl get you in as long as you know the root password. If not I would search for a my.cnf somewhere to set that up. Once there you can use the create user syntax. Google MySQL Create User That should give you what you need to do. Quote Link to comment https://forums.phpfreaks.com/topic/54000-mysql-skrewup/#findComment-266941 Share on other sites More sharing options...
Drezard Posted June 2, 2007 Author Share Posted June 2, 2007 I really need some help. I have no clue what im doing. Installed XAMPP Then popped into PHPMyAdmin and deleted ALL the accounts (Including Root) thats how skrewed i am. Is there anyway i could uninstall XAMPP And reinstall it and it would be all good? Or what else are my options? Quote Link to comment https://forums.phpfreaks.com/topic/54000-mysql-skrewup/#findComment-266952 Share on other sites More sharing options...
per1os Posted June 2, 2007 Share Posted June 2, 2007 Yea you can do that, never worked with XAMPP. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html That might be interesting reading for you. Quote Link to comment https://forums.phpfreaks.com/topic/54000-mysql-skrewup/#findComment-266957 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.