Hi ,
With the demise of Libmysqld.dll I needed a local SQL server that was small and let me run multiple instances (in different dirs).
So here is all you need to run MariaDB/MySQL using named pipes instead of TCP.
Download mariadb or mysql ZIP file.
START COMMAND PROMPT AS ADMIN
Create a directory for your app.. say c:\MyApp
In that directory create 2 Sub Directories:
c:\myapp\bin
c:\myapp\data
In the BIN dir put the following:
\bin\mysql_install_db.exe
\bin\mysqld.exe
\bin\server.dll
In that same dir create the file called my.ini
with some basic entries..
[client-server]
socket=MyPipeName
[mysqld]
basedir=c:\MyApp\
datadir=C:\MyApp\data
skip-networking=1
named-pipe=1
From the BIN directory run (as admin)
mysql_install_db
This will create everything you need the the data dir
You can now delete mysql_install_db.exe
COPY the MY.INI to the DATA DIR !!! (overwrite the one that has been created)
Install as a service:
change to your myapp\bin\
run mysqld -- install MyServiceNme
Run the service:
SC start MyServiceName
you can now connect to the server using named pipes... use what ever you put in MyPipeName as the socket in the connection string, localhost as the server and root as the user with NO PASSWORD
Works for me.... only tested on windows 10 with binares from latest MariaDB....
Let me know if it works for you all!
With the demise of Libmysqld.dll I needed a local SQL server that was small and let me run multiple instances (in different dirs).
So here is all you need to run MariaDB/MySQL using named pipes instead of TCP.
Download mariadb or mysql ZIP file.
START COMMAND PROMPT AS ADMIN
Create a directory for your app.. say c:\MyApp
In that directory create 2 Sub Directories:
c:\myapp\bin
c:\myapp\data
In the BIN dir put the following:
\bin\mysql_install_db.exe
\bin\mysqld.exe
\bin\server.dll
In that same dir create the file called my.ini
with some basic entries..
[client-server]
socket=MyPipeName
[mysqld]
basedir=c:\MyApp\
datadir=C:\MyApp\data
skip-networking=1
named-pipe=1
From the BIN directory run (as admin)
mysql_install_db
This will create everything you need the the data dir
You can now delete mysql_install_db.exe
COPY the MY.INI to the DATA DIR !!! (overwrite the one that has been created)
Install as a service:
change to your myapp\bin\
run mysqld -- install MyServiceNme
Run the service:
SC start MyServiceName
you can now connect to the server using named pipes... use what ever you put in MyPipeName as the socket in the connection string, localhost as the server and root as the user with NO PASSWORD
Works for me.... only tested on windows 10 with binares from latest MariaDB....
Let me know if it works for you all!