I am trying to install wordpress on my pc at home.
I am running iis 7.5 on a windows 7 pro 64-bit machine.
I've installed php 5.3.19 and the latest MySQL community server.
I have setup a website in IIS called wordpress.tiffs.first which is working as I have added it to the hosts file. Internal ip address being 192.168.1.100.
In my sql workbench I can connect to the database. I added a schema called wordpress as per instructions here and am using the root user with a password.
Workbench will open a connection when hostname: 127.0.0.1 port: 3306, username root, and with or without wordpress as the default schema.
Now I'm not sure what to enter for my information into the wordpress setup screen.
What is the DB name? Is this the same as schema name? or is it something else.
DB User I have set as root
DB password as root's password
database host has confused me. While I am all on this pc i could use localhost. or 127.0.0.1 does this need to have the :3306 for the port added? It fails either way.
I assume that the table prefix option is irrelevant for the database connectivity issue.
I'm worried about using localhost as I intend to work on the site over my network, via a client. I have added wordpress.tiffs.first to both the servers and clients hosts file. I did notice that there is no 127.0.0.1 localhost defined in there it says this is handled by dns now but I did define it to give it a try.
When I try to connect in mysql workbench if I use 192.168.1.100:3306 it fails to connect.
Any advice would be good I'm really rather confused.