Firewall & MySQL Setup

[karldenton]

OK, from my thread in Web Development I managed to get IIS6 and PHP working.

Just trying MySQL now and when it installs it gives an error saying it can't connect to root@localhost on post 3306.

I've added the port to exceptions on Windows firewall but the firewall is actually turned off. At the bottom of the firewall it says "Managed by non-domain settings". I guess there is another firewall operating. I'm using Symantec Corperate but that is just the AntiVirus.

[karldenton]

Just to add the message is "access denied" for user root@localhost

[HodgeHi]

password for root maybe?

[karldenton]

Yeah thats the problem.

Removed MySQL and started again. WHen it comes to setting password, if needs the current root password which I put in, but then I want the new one to be blank but it doesn't allow it. Is there a way to remove password totally ?

[HodgeHi]

Why would you want the root password to be blank?

It really should be secure the root password.

 

As for your question i am not too sure. You could download the mysql admin tools. I use these quite a lot since i am a DB newb.

 

Works most of the time for me.

[karldenton]

Yeah I've got the admin tools and can log on with root and no password. Trying to install Joomla but it doesn't reconise mysql is running

[tom_newton]

GRANT ALL ON mydb TO 'root'@'localhost' IDENTIFIED BY PASSWORD "";

FLUSH PRIVILEGES;

 

should do it if you are able to access mysql from the commandline.

See also: MySQL :: MySQL 5.1 Reference Manual :: 12.5.1.3 GRANT Syntax

 

Suggest however that you *Should* use a root password, and that whatever web app you are using will allow you to specify this in some config file or other.

[karldenton]

Thanks Tom.

Got to going now with no errors on installation - can connect via admintools to database.

Just struggling with Joomla setup now as it says there is no sql !!

[HodgeHi]

what does php info say about the MySQl installation? It may be commented out in the php.ini

[karldenton]

PHPinfo says nothing about mysql - screen below.

 

This is mysql section of php.ini

 

[MySQL]

; Allow or prevent persistent links.

mysql.allow_persistent = On

 

; Maximum number of persistent links. -1 means no limit.

mysql.max_persistent = -1

 

; Maximum number of links (persistent + non-persistent). -1 means no limit.

mysql.max_links = -1

 

; Default port number for mysql_connect(). If unset, mysql_connect() will use

; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the

; compile-time value defined MYSQL_PORT (in that order). Win32 will only look

; at MYSQL_PORT.

mysql.default_port =3306

 

; Default socket name for local MySQL connects. If empty, uses the built-in

; MySQL defaults.

mysql.default_socket =

 

; Default host for mysql_connect() (doesn't apply in safe mode).

mysql.default_host =localhost

 

; Default user for mysql_connect() (doesn't apply in safe mode).

mysql.default_user =root

 

; Default password for mysql_connect() (doesn't apply in safe mode).

; Note that this is generally a *bad* idea to store passwords in this file.

; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")

; and reveal this password! And of course, any users with read access to this

; file will be able to reveal the password as well.

mysql.default_password =********

 

; Maximum time (in seconds) for connect timeout. -1 means no limit

mysql.connect_timeout = 60

 

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and

; SQL-Errors will be displayed.

mysql.trace_mode = Off

[HodgeHi]

In the php.ini there should be an extensions section. In this section there is a long list of all the extensions php can use. most if not all are commented out. MySQL needs to be uncommented by removing the semi colon from the front of the line that reads ;mysql.dll i think it is.

 

I may be barking up the wrong tree entirely though as it has been years since i did this stuff on a Windows box. You may also need to make sure that the extension is indeed there.

[HodgeHi]

I think you may also need to restart the web service after enabling the extension if needed.

[karldenton]

Ok, enabled the extension in php.ini but Joomla still showing NO