Neil Tompkins MySQL 5.6.13 on our Windows 2003 local access only
Aug 30, 2013; 18:06
Neil Tompkins
MySQL 5.6.13 on our Windows 2003 local access only
I have installed MySQL 5.6.13 on our Windows 2003 server and need to configure the service so that no external access is possible from a remote IP addresses.
On the server it's self, the MySQL service will need to be accessed by IIS hosting a ASP.NET application and web services.
I know that this can be set at user level using GRANT to USER @localhost etc, but because in general I don't want external access I'd prefer it be set at server level and just prevent network access.
Currently I've configured the My.ini file as follows;
[mysqld] # The next three options are mutually exclusive to SERVER_PORT below. skip-networking enable-named-pipe # The Pipe the MySQL Server will use# socket=mysql
bind-address = localhost # The TCP/IP Port the MySQL Server will listen on# port=3306
I've tried to connect to the MySQL server through MySQL Workbench, using Local Socket/Pipe but it doesn't work. I set the Local Socket/Pipe to MySQL.
The error I get is "Invalid for this platform protocol requested (MYSQL_PROTOCOL_SOCKET)" . Can anyone help ?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!