Joomla Template password change failed

[PatchDog]

I am getting an error trying to change the password on the Joomla template. I am following the Wiki and this is what I am getting.

joomla:~# mysqladmin -u root -p admin
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

What am I missing here??? It cant be that difficult. Using Proxmox 1.5

 

[tom]

see wiki page:
http://pve.proxmox.com/wiki/Joomla!#Introduction

mysqladmin -u root -p password HERETHENEWPASSWORD

the current password is 'admin'.

 

[PatchDog]

I have done that. If I imput a password afterwards I still get prompted to input a new password. And I always get the same error.

 

[tom]

no, you posted that you did not.

enter the command, confirm with the current password (admin) and its changed.

 

[PatchDog]

Ok I deleted the VM and recreated a new one. log into it and this is the first thing I do. I am still getting the same error.

joomla:~# mysqladmin -u root -p admin mynewpassword
Enter password:mynewpassword
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user [EMAIL="'root'@'localhost'"]'root'@'localhost'[/EMAIL] (using password: YES)'
joomla:~#

What am I doing wrong?

 

[tom]

your are not entering the command I posted. enter this to change the password for example to 'secret':

mysqladmin -u root -p password secret

on the prompt, give the existing root password (admin).

 

[m.ardito]

patchdog,

"-p" and "password" are two indipendent commands/options to mysqladmin

"- p" tells mysqladmin "i will provid my current password later"

"password secret" tells mysqladmin "i want to change my current password to the word that follows, ie: 'secret' "

Marco

 

[tcindia123]

there is something error in database connection check config file

 

[noPa$$word]

Please try

mysqladmin --user=root --password=admin password NewPassword

K.W.

 

[PatchDog]

OK I got it. It was my lack of command knowledge and not knowing that "-p password" was the commmand itself. I was inputing "-p admin" thinking -p was the command and I had to supply the passord afterwards.

Thanks everyone for your help. I live in a windows world and still a linux noob. Always learning that why I love computers!

 

[tom]

yes, these mysql commands are confusing, glad to help.

 

[m.ardito]

see also http://www.cyberciti.biz/faq/mysql-change-root-password/
very confusing syntax indeed

Marco