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] > Subject: Root password lost?; can't manage existing database... > > > Hi, > > 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 > as root of course). I'm running MySQL 3.23 and RH Linux 8. The one > database that is running is running fine and no problems with it. It has > run so well with no problems I never tinker with it. > > When logged onto server as root, I enter the command "mysql -p -u root" I > get the error message: "ERROR 1045: Access denied for user: > '[EMAIL PROTECTED]' > (Using password: NO)" Also when I type in: 'mysql -p -u userone' > I also get > the same error so apparently I can't access the userone either. > I know what > the password is for userone but I don't understand why MySQL is > not allowing > me to enter it in. > > Actually I'm not even sure if I created a root password for MySQL. I do > know that I created a few users and a database which functions > correctly and > has been for months - it's linked to a discussion forum and works fine. > > However now I can't create any new users, and if I wanted to change the > password of the existing user - database, or root pw, I can't, or > don't know > how. > > Can anyone give me a hint as to what I need to do to either - > > a. reset the password for the root MySQL user (or log on as MySQL root > without a MySQL pw) so I can create new databases, manage the existing > database which is associated with a user. > > b. create a new user whether logged on as root or as the user > name of which > I want to create the new MySQL database and tables for. > > Thanks for any advice, > > DBS > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
