boardom

[moonwalk]

on my site i already an a database and now im trying to add my hostee to it. i already did everything the steps said but i still get this:
Can't connect to the database b2. MySQL said:
Access denied for user: 'nekostar_yuki@localhost' to database 'b2'
_________________
Those of us with wings soar to greater distances.

[eccentric]

my website is at http://eccentric.toxic-beauty.net if you need to know. i'm confused with how you're suppose to edit the b2config.php file. i get this message at the install page.

Warning: mysql_connect(): Access denied for user: 'user@localhost' (Using password: YES) in /home/toxic-b/public_html/eccentric/b2/b2install.php on line 17
Can't connect to the database
Access denied for user: 'user@localhost' (Using password: YES)

[kite]

Your SQL query:
SELECT * FROM b2settings

MySQL said:
Table 'kaizokuo_b2.b2settings' doesn't exist

well.. if anyone could help i'd be nice. also give out a full explaination on what i should do too. kthnx.

[GCTop989]

You know how you talked about the fact that "b2posts" already existed and that is why she got this error:

Now creating the necessary tables in the database...


doh, can't create the table "b2posts" in the database.

query:
CREATE TABLE b2posts ( ID int(10) unsigned NOT NULL auto_increment, post_author int(4) DEFAULT '0' NOT NULL, post_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, post_content text NOT NULL, post_title text NOT NULL, post_category int(4) DEFAULT '0' NOT NULL, post_karma int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (ID), UNIQUE ID (ID) )

error:
Table 'b2posts' already exists


Well you said to delete the tables. What do you mean by that? I looked at the tables in the b2config.php page, is that correct? And I remove what is there already and reupload? Or is it more sophisticated?

[shannon]

This is what i'm getting:

Warning: Access denied for user: 'behelit@localhost' (Using password: YES) in /home/httpd/vhosts/behelit.net/httpdocs/blog/b2install.php on line 17

Warning: MySQL Connection Failed: Access denied for user: 'behelit@localhost' (Using password: YES) in /home/httpd/vhosts/behelit.net/httpdocs/blog/b2install.php on line 17
Can't connect to the database
Access denied for user: 'behelit@localhost' (Using password: YES)

please help, thanks

[shannon]

nevermind, i got it

[moose]

[sentie]

i just uploaded all the files onto my server, and when i try to run "b2install.php" i get this:

".mysql_error()); $dbconnexion = mysql_select_db($base, $connexion); if (!$dbconnexion) { echo mysql_error(); die(); } echo "Now creating the necessary tables in the database...

"; # Note: if you want to start again with a clean b2 database, # just remove the // in this file // $query = "DROP TABLE IF EXISTS $tableposts"; // $q = mysql_query($query) or die ("doh, can't drop the table \"$tableposts\" in the database."); $query = "CREATE TABLE $tableposts ( ID int(10) unsigned NOT NULL auto_increment, post_author int(4) DEFAULT '0' NOT NULL, post_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, post_content text NOT NULL, post_title text NOT NULL, post_category int(4) DEFAULT '0' NOT NULL, post_karma int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (ID), UNIQUE ID (ID) )"; $q = mysql_query($query) or mysql_doh("doh, can't create the table \"$tableposts\" in the database.", $query, mysql_error()); $now = date('Y-m-d H:i:s'); $query = "INSERT INTO $tableposts (post_author, post_date, post_content, post_title, post_category) VALUES ('1', '$now', 'This is the first post. Edit or delete it, then start blogging !', 'Hello world !', '1')"; $q = mysql_query($query) or mysql_doh("doh, can't insert a first post in the table \"$tableposts\" in the database.", $query, mysql_error()); echo "posts: OK
"; // $query = "DROP TABLE IF EXISTS $tablecategories"; // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tablecategories\" in the database."); $query="CREATE TABLE $tablecategories (cat_ID int(4) NOT NULL auto_increment, cat_name TINYTEXT not null , KEY (cat_ID))"; $q = mysql_query($query) or mysql_doh("doh, can't create the table \"$tablecategories\" in the database.", $query, mysql_error()); $query = "INSERT INTO $tablecategories (cat_ID, cat_name) VALUES ('0', 'General')"; $q = mysql_query($query) or mysql_doh("doh, can't set the default category in the table \"$tablecategories\" in the database.", $query, mysql_error()); $query = "UPDATE $tableposts SET post_category=\"1\""; $result = mysql_query($query) or mysql_doh("Oops, can't set the default category on $tableposts.", $query, mysql_error()); echo "b2categories: OK
"; // $query = "DROP TABLE IF EXISTS $tablecomments"; // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tablecomments\" in the database."); $query = "CREATE TABLE $tablecomments ( comment_ID int(11) unsigned NOT NULL auto_increment, comment_post_ID int(11) DEFAULT '0' NOT NULL, comment_author tinytext NOT NULL, comment_author_email varchar(100) NOT NULL, comment_author_url varchar(100) NOT NULL, comment_author_IP varchar(100) NOT NULL, comment_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, comment_content text NOT NULL, comment_karma int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (comment_ID) )"; $q = mysql_query($query) or mysql_doh("doh, can't create the table \"$tablecomments\" in the database.", $query, mysql_error()); $now = date('Y-m-d H:i:s'); $query = "INSERT INTO $tablecomments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_content) VALUES ('1', 'miss b2', '[email protected]', 'http://example.com', '127.0.0.1', '$now', 'Hi, this is a comment.
To delete a comment, just log in, and view the posts\' comments, there you will have the option to edit or delete them.')"; $q = mysql_query($query) or mysql_doh("doh, can't insert a first comment in the table \"$tablecomments\" in the database.", $query, mysql_error()); echo "comments: OK
"; // $query = "DROP TABLE IF EXISTS $tablesettings"; // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tablesettings\" in the database."); $query = "CREATE TABLE $tablesettings ( ID tinyint(3) DEFAULT '1' NOT NULL, posts_per_page int(4) unsigned DEFAULT '7' NOT NULL, what_to_show varchar(5) DEFAULT 'days' NOT NULL, archive_mode varchar(10) DEFAULT 'weekly' NOT NULL, time_difference tinyint(4) DEFAULT '0' NOT NULL, AutoBR tinyint(1) DEFAULT '1' NOT NULL, time_format varchar(20) DEFAULT 'H:i:s' NOT NULL, date_format varchar(20) DEFAULT 'Y/m/d' NOT NULL, PRIMARY KEY (ID), KEY ID (ID) )"; $q = mysql_query($query) or mysql_doh("doh, can't create the table \"$tablesettings\" in the database.", $query, mysql_error()); $query = "INSERT INTO $tablesettings ( ID, posts_per_page, what_to_show, archive_mode, time_difference, AutoBR, time_format, date_format) VALUES ( '1', '20', 'posts', 'monthly', '0', '1', 'H:i:s', 'd.m.y')"; $q = mysql_query($query) or mysql_doh("doh, can't set the default settings in the table \"$tablesettings\" in the database.", $query, mysql_error()); echo "settings: OK
"; // $query = "DROP TABLE IF EXISTS $tableusers"; // $q = mysql_query($query) or mysql_doh("doh, can't drop the table \"$tableusers\" in the database."); $query = "CREATE TABLE $tableusers ( ID int(10) unsigned NOT NULL auto_increment, user_login varchar(20) NOT NULL, user_pass varchar(20) NOT NULL, user_firstname varchar(50) NOT NULL, user_lastname varchar(50) NOT NULL, user_nickname varchar(50) NOT NULL, user_icq int(10) unsigned DEFAULT '0' NOT NULL, user_email varchar(100) NOT NULL, user_url varchar(100) NOT NULL, user_ip varchar(15) NOT NULL, user_domain varchar(200) NOT NULL, user_browser varchar(200) NOT NULL, dateYMDhour datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, user_level int(2) unsigned DEFAULT '0' NOT NULL, user_aim varchar(50) NOT NULL, user_msn varchar(100) NOT NULL, user_yim varchar(50) NOT NULL, user_idmode varchar(20) NOT NULL, PRIMARY KEY (ID), UNIQUE ID (ID), UNIQUE (user_login) )"; $q = mysql_query($query) or mysql_doh("doh, can't create the table \"$tableusers\" in the database.", $query, mysql_error()); $random_password = substr(md5(uniqid(microtime())),0,6); $query = "INSERT INTO $tableusers (ID, user_login, user_pass, user_firstname, user_lastname, user_nickname, user_icq, user_email, user_url, user_ip, user_domain, user_browser, dateYMDhour, user_level, user_aim, user_msn, user_yim, user_idmode) VALUES ( '1', 'admin', '$random_password', '', '', 'admin', '0', '$admin_email', '', '127.0.0.1', '127.0.0.1', '', '00-00-0000 00:00:01', '10', '', '', '', 'nickname')"; $q = mysql_query($query) or mysql_doh("doh, can't set the default user in the table \"$tableusers\" in the database.", $query, mysql_error()); echo "users: OK
"; ?>
Installation successful !

Now you can log in with the login "admin" and password "".


Note that password carefully ! It is a random password that is given to you when you install b2. If you lose it, you will have to delete the tables from the database yourself, and re-install b2.

something similar comes up when try to open b2login.php.

pls help!

[mikelittle]

It looks like your web server is not configured to execute php scripts, instead it is displaying the source code.

You need to speak to your hosting support people and ask them to configure apache appropriately.

Mike
_________________
Mike Little
http://zed1.com/journalized/
"Share what you know. Learn what you don't."

[sentie]

ok. thanks for the help

[dillusiv]

I've got a problem, when my system was on mysql 3.2.3 everything worked..
now that I'm on mysql 4.0.15 I dont see any PHP behavior.

phpmyadmin works.. I can setup, create, delete databases, add users, etc...
I can use <? phpinfo() ?> it works

when I try a test using the code below with or without corret db names or user, I receive a blank page. What seems to be the problem??:

<?php
//
// test ability to connect to database
$dbname = 'fairy_fallen'; // the name of the database
$dbhost = 'localhost'; // 99% chances you won't need to change this value
$dbusername = 'fairy_fallen'; // your MySQL username
$dbpassword = 'your_db_password'; // ...and password <<<<<< CHANGE TO CORRECT VALUE



mysql_connect($dbhost,$dbusername,$dbpassword) or
die("Can't connect to the database server. MySQL said:<br />".mysql_error());
mysql_select_db("$dbname") or
die("Can't connect to the database $base. MySQL said:<br />".mysql_error());

echo "Done";
?>

[Chibi]

Here's what I get when I go to http://angie.endless-emotions.net/b2login.php:

Your SQL query:
SELECT * FROM b2users WHERE user_login = ''

MySQL said:
Table 'endless_angieb2.b2users' doesn't exist

Here's what I have:


// ** MySQL settings **

# fill with your database details
$dbname = 'endless_angieb2'; // the name of the database
$dbhost = 'localhost'; // 99% chances you won't need to change this value
$dbusername = 'endless_angie'; // your MySQL username
$dbpassword = '******'; // ...and password

[moose]

have you ran b2install.php?

[Chibi]

Lol, I'm so stupid! Thanks, it works now!

[-Skye-]

Hi, I hope someone can help me - I keep getting the following message when I run b2install.php:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'skye@localhost' (Using password: YES) in /home/skye/public_html/b2install.php on line 17
Can't connect to the database
Access denied for user: 'skye@localhost' (Using password: YES)

Help, please?

~Skye~