View previous topic :: View next topic |
Author |
Message |
sime -
Joined: 21 Apr 2005 Posts: 5 Location: Croatia
|
Posted: Thu Apr 21, 2005 7:54 pm Post subject: Issue with new MySQL 4.1.11 |
|
|
Hello,
I have one issue with MySQL 4.1.11. I used new essential installer and installed MySQL as a windows service. Port is 3306 and it's enabled in windows firewall.
I use PHP5 (aprelium preconfigured package), it's installed right, and PHP works, checked with phpinfo();. I decided for mysqli extension because I read somewhere that it's preferable with PHP5.
phpMyAdmin is also installed right, but it gives that famous error message:
"cannot load mysqli extension,
please check PHP Configuration"
PHP5 is configured as ISAPI.
Extension is uncommented in php.ini and everything works exept MySQL. I really don't know what to do. I read all tutorials and tried everything, please, help...
I choose this way, because it's so clean, my abyss is installed as win service, mysql as service... It's invisible, yet stunning fast!
Thanks in advance |
|
Back to top |
|
 |
sime -
Joined: 21 Apr 2005 Posts: 5 Location: Croatia
|
Posted: Thu Apr 21, 2005 11:30 pm Post subject: |
|
|
OK, I resolved issue with loading mysqli extension (I copied php.ini from PHP5 installation dir to C:\Windows although I configured PHP_RC to C:\Program Files\PHP5, any feedback on how to resolve this, so that PHP looks for its configuration file in installation directory instead of in C:\Windows?)
But, now I get the following error message from MySQL:
"#2003 - Can't connect to MySQL server on 'localhost' (10061)"
So, it seems that MySQL isn't configured properly on my machine...
Can someone do tutorial for latest stable version of MySQL (4.1.11) with it's essential installer to install MySQL as Windows service? |
|
Back to top |
|
 |
TRUSTAbyss -
Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA
|
Posted: Fri Apr 22, 2005 12:06 am Post subject: |
|
|
You need to load php_mysql.dll from your php.ini , thats the only way it will
work , after you load php_mysql.dll , create a info PHP script and look for a
table that says MySQL and that will tell you if MySQL is enabled.
PHP Information Script:
Code: |
<?php
phpinfo();
?> |
|
|
Back to top |
|
 |
sime -
Joined: 21 Apr 2005 Posts: 5 Location: Croatia
|
Posted: Fri Apr 22, 2005 8:20 am Post subject: |
|
|
As I said, I managed to get php_mysqli.dll extension working.
In phpinfo(); I have this:
"mysqli
MysqlI Support enabled
Client API version 4.1.7
MYSQLI_SOCKET /tmp/mysql.sock
Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off" |
|
Back to top |
|
 |
TRUSTAbyss -
Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA
|
Posted: Fri Apr 22, 2005 10:57 pm Post subject: |
|
|
I said php_mysql.dll not php_mysqli.dll , your MySQL should be working now
and also you need to put php.ini in C:\Windows then it should work. LateR!
Sincerely , TRUSTpunk |
|
Back to top |
|
 |
sime -
Joined: 21 Apr 2005 Posts: 5 Location: Croatia
|
Posted: Sun Apr 24, 2005 10:38 am Post subject: |
|
|
The php is configured fine, either with mysqli or mysql, I tried both now, and php and extensions are working.
The problem is with the new MySQL 4.1.11. I can't configure it right it seems. pypMyAdmin now says that the mysql server is not responding...
Can someone please try the new mysql 4.1.11 essentiall installer and write how to configure it right as a win service? |
|
Back to top |
|
 |
|