Results 1 to 3 of 3
Hi guys, recently I installed apace2 and mysql. I used phpMyAdmin tool to control the database and everything worked ok. But today I have deleted by mistake the root user ...
- 05-26-2008 #1Linux Newbie
- Join Date
- Feb 2006
- Location
- Slovenia
- Posts
- 162
How to login to MySQL database?
Hi guys, recently I installed apace2 and mysql. I used phpMyAdmin tool to control the database and everything worked ok. But today I have deleted by mistake the root user from the database in the permissions section. How can I get my root account back. Actually it is a test database configuration, so I don't mind deleting the mysql database and settting it up once again, but I don't know hot to do that. I tried to reinstall mysql in mysql clinet using Yast, but once I created the database once again using command "mysql_install_db --user=mysql, the database users remained the same as before, so now I have just one user with little permissions to log in the mysql. What can I do? Thans for help.
- 05-26-2008 #2Blackfooted Penguin
- Join Date
- Apr 2006
- Location
- West Yorks
- Posts
- 4,344
Take a look here for a possible solution.
- 05-28-2008 #3Linux Newbie
- Join Date
- Feb 2006
- Location
- Slovenia
- Posts
- 162
Solved. When uninstalling mysql via yast it does not remove the configuaration files, so you have to clean up the remanining files of mysql manualy and install it again.
Reply With Quote 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts