Closed Thread
Results 1 to 9 of 9

Thread: mySQL still not connecting

  1. #1
    Algorath is offline x10Hosting Member Algorath is an unknown quantity at this point
    Join Date
    Jan 2009
    Posts
    15

    mySQL still not connecting

    I have changed my phpbb3 forum dbhost path to 'localhost' as requested by the admins. For some reason I am still getting the following error:

    General Error

    SQL ERROR [ mysql4 ]

    Can't connect to MySQL server on 'mysql-lotus.x10hosting.com' (4) [2003]

    An sql error occurred while fetching this page. Please contact an administrator if this problem persists.






    which makes it pretty obvious that it is still trying to connect to the old dbhost address. Any idea how I can make this stop trying to connect to the old address and read the new address of 'localhost' out of the config.php file?

  2. #2
    Zubair's Avatar
    Zubair is offline x10 Super Spammer Zubair has a reputation beyond reputeZubair has a reputation beyond reputeZubair has a reputation beyond repute
    Join Date
    Jul 2009
    Location
    Pakistan
    Posts
    8,747

    Re: mySQL still not connecting

    The error show you you don`t enter any username in config file.
    Your config file should be look like this

    PHP Code:
    <?php
    // phpBB 3.0.x auto-generated configuration file
    // Do not change anything in this file!
    $dbms 'mysql';
    $dbhost 'localhost';
    $dbport '';
    $dbname 'cpaneluser_dbname';
    $dbuser 'cpaneluser_dbuser';
    $dbpasswd 'password hidden';
    $table_prefix 'phpbb_';
    $acm_type 'file';
    $load_extensions '';

    @
    define('PHPBB_INSTALLED'true);
    // @define('DEBUG', true);
    // @define('DEBUG_EXTRA', true);
    ?>
    Last edited by Zubair; 01-27-2010 at 05:34 PM.
    Zubair Barkat | Level 2 Tech
    █ 888-X10-9668 - zubair[@]x10hosting.com
    x10Hosting - Giving Away Hosting Since 2004

  3. #3
    Algorath is offline x10Hosting Member Algorath is an unknown quantity at this point
    Join Date
    Jan 2009
    Posts
    15

    Re: mySQL still not connecting

    Both a username and password, which are correct, are present when I look at the file. This is the config.php that PhPbb3 set up on its own, as well as creating the database when it installed it, so there are still the same username and password, which I have confirmed in my mysql databases on cpanel.



    Password hidden for security purposes

    The forum address is http://deathbringers.algorathogame.e...orum/index.php



    FIXED:

    It appears that if I am connected via Cpanel as well as through FTP and I change the file on CPanel but not on FTP, it won't really change the file . . . figure that one out lol. Opened the file through FTP and it was the same as the original, so I changed it there, saved it, and everything works.
    Last edited by Algorath; 01-27-2010 at 05:52 PM. Reason: added image file

  4. #4
    Zubair's Avatar
    Zubair is offline x10 Super Spammer Zubair has a reputation beyond reputeZubair has a reputation beyond reputeZubair has a reputation beyond repute
    Join Date
    Jul 2009
    Location
    Pakistan
    Posts
    8,747

    Re: mySQL still not connecting

    What is your forums link...

    I found this http://uncle.servegame.org:81/phpbb/ and it is opening fine for me...

    are you still seeing error page???

    then try clearing browser cache and flush you DNS and then try again.
    Last edited by Zubair; 01-27-2010 at 05:46 PM.
    Zubair Barkat | Level 2 Tech
    █ 888-X10-9668 - zubair[@]x10hosting.com
    x10Hosting - Giving Away Hosting Since 2004

  5. #5
    calistoy's Avatar
    calistoy is offline Free Support Volunteer calistoy is just really nice
    Join Date
    Aug 2008
    Location
    USA
    Posts
    5,598

    Re: mySQL still not connecting

    I'm able to see your site just fine when I click your link.

  6. #6
    Zubair's Avatar
    Zubair is offline x10 Super Spammer Zubair has a reputation beyond reputeZubair has a reputation beyond reputeZubair has a reputation beyond repute
    Join Date
    Jul 2009
    Location
    Pakistan
    Posts
    8,747

    Re: mySQL still not connecting

    Quote Originally Posted by Algorath View Post
    Both a username and password, which are correct, are present when I look at the file. This is the config.php that PhPbb3 set up on its own, as well as creating the database when it installed it, so there are still the same username and password, which I have confirmed in my mysql databases on cpanel.



    Password hidden for security purposes

    The forum address is http://deathbringers.algorathogame.e...orum/index.php



    FIXED:

    It appears that if I am connected via Cpanel as well as through FTP and I change the file on CPanel but not on FTP, it won't really change the file . . . figure that one out lol. Opened the file through FTP and it was the same as the original, so I changed it there, saved it, and everything works.
    I am able to see these forums with no problem.

    If you can`t then try clearing browser cache and flush you DNS and then try again.
    Last edited by Zubair; 01-27-2010 at 05:57 PM.
    Zubair Barkat | Level 2 Tech
    █ 888-X10-9668 - zubair[@]x10hosting.com
    x10Hosting - Giving Away Hosting Since 2004

  7. #7
    Algorath is offline x10Hosting Member Algorath is an unknown quantity at this point
    Join Date
    Jan 2009
    Posts
    15

    Re: mySQL still not connecting

    Fixed it.

    FIXED:

    It appears that if I am connected via Cpanel as well as through FTP and I change the file on CPanel but not on FTP, it won't really change the file . . . figure that one out lol. Opened the file through FTP and it was the same as the original, so I changed it there, saved it, and everything works.

  8. #8
    neosurfer2695 is offline x10Hosting Member neosurfer2695 is an unknown quantity at this point
    Join Date
    Apr 2009
    Posts
    48

    Re: mySQL still not connecting

    How do you change it in FTP?
    I'm having a similar problem.
    Please help.
    Thanks-

  9. #9
    Algorath is offline x10Hosting Member Algorath is an unknown quantity at this point
    Join Date
    Jan 2009
    Posts
    15

    Re: mySQL still not connecting

    I use Firfox, so I have an add-on called FireFTP. You log in to your FTP server, and navigate to the config file same way you would in Cpanel file manager. Then open the file, edit, and save.

Closed Thread

Similar Threads

  1. [PHP] MySQL and PHP
    By Bryon in forum Tutorials
    Replies: 43
    Last Post: 03-24-2011, 07:27 AM
  2. Connecting local mysql client to mysql database
    By nadunalexander in forum Free Hosting
    Replies: 4
    Last Post: 01-01-2010, 04:24 PM
  3. Connecting Mysql
    By ReDeR in forum Free Hosting
    Replies: 1
    Last Post: 05-08-2009, 01:24 PM
  4. Replies: 14
    Last Post: 09-29-2008, 07:07 PM
  5. New Site-Suggestions?
    By mnoutside in forum Review My Site
    Replies: 9
    Last Post: 08-27-2008, 07:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers