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

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 forgotten

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:

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 that use

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 about it

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 mysql field (e.g.

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. Is there an easy

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 )

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 there must be some white

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 the characters that are