MySQL and installation issues... MySQL and installation issues...
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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