 Trouble Getting MySQL To Work With PHP5 |
|
|
|
|
  |
 Feb 19 2006, 05:33 AM
Post
#1
|
|
|
Newbie [ Level 2 ]  Group: Members Posts: 16 Joined: 15-February 06 Member No.: 11,304  |
I have trouble getting the mySQL to work with PHP5.
The script stops when it reaches the mySQL part. I also got this error message when trying to install phpadmin QUOTE Cannot load mysql extension. Please check your PHP configuration. - Documentation Any advice to get mySQL to work with PHP5? |
 |
 
|
|
Feb 19 2006, 05:40 AM
Post
#2
|
|
|
PsYcheDeLiC dR3aMeR  Group: Admin Posts: 2,242 Joined: 29-January 05 From: Nakorn Chaisri, Thailand Member No.: 2,411 |
You've got to paste more details of the script - at least from the part right before the mysql calls and the whole block of mysql code - else it won't be possible to figure out what's going wrong.
|
|
|
|
|
Feb 19 2006, 06:05 AM
Post
#3
|
|
|
Newbie [ Level 2 ] Group: Members Posts: 16 Joined: 15-February 06 Member No.: 11,304 |
sorry i'm awfully tire at the moment... I shouldn't really ask questions when my mind is tire... I was getting frustrated at these errors. Need to catch up on some sleep.
 How do I fix: QUOTE Access denied for user 'root'@'localhost' (using password: NO) This post has been edited by NewGuyinTown: Feb 19 2006, 06:13 AM |
|
|
|
|
Feb 19 2006, 07:54 AM
Post
#4
|
|
|
PsYcheDeLiC dR3aMeR Group: Admin Posts: 2,242 Joined: 29-January 05 From: Nakorn Chaisri, Thailand Member No.: 2,411 |
QUOTE(NewGuyinTown @ Feb 19 2006, 01:05 PM)  sorry i'm awfully tire at the moment... I shouldn't really ask questions when my mind is tire... I was getting frustrated at these errors. Need to catch up on some sleep. How do I fix: Access denied for user 'root'@'localhost' (using password: NO) If this is your only error, then your error-message clearly says what went wrong. See that using password: NO part ? That says you tried to access your database without using the proper MySQL root password. Hence access was denied. You solution is to pass the password along with the username while connecting to the server. If you have any further queires - feel free to post. |
|
|
|
|
Feb 22 2006, 05:07 PM
Post
#5
|
|
|
Member - Active Contributor Group: Members Posts: 98 Joined: 27-January 06 Member No.: 10,907 |
NewGuyinTown i think your problem as to do with Php.ini file.
You must copy php.ini-dist to C:\Windows\ In php.ini file C:\Windows\ you must remove the ";" before "extension=php_mysql.dll" Remember to set "extension_dir" in php.file to extension_dir = "<DRIVE>/php/ext", also copy libmysql.dll para C:\Windows\system32 Anyway here a link for better help PHP MYSQL INSTALL good luck |
|
|
|
|
Feb 23 2006, 09:39 AM
Post
#6
|
|
|
PESTICIDAL MANIAC Group: Members Posts: 626 Joined: 1-September 04 From: Auckland, New Zealand Member No.: 27 |
What version of MySQL are you using?
Do you have console access to it? Try to run mysql commandline and if you get the message 'does not support authentification...' (I think, it's been too long since I encounter these problems) then you're using the old incompatible passwords for the database, or you're using a new password but calling it by the old password. PHP 5 introduces mysqli, which is mysql improved. It's not backwards compatible with older databases, also depends on what database you're using, and whether it'd work. If you upgraded to PHP 5 and haven't upgraded the database, you should do that too, following the upgrade directions from mysql's manual. Cheers, MC |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 11th October 2008 - 02:57 PM |