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).
-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
_________________________________________________
This message is encoded using the Rot-26 encoding method. Unauthorized decoding of this message may result in extreme penalties under the DMCA. These penalties include, but are not limited to: US $100,000 fine, life imprisonment, castration, death, limp hair, terminal halitosis, and amputation of the extremities.
------------------------------------------------------- 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 Fink-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fink-users
