Getting My SQL to install

[alan388364]

I understand that I have to have My SQL installed to view PHP pages on my machine. I have followed the instructions in WEB DEV Before you begin, but when I go to MySQL Administrator I cannot log in as it asks for my Stored connection and Server host. What are these and what should I put in please.

[neilo]

Hi,

Assuming that you have followed the default install, those settings are likely to be:

Stored Connection: localhost
Server Host: localhost
Username: root
Password: (leave blank)

You may have to enable access to port 3306 (probably) in your firewall software.

[alan388364]

Hi,

Assuming that you have followed the default install, those settings are likely to be:

Stored Connection: localhost
Server Host: localhost
Username: root
Password: (leave blank)

You may have to enable access to port 3306 (probably) in your firewall software.

Thanks, I tried that but I get an error message saying
MySQL error number 1045
Access denied for root@localhost [using password NO]

I also tried after resetting the firewall, again after switching it off, again with different passwords but no luck.

Any ideas welcome.

[alan388364]

eventually got it working after uninstalling MySQL plus deleting all files then re-installing and selecting add port to firewall exclusions in settings then using settings as described but put in username I set up when configering and it worked.

[neilo]

Nice one, - glad to hear you got going!