Advanced search  

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

Pages: [1]   Go Down

Author Topic: MySQL and installation issues...  (Read 2484 times)

0 Members and 1 Guest are viewing this topic.

SmedRock

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
MySQL and installation issues...
« 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?

SysAdm

  • Coppermine newbie
  • Offline Offline
  • Posts: 13
Try this file tester...
« Reply #1 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.

_____________
Code: [Select]


<?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
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 19 queries.