installed php on zend for oracle and mysql does not work

[Duke555]

how are you?

 

i have the following problem and i was wondering if anyone could help.

i installed php (Zend) with Oracle support and then decided to use mySQL.

here is an error that i got after trying to connect to mySQL DB:

=========

Fatal error: Call to undefined function mysqli_connect() in C:\Study\PHP\test.php on line 10

 

i did read PHP Installation manual which addresses this issue at:

 

http://www.php.net/manual/en/mysqli.installation.php

 

and i inserted the line below into my php.ini file:

==========

extension_dir = C:\Program Files\Zend\Core For Oracle\lib\phpext

 

after all of that i still get the same error. is there anything else i am supposed to do with php.ini file and/or other config. files?

 

thank you

[andrewgauger]

// change the following line from ...

;extension=php_mysqli.dll

 

// ... to

extension=php_mysqli.dll

[Duke555]

did that and now i have a new error:

 

Warning: mysqli_connect(): (28000/1045): Access denied for user 'someuser'@'localhost' (using password: YES) in C:\Study\PHP\test.php on line 10 Could not connect to mySQL: Access denied for user 'someuser'@'localhost' (using password: YES)

 

 

is it php.ini related?

 

 

thank you

[andrewgauger]

Well, you are going to have to set up a user name and password for your mysql database, I think it defaults to 'root' and password ''

 

so your standard mysql_connect is

mysql_connect('localhost', 'root', '');

I would suggest you change this.

 

http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html

 

A bit technical, but get used to doing it the platform independent way.

[Duke555]

yes, thank you so much for that.

i went through the steps and i think what i forgot to do for 'someuser' account was to FLUSH PRIVILEGES;

 

i do not know why mysql does not do it automatically, iassume FLUSH PRIVILEGES is like a COMMIT in transaction management, but that is life i guess.