News:

CRITICAL UPGRADE CPG RELEASE 1.6.30
Version 1.6.30 removes a serious security issue that could allow unauthorized access to modify your site. Upgrade as soon as possible.

Main Menu

MySQL and installation issues...

Started by SmedRock, January 03, 2004, 01:11:24 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

SmedRock

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?

SysAdm

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