RE: Root password lost?; can't manage existing database...

2004-08-23 Thread Peter Lovatt
Hi the usual syntax is mysql -u root -p if that does not work look into skip grant tables option http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html HTH Peter -Original Message- From: DBS [mailto:[EMAIL PROTECTED] Sent: 23 August 2004 03:50 To: [EMAIL PROTECTED]

Re: Root password lost?; can't manage existing database...

2004-08-23 Thread Egor Egorov
DBS [EMAIL PROTECTED] wrote: I have a problem, It's been months since I used MySQL and (I believe) I had set it up with a root password. Now I can't log on to MySQL as root MySQL user and create a new user or manage an existing user (I can log onto server Familiar situation. :) Do so: