My-Sql Chopin

Discussion in 'Free Hosting' started by serverct, Apr 20, 2010.

Thread Status:
Not open for further replies.
  1. serverct

    serverct New Member

    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    0
    The My-SQL On The Chopin Server Has Given My PHP-BB Forum (http://comptuts.co.cc/forum/) This Error :

    General Error
    SQL ERROR [ mysqli ]

    Access denied for user 'serverct_phpbb'@'int.chopin.x10hosting.com' to database 'serverct_phpbb' [1044]

    An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
    Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

    Please Help, i think the chopin server had a reboot because the whole of chopin was down a while ago.
     
  2. Zubair

    Zubair Community Leader Community Support

    Messages:
    8,766
    Likes Received:
    305
    Trophy Points:
    83
    Change MYSQL host to localhost
     
  3. serverct

    serverct New Member

    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    0
    i cant, the admin interface gives the same error

    EDIT. Actually i am going to change the host manually and post back
     
    Last edited: Apr 20, 2010
  4. Jake

    Jake Developer Contributors

    Messages:
    4,057
    Likes Received:
    5
    Trophy Points:
    0
    Also make sure your serverct_phpbb user has all access permissions on the serverct_phpbb database from cPanel's mysql panel.
     
  5. serverct

    serverct New Member

    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    0
    Yes ive changed it MANUALLY. My config file is as follows-

    PHP:
    <?php
    // phpBB 3.0.x auto-generated configuration file
    // Do not change anything in this file!
    $dbms 'mysqli';
    $dbhost 'localhost';
    $dbport '';
    $dbname 'serverct_phpbb';
    $dbuser 'serverct_phpbb';
    $dbpasswd 'YOU MAY NOT SEE THIS';
    $table_prefix 'ct_';
    $acm_type 'file';
    $load_extensions '';

    @
    define('PHPBB_INSTALLED'true);
    // @define('DEBUG', true);
    // @define('DEBUG_EXTRA', true);
    ?>
     
  6. serverct

    serverct New Member

    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    0
    Jake, all permissions were set, it was working yesterday
     
  7. serverct

    serverct New Member

    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    0
    serverct_phpbb is now being checked.

    serverct_phpbb.ct_acl_groups OK serverct_phpbb.ct_acl_options OK serverct_phpbb.ct_acl_roles OK serverct_phpbb.ct_acl_roles_data OK serverct_phpbb.ct_acl_users OK serverct_phpbb.ct_attachments OK serverct_phpbb.ct_banlist OK serverct_phpbb.ct_bbcodes OK serverct_phpbb.ct_bookmarks OK serverct_phpbb.ct_bots OK serverct_phpbb.ct_config OK serverct_phpbb.ct_confirm OK serverct_phpbb.ct_disallow OK serverct_phpbb.ct_drafts OK serverct_phpbb.ct_extension_groups OK serverct_phpbb.ct_extensions OK serverct_phpbb.ct_forums OK serverct_phpbb.ct_forums_access OK serverct_phpbb.ct_forums_track OK serverct_phpbb.ct_forums_watch OK serverct_phpbb.ct_groups OK serverct_phpbb.ct_icons OK serverct_phpbb.ct_lang OK serverct_phpbb.ct_log OK serverct_phpbb.ct_moderator_cache OK serverct_phpbb.ct_modules OK serverct_phpbb.ct_poll_options OK serverct_phpbb.ct_poll_votes OK serverct_phpbb.ct_posts OK serverct_phpbb.ct_privmsgs OK serverct_phpbb.ct_privmsgs_folder OK serverct_phpbb.ct_privmsgs_rules OK serverct_phpbb.ct_privmsgs_to OK serverct_phpbb.ct_profile_fields OK serverct_phpbb.ct_profile_fields_data OK serverct_phpbb.ct_profile_fields_lang OK serverct_phpbb.ct_profile_lang OK serverct_phpbb.ct_ranks OK serverct_phpbb.ct_reports OK serverct_phpbb.ct_reports_reasons OK serverct_phpbb.ct_search_results OK serverct_phpbb.ct_search_wordlist OK serverct_phpbb.ct_search_wordmatch OK serverct_phpbb.ct_sessions OK serverct_phpbb.ct_sessions_keys OK serverct_phpbb.ct_sitelist OK serverct_phpbb.ct_smilies OK serverct_phpbb.ct_styles OK serverct_phpbb.ct_styles_imageset OK serverct_phpbb.ct_styles_imageset_data OK serverct_phpbb.ct_styles_template OK serverct_phpbb.ct_styles_template_data OK serverct_phpbb.ct_styles_theme OK serverct_phpbb.ct_topics OK serverct_phpbb.ct_topics_posted OK serverct_phpbb.ct_topics_track OK serverct_phpbb.ct_topics_watch OK serverct_phpbb.ct_user_group OK serverct_phpbb.ct_users OK serverct_phpbb.ct_warnings OK serverct_phpbb.ct_words OK serverct_phpbb.ct_zebra OK

    Check Complete

    ==================

    serverct_phpbb is now being repaired.

    serverct_phpbb.ct_acl_groups OK
    serverct_phpbb.ct_acl_options OK
    serverct_phpbb.ct_acl_roles OK
    serverct_phpbb.ct_acl_roles_data OK
    serverct_phpbb.ct_acl_users OK
    serverct_phpbb.ct_attachments OK
    serverct_phpbb.ct_banlist OK
    serverct_phpbb.ct_bbcodes OK
    serverct_phpbb.ct_bookmarks OK
    serverct_phpbb.ct_bots OK
    serverct_phpbb.ct_config OK
    serverct_phpbb.ct_confirm OK
    serverct_phpbb.ct_disallow OK
    serverct_phpbb.ct_drafts OK
    serverct_phpbb.ct_extension_groups OK
    serverct_phpbb.ct_extensions OK
    serverct_phpbb.ct_forums OK
    serverct_phpbb.ct_forums_access OK
    serverct_phpbb.ct_forums_track OK
    serverct_phpbb.ct_forums_watch OK
    serverct_phpbb.ct_groups OK
    serverct_phpbb.ct_icons OK
    serverct_phpbb.ct_lang OK
    serverct_phpbb.ct_log OK
    serverct_phpbb.ct_moderator_cache OK
    serverct_phpbb.ct_modules OK
    serverct_phpbb.ct_poll_options OK
    serverct_phpbb.ct_poll_votes OK
    serverct_phpbb.ct_posts OK
    serverct_phpbb.ct_privmsgs OK
    serverct_phpbb.ct_privmsgs_folder OK
    serverct_phpbb.ct_privmsgs_rules OK
    serverct_phpbb.ct_privmsgs_to OK
    serverct_phpbb.ct_profile_fields OK
    serverct_phpbb.ct_profile_fields_data OK
    serverct_phpbb.ct_profile_fields_lang OK
    serverct_phpbb.ct_profile_lang OK
    serverct_phpbb.ct_ranks OK
    serverct_phpbb.ct_reports OK
    serverct_phpbb.ct_reports_reasons OK
    serverct_phpbb.ct_search_results OK
    serverct_phpbb.ct_search_wordlist OK
    serverct_phpbb.ct_search_wordmatch OK
    serverct_phpbb.ct_sessions OK
    serverct_phpbb.ct_sessions_keys OK
    serverct_phpbb.ct_sitelist OK
    serverct_phpbb.ct_smilies OK
    serverct_phpbb.ct_styles OK
    serverct_phpbb.ct_styles_imageset OK
    serverct_phpbb.ct_styles_imageset_data OK
    serverct_phpbb.ct_styles_template OK
    serverct_phpbb.ct_styles_template_data OK
    serverct_phpbb.ct_styles_theme OK
    serverct_phpbb.ct_topics OK
    serverct_phpbb.ct_topics_posted OK
    serverct_phpbb.ct_topics_track OK
    serverct_phpbb.ct_topics_watch OK
    serverct_phpbb.ct_user_group OK
    serverct_phpbb.ct_users OK
    serverct_phpbb.ct_warnings OK
    serverct_phpbb.ct_words OK
    serverct_phpbb.ct_zebra OK

    Repair Complete
     
  8. Jake

    Jake Developer Contributors

    Messages:
    4,057
    Likes Received:
    5
    Trophy Points:
    0
    Does it work now? Mysql on chopin is working fine for me.
     
  9. serverct

    serverct New Member

    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    0
    Not at the moment, it could be my DNS. im gona flush it and edit this post.

    edit. i flushed dns and still, on 2 proxys i tried it gave an error 503.

    try it yourself : http://comptuts.co.cc/forum/
     
    Last edited: Apr 20, 2010
  10. Jake

    Jake Developer Contributors

    Messages:
    4,057
    Likes Received:
    5
    Trophy Points:
    0
    I'd still double check that the user didnt get changed, edited, or deleted. And try "mysql" instead of "mysqli" at some point and see if it works with just the mysql interface.
     
  11. serverct

    serverct New Member

    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    0
    How can it be a co-incidence that my blog isnt working either : http://comptuts.co.cc/blog/


    Can’t select database

    We were able to connect to the database server (which means your username and password is okay) but not able to select the serverct_wp database.

    • Are you sure it exists?
    • Does the user serverct_wp have permission to use the serverct_wp database?
    • On some systems the name of your database is prefixed with your username, so it would be like username_serverct_wp. Could that be the problem?
    If you don't know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.
     
  12. Jake

    Jake Developer Contributors

    Messages:
    4,057
    Likes Received:
    5
    Trophy Points:
    0
    I still think its not linked.

    Here's a default wordpress I just installed on chopin. http://bobjen.x10hosting.com/test/

    The user is not able to access the databases.
     
  13. serverct

    serverct New Member

    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    0
    Thanks Jake For All Your Support, Ive Fixed It Now!
     
  14. Zubair

    Zubair Community Leader Community Support

    Messages:
    8,766
    Likes Received:
    305
    Trophy Points:
    83
    Good.

    Your problem is resolved Now. So I am going to close this thread to mark it as resolved. Feel free to create a new thread if you need more help.

    ***Thread Closed***
     
  15. Zubair

    Zubair Community Leader Community Support

    Messages:
    8,766
    Likes Received:
    305
    Trophy Points:
    83
    Good.

    Your problem is resolved Now. So I am going to close this thread to mark it as resolved. Feel free to create a new thread if you need more help.

    ***Thread Closed***
     
Thread Status:
Not open for further replies.

Share This Page