| 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 | 
		
			          | 
		
	
	
		  | 
	
	
		 |