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: 'root@localhost'
(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
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,