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]
