Can Not Connect to Database, Step 10, Problem Solvin
Posted: Sun Nov 25, 2007 8:40 pm
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”.
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”.