17 {{ upvoteCount | shortNum }}
17 {{ upvoteCount | shortNum }}

Wordpress and MYSQL

by Danny Cutts
15 replies
Hello Warriors,

I am doing a site for a client of mine using wordpress and well his host is being a real pain about giving him a MYSQL database, which I need for the wordpress installation.

I have the option to use a MYSQL from my host and instead of using localhost what would I put in?

Failing that is there a free online service that offers MYSQL?

Cheers

Danny
#mysql #wordpress
  • Profile picture of the author Danny Cutts
    Hello

    I have tried to get them to go with me and save money but they are not having it!!

    I am just going to redirect the db to one of my domains... i think

    Danny
    Signature
    Come and See me on Facebook... Come and See me at my blog...
    {{ DiscussionBoard.errors[1348055].message }}
  • Profile picture of the author Danny Cutts
    Its proving almost impossible!!

    I really dont understand why hosts dont give people MYSQL!!?

    Danny
    Signature
    Come and See me on Facebook... Come and See me at my blog...
    {{ DiscussionBoard.errors[1348335].message }}
    • Profile picture of the author LynnM
      This is what you get for saying it will be up in a day...! Pity you can't insist they change hosts.
      Good luck with this,


      Lynn
      {{ DiscussionBoard.errors[1348362].message }}
      • Profile picture of the author um1001
        If I understand correctly, you're looking for the MySQL connection information for Wordpress, which resides in wp-config.php

        You're looking for the line that has something like:

        define('DB_HOST', 'localhost');

        ... You would replace the 'localhost' with the hostname of your actual MySQL server.

        PM me if you need some technical help. I'm pretty pro with PHP

        p.s. - keep in mind that a lot of hosts isolate MySQL from the outside world or otherwise block traffic, so it may not be possible depending on your setup
        Signature

        -- Jack Morrison / um1001

        {{ DiscussionBoard.errors[1348393].message }}
  • Profile picture of the author HarrisonJ
    There is a free host called 000webHost that is pretty good and has free mysql databases. Just change their hosting to that, google them.
    Signature
    FREE get 50 website visitors traffic clicks from BuySolos.com
    {{ DiscussionBoard.errors[1348397].message }}
    • Profile picture of the author Danny Cutts
      Originally Posted by HarrisonJ View Post

      There is a free host called 000webHost that is pretty good and has free mysql databases. Just change their hosting to that, google them.
      My host has free MYSQL its just the client wont move!!! so thats what is more annoying but hey ho I will just hit him with a bigger bill at the end!

      I have been talking to my host as to why it cannot connect and they are just as confused

      // ** MySQL settings - You can get this info from your web host ** //
      /** The name of the database for WordPress */
      define('DB_NAME', 'danny_jj');

      /** MySQL database username */
      define('DB_USER', 'danny_jj');

      /** MySQL database password */
      define('DB_PASSWORD', 'xxxxxx');

      /** MySQL hostname */
      define('DB_HOST', '70.87.90.34:3306');

      Cheers

      Danny
      Signature
      Come and See me on Facebook... Come and See me at my blog...
      {{ DiscussionBoard.errors[1348428].message }}
      • Profile picture of the author um1001
        Originally Posted by Danny Cutts View Post

        My host has free MYSQL its just the client wont move!!! so thats what is more annoying but hey ho I will just hit him with a bigger bill at the end!

        I have been talking to my host as to why it cannot connect and they are just as confused

        // ** MySQL settings - You can get this info from your web host ** //
        /** The name of the database for WordPress */
        define('DB_NAME', 'danny_jj');

        /** MySQL database username */
        define('DB_USER', 'danny_jj');

        /** MySQL database password */
        define('DB_PASSWORD', 'xxxxxx');

        /** MySQL hostname */
        define('DB_HOST', '70.87.90.34:3306');

        Cheers

        Danny
        It should work if you remove the :3306 bit, like:

        define('DB_HOST', '70.87.90.34');
        Signature

        -- Jack Morrison / um1001

        {{ DiscussionBoard.errors[1348441].message }}
  • Profile picture of the author Danny Cutts
    yeah tried that, my host said the 3306 is for the port

    Cheers though

    Danny
    Signature
    Come and See me on Facebook... Come and See me at my blog...
    {{ DiscussionBoard.errors[1348460].message }}
    • Profile picture of the author um1001
      Originally Posted by Danny Cutts View Post

      yeah tried that, my host said the 3306 is for the port

      Cheers though

      Danny
      It's probably extraneous in this case, since the 3306 is the default MySQL port. If MySQL were running on an unusual port, it would be helpful. But yeah, either way it's not going to hurt I guess.

      More than likely the port isn't the problem. As I mentioned, they may well have the MySQL servers segregated intentionally to prevent malicious connections (I'm pretty sure Godaddy does that, for example.)

      In other words, you can talk to the MySQL host from your hosted web site because there is a route to get to it. Someone outside that private network (which is behind something called network address translation) isn't going to have a route to the host (obviously it all depends on the host and the routing.)
      Signature

      -- Jack Morrison / um1001

      {{ DiscussionBoard.errors[1348470].message }}
  • Profile picture of the author Danny Cutts
    hmmmm

    but surely hostgator would know that?

    thanks

    Danny
    Signature
    Come and See me on Facebook... Come and See me at my blog...
    {{ DiscussionBoard.errors[1348476].message }}
    • Profile picture of the author um1001
      Originally Posted by Danny Cutts View Post

      hmmmm

      but surely hostgator would know that?

      thanks

      Danny
      You would think so but tech support isn't always good at the highly technical stuff... I never worked with Hostgator, so I wouldn't want to say otherwise.

      Take it with a grain of salt
      Signature

      -- Jack Morrison / um1001

      {{ DiscussionBoard.errors[1348499].message }}
  • Profile picture of the author KirkMcD
    Originally Posted by Jeff Hope View Post

    If not, Amazon AWS just launched a remote MySQL service that's really cheap, just like their other services.
    It's not that cheap. There is a minimum $79 per month fee.

    Anyway, the external connection to your MySQL is probably blocked by a firewall on your host.

    You could always setup WP on a subdomain and point that subdomain to another host. It's not difficult to setup. I did that with the forum for the site mentioned in my sig.
    {{ DiscussionBoard.errors[1350332].message }}
  • Profile picture of the author InternetMarketingIQ
    Sounds like a top notch host. Sheese. MySQL is pretty standard. Who knows what will happen when the Sun acquisition takes place though.
    Signature
    Internet Marketing IQâ„¢
    {{ DiscussionBoard.errors[1350690].message }}
  • Profile picture of the author n7 Studios
    HostGator would need to allow remote connections from your client's server to the MySQL database.

    You'd probably need the IP address of your client's server, and pass that onto HostGator so they can configure the access accordingly.

    You should also be able to use a quick few lines of PHP code and try to connect to the database from your client's computer, and then view the error message result to see the issue.

    PM me if you require further assistance.
    Signature
    THE Web Development Guru - Bespoke WordPress Theme, Plugin + iPhone Apps [HTML5, CSS3, PHP, MySQL].
    {{ DiscussionBoard.errors[1350879].message }}

Trending Topics