UseBB Community

The official board for UseBB help and discussion

UseBB Community » Help & Support » Access denied for user

Access denied for user

Moderators: Gaia.

Page: 1

Author Post
Member
Registered: Nov 2005
Posts: 2
Location: North Carolina - USA
First: I am a novice...
Second: That should explain the uninformed nature of my question and my apparent stupidity :?

Server Information
Operating System - Linux
Apache Version - 1.3.34 (Unix)
Perl Version - 5.8.7
Perl Path - /usr/bin/perl
PHP Version - 4.4.1
Mysql Version - 4.1.14-standard

I uploaded files, started install online through UseBB/install/install.php, install wizard started, renamed config.php-dist to config.php, reconfigured the data in config.php to the best of my knowledge (which is little to nothing)
Proceeded to Step 2 and received error:
Step 2

An error was encountered while trying to access the database. The error was:

SQL: Access denied for user 'not visible for obvious reasons but this is my user name'@'localhost' to database 'usebb'
Please check your database settings in config.php!

( I have use the terms: "not visible for obvious reasons but this is my password etc." in places where my correct user name or password appears )

Hate to say it but I'm at the "Duhhh... ?" point.

"Help me UseBB-wan-kenobi, you're my only hope."

Thanks guys,
Patrick

Anything else you notice in this file that will trip me up, please advise :)
( I'm not sure about the cookie_domain and cookie_path either )

Example of my config.php file:
//
// Define database configuration
//
$dbs['type'] = 'mysql';
$dbs['server'] = 'localhost';
$dbs['username'] = 'not visible for obvious reasons but this is my user name';
$dbs['passwd'] = 'not visible for obvious reasons but this is my password';
$dbs['dbname'] = 'usebb';
$dbs['prefix'] = 'usebb_';

//
// Initialize a new configuration holder array
//
$conf = array();

//
// Define configuration
//
$conf['active_topics_count'] = 25;
$conf['admin_email'] = 'webmaster@614arty.org';
$conf['allow_multi_sess'] = 1;
$conf['avatars_force_width'] = 65;
$conf['avatars_force_height'] = 65;
$conf['board_closed'] = 0;
$conf['board_closed_reason'] = 'Just closed...';
$conf['board_descr'] = 'The 6/14 Arty Bulletin Board';
$conf['board_keywords'] = 'forum,board,community,usebb';
$conf['board_name'] = 'The 6th Battalion 14th Artillery Regiment Bulletin Board';
$conf['board_url'] = 'http://www.614arty.org/UseBB/index.php/';
$conf['cookie_domain'] = '';
$conf['cookie_path'] = '';
$conf['cookie_secure'] = 0;
$conf['date_format'] = 'D M d, Y g:i a';
$conf['debug'] = 1;
$conf['disable_info_emails'] = 0;
$conf['disable_registrations'] = 0;
$conf['disable_registrations_reason'] = 'No new users allowed at this time.';
$conf['dst'] = 0;
$conf['email_view_level'] = 1;
$conf['enable_acp_modules'] = 1;
$conf['enable_contactadmin'] = 1;
$conf['enable_detailed_online_list'] = 1;
$conf['enable_forum_stats_box'] = 1;
$conf['enable_memberlist'] = 1;
$conf['enable_quickreply'] = 1;
$conf['enable_rss'] = 1;
$conf['enable_stafflist'] = 1;
$conf['enable_stats'] = 1;
$conf['exclude_forums_active_topics'] = array ();
$conf['exclude_forums_rss'] = array ();
$conf['exclude_forums_stats'] = array ();
$conf['flood_interval'] = 30;
$conf['friendly_urls'] = 0;
$conf['guests_can_access_board'] = 1;
$conf['guests_can_view_profiles'] = 1;
$conf['hide_avatars'] = 0;
$conf['hide_signatures'] = 0;
$conf['hide_undefined_config_setting_warnings'] = 1;
$conf['hide_undefined_template_setting_warnings'] = 0;
$conf['hide_undefined_template_warnings'] = 0;
$conf['hide_userinfo'] = 0;
$conf['language'] = 'English';
$conf['members_per_page'] = 25;
$conf['online_min_updated'] = 30;
$conf['output_compression'] = 2;
$conf['passwd_min_length'] = 8;
$conf['posts_per_page'] = 25;
$conf['rel_nofollow'] = 0;
$conf['return_to_topic_after_posting'] = 1;
$conf['rss_items_count'] = 25;
$conf['search_limit_results'] = 1000;
$conf['search_nonindex_words_min_length'] = 3;
$conf['session_max_lifetime'] = 60;
$conf['session_name'] = 'usebb';
$conf['session_save_path'] = '';
$conf['show_edited_message_timeout'] = 60;
$conf['sig_allow_bbcode'] = 1;
$conf['sig_allow_smilies'] = 1;
$conf['sig_max_length'] = 500;
$conf['single_forum_mode'] = 0;
$conf['target_blank'] = 0;
$conf['template'] = 'default';
$conf['timezone'] = 0;
$conf['topicreview_posts'] = 5;
$conf['topics_per_page'] = 25;
$conf['users_must_activate'] = 1;
$conf['view_detailed_online_list_min_level'] = 0;
$conf['view_forum_stats_box_min_level'] = 0;
$conf['view_hidden_email_addresses_min_level'] = 3;
$conf['view_memberlist_min_level'] = 0;
$conf['view_stafflist_min_level'] = 0;
$conf['view_stats_min_level'] = 0;
$conf['view_contactadmin_min_level'] = 0;

?>
_______________
"Imagination is more important than knowledge."
- Albert Einstein -
Moderator
Registered: Oct 2005
Posts: 447
Location: canada
All you need to edit in the config.php are the following


//
// Define database configuration
//
$dbs['type'] = 'mysql';
$dbs['server'] = 'localhost';
$dbs['username'] = 'not visible for obvious reasons but this is my user name';
$dbs['passwd'] = 'not visible for obvious reasons but this is my password';
$dbs['dbname'] = 'usebb';
$dbs['prefix'] = 'usebb_';


What the error is saying is that it can't access your MySQL database. You should double check your mysql username and database. Usually something like username_dbuser, username_dbname. username being the username you signed up with your host.
Member
Registered: Nov 2005
Posts: 2
Location: North Carolina - USA
Gaia wrote
... check your mysql username and database. Usually something like username_dbuser, username_dbname.

Oh Yeah!

If only all things in life could be this easy... and clearly explained!
Thanks for the kick in the username pants, it worked.

Patrick
_______________
"Imagination is more important than knowledge."
- Albert Einstein -
Moderator
Registered: Oct 2005
Posts: 447
Location: canada
Lol. No problem. Happens to the best of us ^_^

Page: 1

UseBB Community » Help & Support » Access denied for user

UseBB Community is powered by UseBB 1 Forum Software