Page 1 of 1
Can someone explain the database creation via cpanel
Posted: Mon Oct 17, 2005 12:15 am
by albaby
The instructs in the install.txt are confusing, cpanel wants a database name, a user and pass. The install.txt (below) doesnt even mention a password?
3. Create the cms database and grant a user rights to use it:
- login to mysql: mysql -u root -p
create database cms;
grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';
quit
Re: Can someone explain the database creation via cpanel
Posted: Mon Oct 17, 2005 6:47 am
by Hans
Re: Can someone explain the database creation via cpanel
Posted: Mon Oct 17, 2005 7:48 am
by Al Guevara
Those were certianly better and clear instructions, thanks, but it still failed on Step 2
Warning: mysql_connect(): Access denied for user: 'cms_user@localhost' (Using password: YES) in /home/guevara/public_html/lib/adodb/drivers/adodb-mysql.inc.php on line 340
Connection failed
Re: Can someone explain the database creation via cpanel
Posted: Mon Oct 17, 2005 7:53 am
by Hans
Are you sure you entered the databasename and the user correct? Sometimes cpanel adds a prefix before the names you entered (e.g. nameofsite_)
And : did you add the user to the database in question?
Hans
Re: Can someone explain the database creation via cpanel
Posted: Mon Oct 17, 2005 5:50 pm
by Al Guevara
Yes it seems Cpanel adds a PREFIX similar to the HOST username, to the database username, so thats my ACTUAL username? So its prefixa_cms_user, not cms_user?
Re: Can someone explain the database creation via cpanel
Posted: Mon Oct 17, 2005 7:10 pm
by Hans
Yes use the frefix in both the databasename and the user name.
Hans
Re: Can someone explain the database creation via cpanel
Posted: Tue Oct 18, 2005 1:52 am
by albaby
It worked! Awesome, thanks much Hans!