My-Sql Chopin

[serverct]

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.

 

[Zubair]

Change MYSQL host to localhost

 

[serverct]

i cant, the admin interface gives the same error

EDIT. Actually i am going to change the host manually and post back

 

[Jake]

Also make sure your serverct_phpbb user has all access permissions on the serverct_phpbb database from cPanel's mysql panel.

 

[serverct]

Yes ive changed it MANUALLY. My config file is as follows-

<?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);
?>

 

[serverct]

Jake, all permissions were set, it was working yesterday

 

[serverct]

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

 

[Jake]

Does it work now? Mysql on chopin is working fine for me.

 

[serverct]

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/

 

[Jake]

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.

 

[serverct]

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.

 

[Jake]

Does the user serverct_wp have permission to use the serverct_wp database?

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.

 

[serverct]

Thanks Jake For All Your Support, Ive Fixed It Now!

 

[Zubair]

Thanks Jake For All Your Support, Ive Fixed It Now!

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***

 

[Zubair]

Thanks Jake For All Your Support, Ive Fixed It Now!

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***