Member Avatar for Kieran Y5

Hi,

I am developing a program which requires access to my websites' MySQL. I keep getting errors trying to connect to it. My firewall is allowing the connection but MySQL won't accept it.

How can I solve this problem?

Thanks in advanced
Kieran :)

  • 3 Contributors
  • 3 Replies
  • 170 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Kieran Y5
Member Avatar for pritaeas

Perhaps your user does not have remote access rights.

Member Avatar for smantscheff

You have to grant the appropriate permissions on your MySQL DB. See http://dev.mysql.com/doc/refman/5.0/en/grant.html
In the MySQL client you have to enter something like:

Grant all privileges on * to myName@% identified by `myPassword`

or, more restrictively,

Grant all privileges on * to myName@myHomeIP identified by `myPassword`

and a

Flush privileges

afterwards.

Member Avatar for Kieran Y5

You have to grant the appropriate permissions on your MySQL DB. See http://dev.mysql.com/doc/refman/5.0/en/grant.html
In the MySQL client you have to enter something like:

Grant all privileges on * to myName@% identified by `myPassword`

or, more restrictively,

Grant all privileges on * to myName@myHomeIP identified by `myPassword`

and a

Flush privileges

afterwards.

Thanks, I didn't think it was so easy :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.