CMS Made Simple Forums

Hello All!!

I'm getting an error message after provide information in step 3 of the installation process. The message says it was not possible to connect to the database with the information supplied.

"Could not connect to the database. Verify that username and password are correct, and that the user has access to the given database."

I have performed the following steps to create the database and user in my MySQL. Since I do not have much expertise in MySQL please take a look carefully to see if I did something wrong.

I logged in my box with root account, connect on the database with mysql -u root -p

1. create database cms;
2. GRANT ALL ON cms.* TO cms@localhost IDENTIFIED BY "********"
3. quit

After that the user and database named cms were created successfully.

Step 3 of the installation process requests the following information:

Field                                Information supplied

Database Type                         Mysql
Database Host Address           localhost
Database Name                        cms
Username                                cms
Password                             **********
Table prefix        (I don't know what is that, but I set as default ->  cms_ )
Create Tables                          Yes
Install Sample content and templates   Yes

The above were the procedures performed to set Step 3 of the installation process. I really do not know
what went wrong but I keep seeing that error message when attempt to continue in Step 3.

I'd would appreciate if you could help me solve this issue.

Best Regards

Rodrigo

You should also create a user and give him a password to work in the DB. You now created a DB called CMS, but you didn't create a user "cms", but you try to connect to the DB using that login.

The prefix are the first characters used for the tables CMSMS creates, as you can hold more tables in the DB than just CMSMS.

Ronny

RonnyK wrote: You should also create a user and give him a password to work in the DB. You now created a DB called CMS, but you didn't create a user "cms", but you try to connect to the DB using that login.

Ronny

Hello Ronny!!

I googled around to see the procedures used to create a user in mysql and I found that the command
GRANT ALL ON cms.* TO cms@localhost IDENTIFIED BY "********"
would do the job. Since this is not the case what command I must run to create a user and set a password to it in Mysql?

Thank You!

Rodrigo

I don't have access to my own environment as I'm on the road, but I normally select, "create user" and select the option to "create a DB with the same name". The system then creates a db with the same name as the user created.

Ronny

You mean via command line?

I think the problem is not the user because I can login with it via command line:

root@shadow:/# mysql -u cms -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 26
Server version: 5.0.38-Debian_3-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>   

Hello All

Since I'm not familiar with mysql command line I've installed phpmyadmin to manage mysql and through it I could see
that all permissions on cms are correctly to user cms_user...

What can be causing this error in my environment??

Thank You

If the user that has the correct rights in the DB is "cms_user" then you should connect with "cms_user" instead if ""cms". In your first post, you mentioned that you tried to connect with "cms". The user/password provide there should be the user/password that has access to the created DB.

Ronny

RonnyK wrote: If the user that has the correct rights in the DB is "cms_user" then you should connect with "cms_user" instead if ""cms". In your first post, you mentioned that you tried to connect with "cms". The user/password provide there should be the user/password that has access to the created DB.

Ronny

Actually I have already tried both. User cms_user was just another attempt to connect to DB. I created this user to perform another
test, that unfortunately failed too.

Thank you for your help!!

Any news please let me know!