Thanks everyone for your help, see below for more: On 3/3/06, anoop aryal <[EMAIL PROTECTED]> wrote: > 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.
> 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. > this seemed the simplest of the options presented to me, and fortunately, voila! it owrked. I logged in, and had to use GRSNT statements to reset permissions: mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'apassword' with grant option; that worked fine. THen I was looking around and I notice that the user password seemed to have some dublicate rows in it: +--------------------------------------------------------------+------------------+-------------------------------------------+ | host | User | Password | +--------------------------------------------------------------+------------------+-------------------------------------------+ | localhost | root | hast 1 | anarres | root | hash 1 | | localhost | root | hash 2 | % | root | hash 2 +--------------------------------------------------------------+------------------+-------------------------------------------+ [passwords are of course hidden in the above] hmm, that's odd I thought. what to do? It got odder when I tried: select * from user where User='root'; then only the second set of records showed up. on the other hand, mysql> select User from user where User LIKE 'root%'; have all four. I guess there must be some white space in the username somewhere. Is there an easy way to identify the precise value of a mysql field (e.g. by dumping to a CSV file)? I'd like to try to figure out what went wrong, and deletethe defective lines. Thanks again for your help, it's so great to have this working. Matt > > > > > > 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] > >