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!

cPanel Joomla MySQL issue

Discussion in 'General Discussion' started by mojamoi, Dec 17, 2013.

  1. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    66
    Hello

    for a cpanel joomla installed site i get this error

    Database connection error (2): Could not connect to MySQL.
     
    #1 mojamoi, Dec 17, 2013
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,423
    Likes Received:
    1,957
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    What method did you use to install Joomla? Have you ensured your database name and database username details are accurate in your Joomla configuration file? Do you have root access to your system?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Dec 17, 2013
  3. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    66
    I do not have root access and do not have ssh access.

    It is just a cpanel account.

    in phpmyadmin the database name comes as database1_dbname , database1_user1
    May I know whether in the configuration.php it should come as database1_dbname,database1_user1 or as just dbname, user1.

    is teh prefix as in phpmyadmin i.e database1 required

    and in configuration.php it comes as just dbname

    - - - Updated - - -

    I used the method of softaculous installation of joomla
     
    #3 mojamoi, Dec 17, 2013
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,423
    Likes Received:
    1,957
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes, the prefix is included in the database name and should be used in your script's configuration file.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Dec 17, 2013
  5. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    66
    solved :)

    i had missed localhost
     
    #5 mojamoi, Dec 17, 2013
  6. Brijesh-soft

    Brijesh-soft Registered

    Joined:
    Aug 16, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    Hi,

    I am from the Softaculous team.
    If you installed it via Softaculous it should have filled in the correct details i.e. database host as well as database name and password. Did you change the configuration.php manually ?
     
    #6 Brijesh-soft, Dec 18, 2013
  7. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,571
    Likes Received:
    439
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello Brijesh-soft. Please feel free to open a ticket to cPanel Customer Service to alert them to your account on the forums here and we'll get you upgraded to Verified Vendor status. :)

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 Infopro, Dec 18, 2013
  8. Brijesh-soft

    Brijesh-soft Registered

    Joined:
    Aug 16, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    Great. Thanks !!
     
    #8 Brijesh-soft, Dec 18, 2013
  9. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    66
    I did not change anything manually but I had to replace hostname with localhost to make it work.

    I had installed joomla using softaculous, probably over an existing instakllation, not sure how it was installed first as it was my customers.
     
    #9 mojamoi, Dec 18, 2013
  10. Brijesh-soft

    Brijesh-soft Registered

    Joined:
    Aug 16, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    It could be possible that the existing configuration.php was not writable hence Softaculous could not create a new file. If you could open a support ticket with us we can check it for you.
     
    #10 Brijesh-soft, Dec 18, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - cPanel Joomla MySQL
  1. bosprickly

    Using cPanel to configure VPS for Joomla 3.7x and PHP 7.1

    bosprickly, Aug 12, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    543
    cPanelMichael
    Aug 14, 2017
  2. RIkaweb

    New Thread migirate to EA_4 error “Cpanel::Easy::Apache::Ident” ignored since it does not have an RPM

    RIkaweb, Dec 12, 2018 at 10:53 AM, in forum: EasyApache
    Replies:
    0
    Views:
    23
    RIkaweb
    Dec 12, 2018 at 10:53 AM
  3. rccaj

    New Thread Log in to cPanel through CURL

    rccaj, Dec 12, 2018 at 4:50 AM, in forum: cPanel Developers
    Replies:
    0
    Views:
    56
    rccaj
    Dec 12, 2018 at 4:50 AM
  4. rpvw

    In Progress [CPANEL-24366] phpMyAdmin version 4.8.4

    rpvw, Dec 11, 2018 at 9:11 AM, in forum: Security
    Replies:
    1
    Views:
    121
    cPanelMichael
    Dec 11, 2018 at 9:58 AM
  5. Tanner_W

    In Progress [CPANEL-24418] Update KAM.cf to latest version

    Tanner_W, Dec 9, 2018 at 2:31 AM, in forum: E-mail Discussion
    Replies:
    3
    Views:
    290
    cPanelMichael
    Dec 12, 2018 at 12:45 PM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice