"Error establishing mySQL database connection." i'm STUCK ON 'Step 2/4'

[shibuya246]

Hi, I did all of this and after adding this in line 82 my browser shows only the database name and my password. Now what to do? why this installing is so difficult and boring?

The problem looks like it is with your SQL setup. We cant guess what the settings are, so can you please help by telling us some info? What is your url for the site and i can take a look at the errors directly

[anika039]

I want to delete all data and want to do all things again from beginning. Pls give me some advice.

[nothingman]

I want to delete all data and want to do all things again from beginning. Pls give me some advice.

To delete all data, you would need to open you database in PHPMyAdmin and use the DROP TABLE statement. From what I gather, you don't have any data in your database tables, so the drop table statement would do. Else, use the truncate table table_name statement.

Example to drop and truncate the comments table (assuming you have prefixed your tables with hotaru_ during set up):

Drop table statement: Drop table hotaru_comments;

Truncate table statement: TRUNCATE TABLE hotaru_comments;

[Nick]

Anika, did you check with your web host to see id "localhost" is the correct value for DB_HOST?

I looked up the name of your webhost and it's starhostbd.com, right? I can't find any support forums or detailed information about your server setup, so you will need to check with them. The problem is not with Hotaru, but with your database details or server requirements.

[Nick]

From what I gather, you don't have any data in your database tables

Actually, Anika won't even have any database tables yet, so there really is nothing to delete. Thanks for trying to help, though.

[anika039]

hi, thanks, yes, I took hosting from starhostbd.com . but in my phpmyadmin I saw my host name is localhost. what types of information do I need more. can you pls tell me.

[Nick]

Well, one thing you could do is test your database connection without using Hotaru...

Open a new text file and paste this into it with your database details:

<?php

$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'password';
$dbname = 'databasename';

echo "Connecting to MySQL...<br />";

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');

echo "Selecting the database...<br />";

mysql_select_db($dbname);

echo "Closing the connection...<br />";

mysql_close($conn);

echo "Finished.";

?>

Save it as database_test.php and upload it to your root directory.

In your browser, open example.com/database_test.php and see if you get any errors.

[anika039]

I did nothing but setup it in my another site www.sporticka.com and it worked. Then I delete my setup and did it from the beginning. After setting up, it shows me the message when i create category.


Then I did the whole thing again. I also checked the mentioned file in both of my site but it did not worked. What to do please.

[Nick]

You need the mbstring PHP extension enabled on your server.

http://www.php.net/manual/en/book.mbstring.php

[anika039]

You need the mbstring PHP extension enabled on your server.

http://www.php.net/manual/en/book.mbstring.php

where to setup? do i need to contact with my hosting company or i have to do this in my cpanel. i dont know. please help.