Dear all,
when i enter mysql iam facing the below error.
I have done the below configuration.

Yum install mysql
Yum install mysql-server
Yum install mysql-devel
chgrp -R mysql /var/lib/mysql
chmod -R 770 /var/lib/mysql
Configuration

/usr/bin/mysqladmin -u root password 'ecare2@'
service mysqld restart
can any one help me on this

[root@ram ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Thanks,

maybe this:

I gave the above command iam facing the below error

[root@loft5077 ~]# /usr/bin/mysqladmin -u root@localhost password 'ecare2@'
/usr/bin/mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'

There is any other way to reset by root login

Thanks,

Did you read your first post, and try to look up that error??
That error is very clear...root user access for mysql has been denied from local host, or you don't need a password for the root user (more likely). Again, a brief search would have turned up LOTS on this, if you bothered to look. And putting an "@" in your password is as much of a bad idea as putting dashes in your database name.

Have you tried just leaving off the password?? Just su into the root user, and type in "mysql", and see what happens. Read the info pages in the MySQL docs on the grant command.

iam able to login without password,
mysql -u root -p
but when i login without i was not able to view mysq database and how can i give password for root and how can i give permission for mysql database,can anyone help me.


Thanks,

Again, leave off the password. That means, leave off the -p option. Also, as said before, if you log in as root and just type in "mysql", that may work and was suggested too. Have you tried that????

And again, did you TRY to look this up?? First hit in Google:
http://dev.mysql.com/doc/refman/5.0/...rmissions-unix

Run following command as root
# mysql_secure_installation

and follow the prompts .... for current password prompt just press Enter.( Please read before pressing entry).

...and if the OP has the error they posted (specifically, root doesn't have access to the databases on localhost), resetting/removing the password won't make a difference. As it says in the link I posted, along with resetting the password, it has the command to grant root access, if it's been removed/changed: