mysqladmin doesn't work with the when I add -p attribute to it

Niceman2005 · 04-26-2005, 09:58 PM

Dear friends,

I realised when I use the command mysqladmin to create new tables, it only work if I do not submit any password.

Say if I do the folloiwng
mysqladmin -uroot -p create mambodatabase
Then it will prompt me for password and if I press enter (without entering any password), it works fine.

But if enter the following command, the error below shows:

mysqladmin -uroot -p123 create mambodatabase
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

The difference between the previous and this command is the password I suppled in the command. Without the password "123" at the command, there wont be any problem creating the database.

I wonder if thats the reason my mambo installation has been unsuccessful so far, anyone who knows the problem, please help me.....
Thanks a million for taking note of my problem...

comprookie2000 · 04-27-2005, 07:11 PM

Have you done this;

Code:

As root:
#/usr/bin/mysql -u root
mysql>SET PASSWORD FOR ''@'localhost' = PASSWORD('your_new_password_here');
mysql>SET PASSWORD FOR ''@'hostname_or_dnsDomainName' = PASSWORD('its_new_password_here');