Connecting to the Database, Step 10, Problem Solving

Note: This is not a problem I’m having. I’m just writing this simple guide to the ones here new to CMS Made Simple and are not very technical or database literate.

From reading other post (and my own installation experience…) I understand that lots of you have this problem… You are not really a programming engineer, but you are good enough to do some of your own HTML coding, etc. You follow the instructions (and are sure you followed to the dot) and when it comes to step 10 you can’t connect to the database!

First of all, regarding the database, you only need to create a simple database. No tables, etc. Best way to do it is via MyPhpAdmin. With Yahoo! Hosting, just find the database section under “Create and Manage”, install the MyPhpAdmin (in a new folder I would advise), then log in and make a new database simple called “CMS”. Now the problem is that by default the new database does not have all privileges. However, you can’t grant new privileges with your new user name and password called cms_user and cms_pass. However, at this level, you do have the authority to change passwords. So select the username “yroot” and change its password. Now log out of the account and log back in to MyPhpAdmin using “yroot” user and then change the privilege to “cms_user” to “Grant All”.

Now this is the most important part: When you get back to step 10, the default under “Database Host Name” is “localhost”. You need to change this to “MySql”.

BTW... The instalation method used was "Quick Install via FTB". I had installed 2 sites using this method and worked like charm!

This was very very helpful.  Thank you.

Hello,

every forum user has write access to the documentation (wiki). Feel free to enhance it : install procedures, troubleshooting section, FAQ, HowTos... exist and can be improved.

Pierre M.

_________________
-- Pierre, support team member. comodérateur du forum francophone.
Please read "how to submit installation/support requests" before posting. Don't send private messages to ask for support.
Want to contribute to CMSms ? Improve the wiki with your forum account.