Setting up a data base in cpanel
-
Gomeza
Setting up a data base in cpanel
This should be easy but for some reason I keep getting a "cannot connect to data base" error at step 4 of the installation. I am a cPanel user and have set up data bases in the past but after numerous tries, I'm stumped on this one. Would anyone like to take a stab at it? I don't mind paying a small fee.
-
Pierre M.
Re: Setting up a data base in cpanel
Hello,
may be it is an access rights issue : the db user must have create/alter table permissions.
You should create your database, then try it with PhpMyAdmin or so (or any other PHP app) and only then go with CMSms if your user can access to the db and play with it.
Have fun.
Pierre M.
may be it is an access rights issue : the db user must have create/alter table permissions.
You should create your database, then try it with PhpMyAdmin or so (or any other PHP app) and only then go with CMSms if your user can access to the db and play with it.
Have fun.
Pierre M.
-
Gomeza
Re: Setting up a data base in cpanel - solved
To solve this problem I went into install.php and changed the data base name, user and password to suit the prefixes that cPanel kept adding when I created the database. (I must have missed the instructions to do this) I was then able to follow all 5 steps of the install. My site is up and running now and seems to be working perfectly. Once I am certain that all is well, I will add how to do this to the documentation for cPanel users.
-
heatherfeuer
Re: Setting up a data base in cpanel
Actually, most cPanel users should already know that all databases and user names are prefixed by the default name given to the hosting account. So if your hosted account's default name (used for signing in to cPanel) is 'smith,' your databases and users would all have the prefix smith_ in front of them.
You don't need to change anything in the install.php file. When you are prompted for the database name and user name, just be sure you include the prefix. So, staying with my example, the database name would be 'smith_cms' and the user would be 'smith_cms_user'. Also bear in mind that when the database is created, as Pierre noted, you need to go into phpMyAdmin and create a user and then grant that user all rights to the database.
You don't need to change anything in the install.php file. When you are prompted for the database name and user name, just be sure you include the prefix. So, staying with my example, the database name would be 'smith_cms' and the user would be 'smith_cms_user'. Also bear in mind that when the database is created, as Pierre noted, you need to go into phpMyAdmin and create a user and then grant that user all rights to the database.
-
Gomeza
heatherfeuer - that is exactly what I tried to do
and ultimately why I was stumped.
I meticulously placed all of the proper data base names, user names and passwords, with all of the proper extensions created by cPanel into the proper fields during step 4 of the install process. Trying this numerous times. I set up a new database no less than three times and even checked a number of other possibilities, including my firewall settings. If you yourself have experience with using cPanel and are suggesting that my troubles are unique, this tells me that there may be another as yet discovered problem with my installation. For now however, everything seems to work fine.
I meticulously placed all of the proper data base names, user names and passwords, with all of the proper extensions created by cPanel into the proper fields during step 4 of the install process. Trying this numerous times. I set up a new database no less than three times and even checked a number of other possibilities, including my firewall settings. If you yourself have experience with using cPanel and are suggesting that my troubles are unique, this tells me that there may be another as yet discovered problem with my installation. For now however, everything seems to work fine.
