Issue with new MySQL 4.1.11

 
Post new topic   Reply to topic    Aprelium Forum Index -> General Questions
View previous topic :: View next topic  
Author Message
sime
-


Joined: 21 Apr 2005
Posts: 5
Location: Croatia

PostPosted: Thu Apr 21, 2005 7:54 pm    Post subject: Issue with new MySQL 4.1.11 Reply with quote

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 View user's profile Send private message
sime
-


Joined: 21 Apr 2005
Posts: 5
Location: Croatia

PostPosted: Thu Apr 21, 2005 11:30 pm    Post subject: Reply with quote

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 View user's profile Send private message
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA

PostPosted: Fri Apr 22, 2005 12:06 am    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
sime
-


Joined: 21 Apr 2005
Posts: 5
Location: Croatia

PostPosted: Fri Apr 22, 2005 8:20 am    Post subject: Reply with quote

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 View user's profile Send private message
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA

PostPosted: Fri Apr 22, 2005 10:57 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
sime
-


Joined: 21 Apr 2005
Posts: 5
Location: Croatia

PostPosted: Sun Apr 24, 2005 10:38 am    Post subject: Reply with quote

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 View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> General Questions All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group