troubleshooting Question

MYSQL 4.1 CREATING HEADACHE: /usr/bin/mysqladmin: unable to change password; error: 'Access denied for user ''@'localhost' to database 'mysql''

Avatar of supercell29
supercell29 asked on
Databases
3 Comments1 Solution2678 ViewsLast Modified:
Good afternoon,

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.

mysql>

/etc/hosts:

# IP-Address  Full-Qualified-Hostname  Short-Hostname
#

127.0.0.1       localhost
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!

Supercell29
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros