Search Members Help

» Welcome Guest
[ Log In :: Register ]

Mini-ITX Boards Sale, Fanless BareBones Mini-ITX, Bootable 1G DSL USBs, 533MHz Fanless PC <-- SALE $200 each!
Get The Official Damn Small Linux Book. DSL Market , Great VPS hosting provided by Tektonic
 

[ Track this topic :: Email this topic :: Print this topic ]

reply to topic new topic new poll
Topic: MySql Help, Off topic< Next Oldest | Next Newest >
Max Offline





Group: Members
Posts: 211
Joined: July 2004
Posted: Mar. 10 2005,14:03 QUOTE

DSL forum probably isn't the place for this question, but I just like you guys better....

I recently upgraded MySQL on an SME (Red Hat based) distro from version 3 to version 4.  Anyway, as I was blissfully following the upgrade instructions it informed me that I should supply new root SQL passwords.  Well, I don't think it ever had these before and since I've done it my phpmyadmin won't connect to the DB from localhost anymore and other php apps I've written won't connect either.

Does anyone know of a way to "remove" those intialized passwords and set them back to the default value??  I'm the only one on the box, so I don't have to worry about anyone else gaining local access.

Note that I *can* also access (e.g. login) the DB via the MySQL Admin app from a Winblows box.

Any insights appreciated.....


--------------
Using DSL on: IBM T42, IBM 560x, Dell Dimension CPx
Back to top
Profile PM 
Matthew
Unregistered






Posted: Mar. 15 2005,17:41 QUOTE

On the default mysql install the default root password is blank. Try changing the password with "mysqladmin -u root -p password changeme" and hit return when prompted for a password. If that doesn't work you can try replacing the user database files in /var/lib/mysql/mysql. Get a copy of your old data base, or from another database where you know the root password.
Back to top
Max Offline





Group: Members
Posts: 211
Joined: July 2004
Posted: Mar. 18 2005,14:32 QUOTE

Thanks for the tips.  I'll give them a try...

--------------
Using DSL on: IBM T42, IBM 560x, Dell Dimension CPx
Back to top
Profile PM 
2 replies since Mar. 10 2005,14:03 < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

 
reply to topic new topic new poll
Quick Reply: MySql Help

Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code