Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Having trouble with mysql_connect

Discussion in 'Database Discussions' started by pjcollis, May 7, 2014.

  1. pjcollis

    pjcollis Registered

    Joined:
    May 6, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hi everyone,

    I have just transferred my website - Removed - is a new host company - Removed -, loaded the MySQL database via phpMyadmin and have ftp'ed the .php and .js files to the server.

    I have amended the $dbhost, $dbuser and $dbpass values but can't get the format right. I think it should be something like :

    'mysql1.<domain-name>:<port>'

    My old string used to be 'mysql1.domain.com:3306'

    Any suggestions will be gartefully received.


    Regards,

    Pete Collis
     
    #1 pjcollis, May 7, 2014
    Last edited by a moderator: May 7, 2014
  2. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    575
    Likes Received:
    20
    Trophy Points:
    93
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Are you sure it was mysql1 and not mysqli ? Is MySQLi installed on the new host? Since you're access level is listed as Website Owner, you should ask your new host what error messages appear in /usr/local/apache/logs/error_log
     
    #2 cPanelPeter, May 7, 2014
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,802
    Likes Received:
    1,714
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Also, make sure you use "localhost" as the MySQL hostname unless you are using a remote MySQL server.

    Thank you.
     
    #3 cPanelMichael, May 7, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Having trouble mysql_connect
  1. inspiredearth

    Having trouble getting Apache and server to perform well

    inspiredearth, Mar 7, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    108
    cPanelMichael
    Mar 8, 2018
  2. durangod

    Having trouble understanding ssh key docs

    durangod, Sep 29, 2016, in forum: Security
    Replies:
    5
    Views:
    770
    durangod
    Jul 10, 2017
  3. SSy

    Keep having to log into WHM to access SSH

    SSy, Oct 24, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    207
    cPanelMichael
    Oct 24, 2017
  4. Kelemvor

    Creating a subdomain but having problems

    Kelemvor, Sep 4, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    565
    cPanelMichael
    Sep 6, 2017
  5. Keyur V

    ERR_SSL_PROTOCOL_ERROR to visitors having IPv 6 IP address.

    Keyur V, Aug 24, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    276
    cPanelMichael
    Aug 25, 2017

Share This Page