Unable to set root password on new mysql install
I've freshly installed CentOS v 5.2.
I've freshly installed MySQL:
yum install mysql mysql-devel mysql-server php-mysql
All seems to have gone well, I see no error messages.
I then did this to make sure MySQL starts when the server powers up (and started mysql):
chkconfig --levels 235 mysqld on
Now, I do this to see if networking is enabled:
netstat -tap | grep mysql
It tells me this:
tcp 0 0 *:mysql *:* LISTEN 22430/mysqld
However, when I try to set the root password:
mysqladmin -u root password xxxxxxxx
I get this:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Any ideas? File permissions issue?