It's not a file it's in the database.
telnet to the server and login to mysql using the mysql client util like
this
mysql -u root -p
then hit enter and enter the password.
now do these commands to create a remote super user
mysql> GRANT ALL PRIVILEGES ON *.* TO
monty@youripaddresshere_or_%_for_all_or_example_192.%
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
that's it. For further fine tunning on privilages please visit www.mysql.com
and go to there documentation section. There you will find all you need to
know about creating users.
Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax: 519-442-0429
-----Original Message-----
From: Matt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 7:42 PM
To: [EMAIL PROTECTED]
Subject: Host IP is not allowed to connect this MySQL server
Hello, I am trying to connect to a remote MySQL server of mine and I get
this error " Host IP is not allowed to connect this MySQL server " If
someone could give me the shortcut to this file so I can edit it to
allow me in- It would be greatly appreciated.
Thank You
Matt
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
