Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql root lock-out
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
zambizzi
Guru
Guru


Joined: 28 Aug 2004
Posts: 581
Location: Boise Idaho

PostPosted: Fri Sep 03, 2004 1:08 am    Post subject: mysql root lock-out Reply with quote

I'm not sure how this happened but I can't get into mysql. Either I typed the password wrong and can't figure out what it is or something else is going haywire.

Either way, I can't mysql -u root into mysql.

I thought perhaps uninstalling and re-installing would solve it but it still tells me "permission denied" after I've re-installed it.

Is there a file somewhere or something I need to purge/delete in order to "reset" me back to a new mysql installation where the root user doesn't have a password?

Thanks!

-v
Back to top
View user's profile Send private message
zambizzi
Guru
Guru


Joined: 28 Aug 2004
Posts: 581
Location: Boise Idaho

PostPosted: Fri Sep 03, 2004 2:14 am    Post subject: solved the problem... Reply with quote

Nevermind, solved it by searching high and low through the forums.

I did an ugly brute-force method by deleting everything in /var/lib/mysql/mysql

Code:

rm -rf /var/lib/mysql/mysql/*


...and then starting mysql & re-running the mysql_install_db script

Code:

/etc/init.d/mysql start

/usr/bin/mysql_install_db


Just in case anyone else runs into a scenario where they can't root-login to their mysql server!

-v
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum