Remote MySQL

Remote MySQL

Posted by: The
Posted on: 2007-10-01 21:07:00

how do I connect to my mysql using a php file on my comp?

I have a php file that runs from the command line, and When I run it, I get this error:

PHP Warning: mysqli_connect: (28000/1045) Access denied for user 'limited'@'6-17-177-3.dhp.roch.mn.charter.com' (Using password Yes) in C:phprobotsspider1.php on line 7

Re: Remote MySQL

Posted by: rlparker
Posted on: 2007-10-01 21:16:00

In the control panel, go to the Goodies -> Manage MySQL screen and click linked "user's name" to edit their configuration.

In the resulting screen, add the IP address of your host machine to the "allowable hosts" lists, save, and wait till it takes effect. All done!

--rlparker

Re: Remote MySQL

Posted by: Lensman
Posted on: 2007-10-01 21:49:00

Don't forget to change your username and password if you've accidentally given them to us above.

Re: Remote MySQL

Posted by: The
Posted on: 2007-10-01 22:31:00

Thaks... That works!!!

Re: Remote MySQL

Posted by: rlparker
Posted on: 2007-10-01 22:35:00

You're welcome, and I'm glad you got it sorted! smile

--rlparker

Tags: php filemysqliaccess deniedcharter