On 5/16/05, Duncan Lithgow <duncan@xxxxxxxxxxxxxxxxxx> wrote:
> This seems kinda odd as well, I can get mysql as user, but not as root:
> [root@3e6b36fa ~]# mysql
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
> [root@3e6b36fa ~]#
>
try this
[root@3e6b36fa ~]# mysqladmin -u root password "newpassword"
Note: the root user for mysql is different than the root(superuser) of Linux.
"newpassword" here is the password for the user root.
now you have to login as
[root@3e6b36fa ~]# mysql -u root -p
It will ask for the password of the root user(mysql root user) ,give
the correct password.After successful authentication you will log into
the mysql prompt
give the access rights to the users.
Regards
Ankush Grover
