Remote MySQL Dtabase

  • timblancke

    (@timblancke)


    12 years, 7 months ago

    I want to set up a running version (sandbox) of aa existing WP CMS within my local computer running Microsoft Expression.
    Currently the WP site runs fine on a 1&1 server which has the MySQL database. I have installed the Expression Development Server and PHP runs fine.
    However when I start up the development site I get an error message saying that the SQL extension is missing.

    I want to access the existing 1&1 database in my Expression development site.
    Question:
    How do I make Expression have access to the WP database?

    Thanks,
    Tim

Viewing 3 replies - 1 through 3 (of 3 total)
  • 2ninerniner2

    (@2ninerniner2)

    12 years, 7 months ago

    I have zero experience with MS Expression, but do have with remote MySQL connections.

    Not sure what you need to do on the MS-E front, but you will also need to configure your 1&1 MySQL databases to accept remote connections. In hosting accounts using appropriately configured cPanel, this is done with the Remote MySQL option in the Databases section.

    Thread Starter timblancke

    (@timblancke)

    12 years, 7 months ago

    Hi 2ninerniner2,
    Thanks for your quick reply. I think that you are right, but I, as usual, am having trouble getting it done.
    When I go to the 1&1 MySQL Admin screen I can see my database, and I also see the following statement:

    “Your MySQL databases are stored behind a firewall to protect your data. You can only access each one exclusively through your server. Direct access to your MySQL databases using a home PC (external ODBC connection) cannot be established.”
    I don’t see any option provided there for ‘Remote’.

    So I went to phpMyAdmin, but I couldn’t find any ‘Remote’ option there, either.

    I wonder if I have to do something in .htacess?
    Any ideas? And again, thanks for your reply.
    Tim

    2ninerniner2

    (@2ninerniner2)

    12 years, 7 months ago

    It would appear that 1&1 does not allow remote access to your databases.

    As I mentioned, the hosting I have uses cPanel, a brand name of hosting control panel software, which in this case, is configured to provide remote connections to the databases. You will have to contact 1&1 to see if they can make this functionality available with their control panel, or specifically for you; it has nothing to do with .htaccess, etc.

    A bit of background so that you know this is what needs to be set up. I have a PHP/MySQL script (same setup as WP) running on a Linux server. The database needs to be accessed by a proprietary web server that is only able to run on a Windows server. I set up the Linux hosted database to be remotely accessed by the Windows server and it works as planned 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Remote MySQL Dtabase’ is closed to new replies.