Can\'t connect with SQL

Started by Blagojce, May 12, 2008, 08:09:10 AM

Previous topic - Next topic

Blagojce

When i try to upload SQL show me this message:
Cannot connect to the MySQL database server with the supplied data.

If you are not sure about what to type in, please contact your host.
Access denied for user '********'@'localhost' (using password: YES)
Click here to try this step again.


and when i try with repair_settings.php show me this message:
Some settings are not being shown because the MySQL connection information is incorrect.

What's the problem?

Blagojce


SantaClaws

Hmm. What kind of hosting website are you using?

Blagojce

I using 110mb.com [nofollow]
You think that is the problem?

SantaClaws

I don't know it could be it happened to me with FateHost. Try www.awardspace.co.uk thats a good one.

N3RVE

#5
Quote from: Blagojce on May 12, 2008, 08:09:10 AM
When i try to upload SQL show me this message:
Cannot connect to the MySQL database server with the supplied data.

If you are not sure about what to type in, please contact your host.
Access denied for user '********'@'localhost' (using password: YES)
Click here to try this step again.


and when i try with repair_settings.php show me this message:
Some settings are not being shown because the MySQL connection information is incorrect.

What's the problem?

Did You replace the Settings.php file?
It contains connection info to the Forum's MySQL database!

Open up the settings.php file, and search for

*********DATABASE INFO**********
Insert the MySQL connection combination giving to you by your host.
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

Blagojce

When i open Settings.php and Settings_bak.php give me blank screen.

N3RVE

#7
Download and unpack a fresh archive from the Downloads section linked on top of this page!
Transfer Settings.php and Settings_bak.php to host!

Open up Settings.php
Look for

########## Database Info ##########
$db_server = 'localhost'; ((db host address, most times - this is Localhost))
$db_name = ' MySQL DATABASE NAME';
$db_user = 'USER FOR ABOVE DATABASE';
$db_passwd = 'USER'S PASSWORD';
$db_prefix = 'THE PREFIX'; ("smf_" by default) - without quotes

EDIT: You should download and open the files, don't point a browser to them!

NOTE: All Settings will be lost, forum name, etc! You can set them by editing the file!
Alternatively, run Repair_Settings.php
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

Blagojce

#8
What when i open the file?
And with the repair_settings.php show me above message (in my first post).

N3RVE

#9
What I posted above is very clear, modify the settings.php file with MySQL connection details!

The Steps above will help You Out!

Regards,
[nerve] out!!
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

Blagojce

I set settings.php with my SQL connection details, but same happening. :-[
Please help me... :-[ :-[

metallica48423

contact your host to verify that your mysql connection information is correct.

This error is generated by MySQL, not SMF.
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Blagojce

When i try to install install.php i get this message:
Unable to connect to FTP server with this combination of details.
What's the problem with this?

I open Setting.php and inside is same names like i put in the install.php.

And in the repair_settings.php i get this message:
Some settings are not being shown because the MySQL connection information is incorrect.

I try on different host but i habe same problem. :-[

Kindred

You are pointing out two different errors.

1- the FTP information that you entered is not correct, so the system can not use FTP to change file permissions or update files.

2- The database information that you entered is incorrect. The system can not connect to your mySQL database in order to add the tables that it needs to install the forum into the database.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Blagojce

And now what i need to do?

Kindred

get/use the correct information.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Blagojce

I use the correct information but i get same message. Why?

Kindred

It would appear that you are NOT using the correct information, otherwise it would work.

1- did you set up a new database and a database user/password through your site's cpanel?
2- try setting up a ne FTP user with full access to the forum directory and subdirectories in your Cpanel. Then us that information.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

N3RVE

Hello Blagojce, I see Kindred is helping You out here!

Creating two topics regarding the same issue is unecessary
http://www.simplemachines.org/community/index.php?topic=238977

Like Metallica stated on your first topic;
Contact Your Host to confirm that the information You are using to connect is correct.

Have You done that?
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

N3RVE

The Topic has been merged. .

@Blagojce;
Are You still having this problem?
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

Advertisement: