Access Databases

[greenp10]

I am using PHP to access and update an Access Database. Does x10Hosting support this, and if so is there any special configurations, locations, or database names I need to use?

Thanks,
Green Lamar

Email: HighlanderGreen67@gmail.com
web: http://www.greenproductions.x10.mx

 

[descalzo]

x10hosting only supports the mySQL databases that come with your account.

 

[greenp10]

OK, Then would it be possible for me to run PHP from x10 that updated an Access Database on another server?
Thanks,
Green Lamar

 

[Skizzerz]

While technically possible, this goes far beyond what we offer official support for, so you will need to ask elsewhere if you need assistance for it. Your best bet is to use MySQL as your database, which you can access directly from your account.

 

[greenp10]

And how would I access my MySQL database from my account. I have rewritten the PHP to connect to MySql, but need the connection details.
Thanks

 

[descalzo]

cPanel --> phpMyAdmin

Create a user. If you call him "foo" his full name will be "yourcPanelUserName_foo" . Write down the password.
Add him to your database with ALL PRIVILEGES checked.

Using PHP, the host name is "localhost" and the username, password, database name (remember it starts "yourcPanelUserName_" ) you know.

Note: for new code it is best to use PDO (or mysqli ) -- not the mysql_ functions. PHP is going to drop the mysql_ functions in the near future.

 

[greenp10]

Thanks a bunch.. Looks like it is working. Just need to twead a few things on my end.