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:
    573
    Likes Received:
    19
    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:
    37,037
    Likes Received:
    1,278
    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. durangod

    Having trouble understanding ssh key docs

    durangod, Sep 29, 2016, in forum: Security
    Replies:
    5
    Views:
    413
    durangod
    Jul 10, 2017
  2. Rasmusbdk

    Having some trouble setting up rDNS and ptr records

    Rasmusbdk, Dec 3, 2015, in forum: Bind / DNS / Nameserver Issues
    Replies:
    7
    Views:
    1,025
    dalem
    Dec 4, 2015
  3. 360webfirm

    Updated cPanel yesterday having dns issues

    360webfirm, May 10, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    203
    Infopro
    May 10, 2017
  4. LucasR

    SOLVED Having issues with AutoSSL AuthenticationFailure cPanel Store

    LucasR, Mar 10, 2017, in forum: Security
    Replies:
    6
    Views:
    642
    LucasR
    Mar 10, 2017
  5. SSy

    Keep having to reset root password for SSH

    SSy, Feb 22, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    279
    cPanelMichael
    Feb 23, 2017

Share This Page