I Read the instructions but I keep getting a:
Could not connect to the database. Verify that username and password are correct, and that the user has access to the given database.
Should be a No brainer right ?
This is what I have so far - This is the name of your site. It will be used in various places of the default templates and can be used anywhere with the {sitename} tag.
Database Information
Make sure you have created your database and granted full privileges to a user to use that database.
For MySQL, use the following:
Log in to mysql from a console and run the following commands:
create database cms; (use whatever name you want here but make sure to remember it, you'll need to enter it on this page)
grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';
Please complete the following fields:
Database Type: MySQL
Database host address (blank)
Database name: jcolome1_cms
Username: jcolome1_jcolome
Password: ********
Table prefix: cms_
Create Tables (Warning: Deletes existing data) checked
Install sample content and templates - checked
Here's what is on the Cpanel -
Current Databases:
jcolome1_cms
Users in cms
jcolome1_jcolome (Privileges: ALL PRIVILEGES)
Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:jcolome1_cms:localhost","jcolome1_jcolome","");
PHP $dbh=mysql_connect ("localhost", "jcolome1_jcolome", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("jcolome1_cms");
New Database:
--------------------------------------------------------------------------------
Current Users:
jcolome1_jcolome
Username:
Password:
--------------------------------------------------------------------------------
Add Users To Your Databases:
User: jcolome1_jcolome Database: jcolome1_cms
Privileges:
ALL or SELECT CREATE
INSERT ALTER
UPDATE DROP
DELETE LOCK TABLES
INDEX REFERENCES
CREATE TEMPORARY TABLES
Any ideas what I can be doing WRONG
Getting really pissed off here (sorry for the french)
Also, changed file permissions as instructed in the docs
Thanks -
Jcolome
