In the case below, MySQL has been installed via YaST using Suse's 9.3 Professional CD's. I have SuSE 9.3 running on an IBM xSeries 306 blade.
Server version: 4.1.10a
Host: linux.continentalweb.com (172.16.4.8) also within my /etc/hosts file (see below)
Host IP's (Apache server [same server]): 172.16.4.8, 172.16.4.9, 172.16.4.10, 172.16.4.11, and 172.16.4.12
I am logging in as the root user
Below is the ongoing issue I am having:
linux:~ # /etc/init.d/mysql start
Starting service MySQL done
linux:~ # /usr/bin/mysqladmin -u root password 'new-password' (THIS COMMAND WAS SUGGESTED JUST AFTER RUNNING MYSQL FOR THE FIRST TIME AFTER INSTALLING OFF SUSE 9.3's CD'S).
Here is the disappointing result:
/usr/bin/mysqladmin: unable to change password; error: 'Access denied for user ''@'localhost' to database 'mysql''
To show that the server itself is alright:
linux:~ # mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.10a
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
# IP-Address Full-Qualified-Hostname Short-Hostname
172.16.4.8 linux.continentalweb.com linux
Webmin will not allow me to change the root password either, nor create/delete anything.
Any suggestions would be much appreciated!