On Friday 03 March 2006 09:49 am, Matt Price wrote: > Hi folks, > > a while ago I switched over to mysql-5.0, then forgot about it > entirely. Now I'm back to configuring some programs that use mysql, > and... I can't seem to login as root or any other user. > > One option is just that I've forgotten all my passwords (it's been a > while since I used any of the programs directly). Another is that > some configureation issue has reset permissions or something. In any > case I would like to avoid losing all my databases, so I'm wondering > whetherthere's any way to force a reset of theroot password, or > decrypt the permissions table, or whatever.
if you installed using apt, you should have a file called /etc/mysql/debian.cnf . you should be able to use that username and password to log in and reset your password. > > I am *not* a cracker, I'm just a little incompetent. > > APpreciate any help you might give. > > Thanks, > > Matt > > > -------------------------- > .''`. Matt Price > > : :' : Debian User > > `. `'` & hemi-geek > `- > -------------------------- -- anoop [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
