On Tue, 12 Apr 2005, Chris Zubrzycki wrote:
On Apr 12, 2005, at 12:44 PM, Dan White wrote:
Hello, folks.
I installed mysql.
It says:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /sw/bin/mysqladmin -u root password 'new-password' /sw/bin/mysqladmin -u root -h Big-Sunflower.local password 'new-password' See the manual for more instructions.
OK, so I try to do this.
(/sw/bin/mysqladmin -u root password 'new-password') runs OK, but when I try (/sw/bin/mysqladmin -u root -h Big-Sunflower.local password 'new-password'), it grouches at me, saying:
/sw/bin/mysqladmin: connect to server at 'Big-Sunflower.local' failed
error: '#HY000Host '10.0.1.201' is not allowed to connect to this MySQL server'
Anyone got a clue to share with me ?
Yes, you must connect to localhost. Mysql has different permissions depending on the ip you connect to. Only localhost is allowed for root access, unless you change it (bad idea).
OK, so what I get from this is "Leave it that way it is" as opposed to "Try and make it work".
Yes ?
Thanks for the response.
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Fink-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fink-users
