Remote MySQL


#1

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:\phprobots\spider1.php on line 7


TzFiles.com


#2

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


#3

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

Free unique IP and $67 off with code [color=#CC0000]LMIP67[/color] or use [color=#CC0000]LM97[/color] for $97 off. Click for more promo code discounts


#4

Thaks… That works!!!


TzFiles.com


#5

You’re welcome, and I’m glad you got it sorted! :slight_smile:

–rlparker