Mysql Error

[rav4rosie]

I'm trying to install pmachine(.com) on my site. I get the following error.

 

------------------------------------------------------------------

MySQL Error: 1044 Access denied for user: 'ravrosie@localhost' to database 'ravrosie'

Unable to create the database specified in your config file.

 

There was a problem trying to create the following database: ravrosie

 

Please contact your hosting provider to verify that you have the privileges necessary to do so.

-------------------------------------------------------------------

Here is a copy of my config.php. Not sure what I am doing wrong? Help pls!

 

<?php

 

// DATABASE VARIABLES

// If you do not know what these values should be, please contact

// your hosting provider. Most problems occur as a result of

// an error in this file.

 

 

// HOST NAME OR SERVER ADDRESS

// Usually this is the name of your domain (www.yoursite.com).

// In some cases the hostname will instead be "localhost".

$hostname = "localhost";

 

 

// MySQL USERNAME

// This is the username you use to access your MySQL database.

// Note: This is usually NOT the same as your FTP username.

$dbusername = "ravrosie";

 

 

// MySQL PASSWORD

// The password used to access your MySQL database.

// Note: This is usually NOT the same as your FTP password.

$dbpassword = "indigo";

 

 

// DATABASE NAME

// Some hosting providers assign you a specific database.

// If this is the case, change this variable to the name of

// the database they require, otherwise you can leave it alone.

// If you are not using an existing database you might have

// to create the database prior to installing pMachine.

$dbname = "ravrosie";

 

 

// DEFAULT LANGUAGE OPTION

// This variable determines the default language used in the control panel.

// Language packs can be downloaded at pMachine.com. You can override the

// default language on a per-login basis if you have more than one language

// pack installed.

$language = "english";

 

 

// FOR ADVANCED USERS -----------------------------------------------------

// Do not mess with these variables unless you know what you are doing.

 

// DEBUG

// This variables turns PHP and MySQL error message on or off for

// debugging purposes. It is recommended that you leave debug on during

// development only - not with a "live" site, due to security issues.

// 1 = on

// 0 = off

$debug = 1;

 

 

// DATABASE

// mysql is the only supported database at this time.

$database = "mysql";

 

 

// DATABASE TABLE PREFIX

// Change this if you want the database tables to be installed

// with a different prefix.

$dbprefix = "pm";

 

 

// DATABASE CONNECTION TYPE

// 0 = non-persistent

// 1 = persistent (generally faster)

$conntype = 1;

 

 

// IMAGE UPLOAD METHOD

// This variable determines which method pMachine uses to upload images.

// 1 = Default method. Recommended for newer versions of PHP, especially with

// register_globals = off

// 2 = Works with older versions of PHP (uses "copy" method).

// 3 = Words with older versions of PHP (uses "move_uploaded_file" method).

$upload_method = 1;

 

 

// SESSION ID OPTION

// Cookies are used in the control panel by default. Query string

// session ID's can be used instead, by setting this variable to 1

// rather than 0.

$use_session_id =0;

 

 

// HEADER REDIRECT

// Alternate header redirect. Some NT servers

// have difficulty setting cookies when the standard php header

// redirect (header("location:x.php") is used. This variable allows

// you to use the slower "meta tag refresh" method which has proven to be more

// reliable for those servers with problems setting cookies.

$redirect_method =0;

 

 

// OPEN_BASEDIR RESTRICTION

// If your php configuration has an "open_basedir" restriction

// change this variable to "1".

$open_basedir =0;

 

 

// If you set the previous variable to "1", this is the name of

// your "members" directory.

$obd_memdir = "./members/";

 

?>

[rayners]

Everything involving MySQL here is formatted as follows:

 

accountname_database/username/etc

 

For example, my username in MySQL for my account is rayners_rayners, and my databases are named rayners_databasename.

 

Have you created a database user for yourself through CPanel yet? If not, I suggest you do that first. Then create a database through CPanel, and give your username access to it. After that, change the corresponding values in config.php and you should be good to go.

[rav4rosie]

Thank you! That fixed my problem.

 

Rosie