MySQL Forums
Forum List  »  New in 4.1: Subqueries

Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
Posted by: girionis chrysaorides
Date: August 25, 2005 06:27AM

You simply need to do:

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON <dbname>.*
-> TO <username>@<host name>
-> IDENTIFIED BY '<password>';

where <dbname> is the name of the database you are tyring to connect to, <username> is the username of the user trying to connect to the database, <host name> the name of the host (in your case the XXX host) and <password> the password of the user.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
77874
August 25, 2005 06:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.