Re: lost mysql root password

2006-03-03 Thread anoop aryal
On Friday 03 March 2006 04:38 pm, Gene Heskett wrote: > On Friday 03 March 2006 17:08, anoop aryal wrote: > >On Friday 03 March 2006 03:12 pm, Matt Price wrote: > >> > do: > >> > > >> > select hex(User) from user where User LIKE 'root%'; > >> > > >> > > >> > that should give you the hex values of t

Re: lost mysql root password

2006-03-03 Thread Gene Heskett
On Friday 03 March 2006 17:08, anoop aryal wrote: >On Friday 03 March 2006 03:12 pm, Matt Price wrote: >> > do: >> > >> > select hex(User) from user where User LIKE 'root%'; >> > >> > >> > that should give you the hex values of the characters that are >> > there. >> > >> > > have all four. I guess

Re: lost mysql root password

2006-03-03 Thread Nevruz Mesut Sahin
maybe you are not using linux debian distribution. So this way is geereal way. You can setup same version of mysql in an other machine create new mysql root password there and copy. all files under (if your mysql datadir is an other location, look the place of it from /etc/my.cnf ) /var/lib/

Re: lost mysql root password

2006-03-03 Thread anoop aryal
On Friday 03 March 2006 03:12 pm, Matt Price wrote: > > do: > > > > select hex(User) from user where User LIKE 'root%'; > > > > > > that should give you the hex values of the characters that are there. > > > > > have all four. I guess there must be some white space in the username > > > somewhere.

Re: lost mysql root password

2006-03-03 Thread Matt Price
> > do: > > select hex(User) from user where User LIKE 'root%'; > > > that should give you the hex values of the characters that are there. > > > > > 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 > > my

Re: lost mysql root password

2006-03-03 Thread anoop aryal
On Friday 03 March 2006 02:20 pm, Matt Price wrote: > 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 ab

Re: lost mysql root password

2006-03-03 Thread Matt Price
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 t

Re: lost mysql root password

2006-03-03 Thread Sergio Cuéllar Valdés
On 3/3/06, Matt Price <[EMAIL PROTECTED]> 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. Hi, take a look at: http://dev.mysql.co

Re: lost mysql root password

2006-03-03 Thread anoop aryal
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 forgot

lost mysql root password

2006-03-03 Thread Matt Price
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 th