Author |
Message |
cruiser
New Member


Joined: Nov 06, 2004
Posts: 19
Location: canada
|
Posted:
Mon Nov 08, 2004 10:16 pm |
|
im looking for a person thats good with sql i need a volenter to help me .
i have a web page thats been up 6 mnths i whent in to the cpanel an not the web wont work i know its to do with sql. i did read abit onthis but im green . this is my problem. i have no idea what to do to fix this .
any help would be great.
I see message_die()?
This means that nuke is unable to connect to the MySQL server and/or database. Normally it means the MySQL parameters are incorrect in the nuke config.php file. |
_________________
|
|
 |
 |
Raven
Site Admin/Owner

Joined: Aug 27, 2002
Posts: 17088
|
Posted:
Mon Nov 08, 2004 10:40 pm |
|
Verify that your username, password, and database name are correct. Meaning, that they are the same as what you are using in cPanel. |
|
|
|
 |
cruiser

|
Posted:
Tue Nov 09, 2004 8:12 am |
|
do i have to use sam user name an password as cpanel for the sql db |
|
|
|
 |
Raven

|
Posted:
Tue Nov 09, 2004 8:15 am |
|
|
|
 |
cruiser

|
Posted:
Tue Nov 09, 2004 8:27 am |
|
this is where the trouble is
im trying to change the sfaclan to teamaod
dbh = DBI->connect("DBI:mysql:sfaclan_Vwar:localhost","sfaclan_StonedCo","<PASSWORD HERE>"); PHP $dbh=mysql_connect ("localhost", "sfaclan_StonedCo", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("sfaclan_Vwar"); |
|
|
|
 |
cruiser

|
Posted:
Tue Nov 09, 2004 8:48 am |
|
this is from the old cpanel .
MySql account
sfaclan_
sfaclan_Vwar
user in Vwar
sfaclan_Vwar
sfaclan_StonedCo (Privileges: ALL PRIVILEGES)
dbh = DBI->connect("DBI:mysql:sfaclan_Vwar:localhost","sfaclan_StonedCo","<PASSWORD HERE>"); PHP $dbh=mysql_connect ("localhost", "sfaclan_StonedCo", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("sfaclan_Vwar");
sfaclan_stoned (Privileges: ALL PRIVILEGES
$dbh = DBI->connect("DBI:mysql:sfaclan_Vwar:localhost","sfaclan_stoned","<PASSWORD HERE>"); PHP $dbh=mysql_connect ("localhost", "sfaclan_stoned", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("sfaclan_Vwar");
i just cant seem to change it to get it working |
|
|
|
 |
sixonetonoffun
Spouse Contemplates Divorce

Joined: Jan 02, 2003
Posts: 2496
|
Posted:
Tue Nov 09, 2004 9:13 am |
|
Sometimes I have had trouble with adding a user to a database from CPanel that is why I asked if you could create a new one in the other thread. It will show the new user but not function with the new user. |
_________________ [b][size=5]openSUSE 11.4-x86 | Linux 2.6.37.1-1.2desktop i686 | KDE: 4.6.41>=4.7 | XFCE 4.8 | AMD Athlon(tm) XP 3000+ | MSI K7N2 Delta-L | 3GB Black Diamond DDR
| GeForce 6200@433Mhz 512MB | Xorg 1.9.3 | NVIDIA 270.30[/size:2b8 |
|
|
 |
cruiser

|
Posted:
Tue Nov 09, 2004 10:19 am |
|
if you want to have a look i can give you the info
where it says Host (% wildcard is allowed): what host do i put ? |
|
|
|
 |
sixonetonoffun

|
Posted:
Tue Nov 09, 2004 3:00 pm |
|
localhost should work check with your host if in doubt. |
|
|
|
 |
cruiser

|
Posted:
Tue Nov 09, 2004 3:30 pm |
|
where can i fine the file i could back it up i have the files saveed just need to no where to look for it . config.php file.
MySQL parameters are incorrect in the nuke config.php file. |
|
|
|
 |
sixonetonoffun

|
Posted:
Tue Nov 09, 2004 4:36 pm |
|
The nuke config is in the main directory.
/home/sfaclan/public_html/ |
|
|
|
 |
|