On Apr 12, 2005, at 2:30 PM, Dan White wrote:
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 ?
No, you still need to change the root password for mysqld :-) just use localhost for root stuff, and all will work.
-chris zubrzycki - -- PGP public key: http://homepage.mac.com/beren/publickey.txt ID: 0xA2ABC070 Fingerprint: 26B0 BA6B A409 FA83 42B3 1688 FBF9 8232 A2AB C070 ======================================================== "Of course, you realize this means war." -B. Bunny
------------------------------------------------------- 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
