Problem with MySQL server?

Regular Joined: Aug 01, 2007 Posts: 66

I'm getting this message on my set up:

There seems to be a problem with the MySQL server - Sorry for the inconvenience.

Please report this to the Administrator ASAP.

We should be back shortly.

MySQL is Reporting

Access denied for user 'rnv210'@'localhost' (using password: YES)

The site is www.BFmarines.com/html is this a problem with my set up or what. I can't go any further with the install.

registered · Posted: Fri Aug 03, 2007 7:41 am

There's gotta be something wrong with your database settings in config.php

Posted: Fri Aug 03, 2007 8:04 am

My host support says it's a problem with the user name and password in the MySQL file. I guess it's because I don't have a user in there!!!

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

That would do it...

New Member Joined: Aug 20, 2007 Posts: 9

Im getting the same error, can someone please help.

I have a Database, Username & Password. Ive put in the correct details in the config.php file and still get the error.

Here is the starting of the config.php file ive filled out:

// Database & System Config
//
// dbhost: SQL Database Hostname (Ive put in the hostname)
// dbuname: SQL Username (Ive put in my username)
// dbpass: SQL Password (Ive put in my password)
// dbname: SQL Database Name (Ive put in the database name)
// $prefix: Your Database table's prefix
// $user_prefix: Your Users' Database table's prefix (To share it)
// $dbtype: Your Database Server type. Supported servers are:
// MySQL, mysql4, postgres, mssql, oracle, msaccess,
// db2 and mssql-odbc
// Be sure to write it exactly as above, case SeNsItIvE!

Im guessing ive put the details in wrong, can someone please give an example on how to fill in the spaces appropriatley?

ie:

// Database & System Config
//
// dbhost: localhost
// dbuname: joe
// dbpass: bloggs
// dbname: home
// $prefix: Your Database table's prefix
// $user_prefix: Your Users' Database table's prefix (To share it)
// $dbtype: Your Database Server type. Supported servers are:
// MySQL, mysql4, postgres, mssql, oracle, msaccess,
// db2 and mssql-odbc
// Be sure to write it exactly as above, case SeNsItIvE!

This is how ive filled out the config.php file, can someone correct if that wrong.

Cheers
Sys!

Posted: Tue Aug 21, 2007 4:25 am

Welcome. Just to clarify, is there a database user with the name and password you assigned in dbuname and dbpass, and if so, is that user attached to the nuke database specified in dbname? Do you have other applications using the same dbhost?

Posted: Tue Aug 21, 2007 4:34 am

Yep, ive filled out the config.php file as asked. Here is exactly what ive put in, and how ive done it, copied and pasted from my config.php file on my server now:

// dbhost: localhost
// dbuname: system
// dbpass: **********
// dbname: nuke
// $prefix: nuke
// $user_prefix: Your Users' Database table's prefix (To share it)
// $dbtype: MySQL
//
//
//

Have i filled this out properly? Missing any symbol? typo? And what do you mean by any other applications? where would i know this and how?

When im in myphpadmin control panel, on main page i click on 'databases' underneath 'storage engines' it brings up 'nuke' which is the name of my database and above this is something else called 'information_shema'

Now what i want to know, is this normal? ive only made one database, not 2.

Sorry, im quite new to this!

Sys!

Posted: Tue Aug 21, 2007 5:43 am

It looks like you have filled out the details in the wrong place in the config.php file because all the lines have // in front of them which would comment out the code.

You need to scroll a bit further down the page and change the lines which aren't being commented out.

Posted: Tue Aug 21, 2007 6:13 am

Thanks jake Smile

your a legend

Posted: Tue Aug 21, 2007 8:36 pm

**UPDATE**

Problem fixed, Thanks Guys!

Posted: Sat Aug 25, 2007 2:51 pm

Excellent, glad it's working! Wink

New Member Joined: Mar 26, 2006 Posts: 9

Um, why would my installation say the same thing?
------------------------------------
MySQL Database Connectivity Test Results

config.php file found!

I was unable to reach your MySQL server using the MySQL connection settings in your nuke config.php file. The exact error that MySQL reported is:

MySQL Error # 2 = Access denied for user 'rnv210'@'localhost' (using password: YES)

---------------------------
Now.. i am trying to install this from the start and need a bit of help.

Thanks!

Posted: Mon Oct 15, 2007 2:49 pm

Have you filled out the config.php file with your details. It looks your user is still set to rnv210, which is the default that comes with the RN package.