Re: Problem setting root password.

[gerald_clark]

Rob Yale wrote:

Hi folks,

The following is copied exactly from my machine, except for the munged
password.  Setting the root password can't be completed, because the host
apparently can't connect the mysql server.  What am I doing wrong?:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root  password 'new-password'
/usr/bin/mysqladmin -u root -h melody.yalemusic.ca  password 'new-password'
See the manual for more instructions.
NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting mysqld daemon with databases from /var/lib/mysql
[EMAIL PROTECTED] local]# /usr/bin/mysqladmin -u root password 'xxxxxxx'
You just successfully set the password.

[EMAIL PROTECTED] local]# /usr/bin/mysqladmin -u root -h melody.yalemusic.ca
password 'xxxxxxx'
/usr/bin/mysqladmin: connect to server at 'melody.yalemusic.ca' failed
error: 'Host 'melody.yalemusic' is not allowed to connect to this MySQL
server'
Two problems here.
1. You have one password per user. You set it above, but don't use it here.
2. Root can only connect via localhost until you GRANT privileges from 
elsewhere.
   You are trying to connect from melody.yale.ca.  This is not 
localhost, even though
   it is the same machine.

[EMAIL PROTECTED] local]#

Thanks,

Rob Yale

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]