Posted by:
vdolnik1
(---.hfc.comcastbusiness.net)
Thanks to c2dan and zahidansari for their time and effort.
I placed php_mysql.dll and other files in Windows and Windows/system32 but it did not work.
I tried the other procedure too. It did not make a copy of php.ini automatically and I had to manually copy it but the rest of the suggested procedure worked for me.
I made a progress and was able to open phpmyadmin and see the content of my databases made under older versions of mySQL and php. Nevertheless, I could not make any connection from my php document to my database getting responds to my line
$connection = mysql_connect("localhost", "xxx", "yyy"
;
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'xxx'@'localhost' (using password: YES) in C:\blog\def.htm on line 12
mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\blog\def.htm on line 19
I tried to make it around and changed the user in mysql database through phpmyadmin but now I cannot connect to the mysql database through phpmyadmin, getting the message
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
I changed the user to ‘root’ and removed the password in php.ini but it did not help.
I tried SET PASSWORD FOR root@localhost=PASSWORD('MyNewPassword'); in the MySQL console without success.
So I have 3 questions now:
1) How can I regain the access to the databases? (I can simply reinstall WAMP as a fastest solution but leave it as my last resort.)
2) How can I make my php document to get information from a database without receiving the message mysql_connect() [<a href='function.mysql-connect'>function.mysql-
3) How can I make my php document to get information from database without receiving the message mysql_fetch_array(): supplied argument is not a valid MySQL result resource
I would appreciate your help and advices. Two weeks ago, I was ready to give up and stay with my old php etc. Now I believe I can finish my transfer to PHP5 but will need “a little help from my friends”.
Best regards,
Vlad Dolnik