LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   MySQL root/host passwords (https://www.linuxquestions.org/questions/linux-software-2/mysql-root-host-passwords-182577/)

ridertech 05-17-2004 03:44 PM

MySQL root/host passwords
 
After installing MySQL, it tells me to set the root password using...

./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h $HOSTNAME password 'new-password'

Are these the same?

After starting the mysql.server, I ran the first command to set my root password and it worked. However, when I try to run the second command (w/ the -p option), it prompts me for my password. I then enter in the password I set on the first command, but it errors out w/ the following...

./bin/mysqladmin: connect to server at 'host' failed
error: 'Access denied for user: 'root@host' (Using password: YES)'

Am I doing circles here or is something bigger going wrong?

LuggerHouse 05-18-2004 01:16 PM

use mysqladmin -h localhost


All times are GMT -5. The time now is 03:35 PM.