coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: SmedRock on January 03, 2004, 01:11:24 AM

Title: MySQL and installation issues...
Post by: SmedRock on January 03, 2004, 01:11:24 AM
When running the install.php routine, I get to the point where I have defined my SQl DB and then click on Let's Go!. I get this error,

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user: 'smedphot@XXXXXXX'
(Using password: YES)
 The X'x are for security reasons. :)

I have created the DB through the MySQL manager on my host. Do I need to do that or am I missing something?
Title: Try this file tester...
Post by: SysAdm on January 03, 2004, 03:58:42 AM
Copy/Paste this into notepad and save the file as mysql_test.php and upload it to your server.  Then run the file from your browser.

_____________


<?php

$DBName 
"YOUR_DB_NAME";
$DBUser "YOUR_USER_NAME";
$DBPass "YOUR_PASSWORD";
$DBHost "YOUR_HOST_URL";

$link mysql_connect &#40; $DBHost, $DBUser, $DBPass &#41;
or die &#40; "Could notconnect<br><br>" &#41;;

print &#40; "Connected to mysql server successfully<br><br>" &#41;;

mysql_select_db &#40; $DBName &#41;
or die &#40; "Could not select database<br><br>" &#41;;

print &#40; "Connected to database successfully<br><br>" &#41;;

mysql_close &#40; $link &#41;;

?>



____________

Make sure to add the correct info for your MySQL... (between the parenthesis)

This is a quick test to make sure your user/pass/path are correct before attempting an install....

_____SysAdm