am3n portfolio

My friend asked me how to get MySQL running as Windows standalone application. So he can execute the mysql start-up command by putting it inside his application. So every time his application run, it also start up mysql daemon. He doesn’t want MySQL running as service every time Windows starts as someone can access the data from outside his program. So after couple of times trying, here it is.

Note:

• I am using 3.23.58 version because it’s the simplest mysql binaries for Windows. But for enhanced feature and security, I think it can be done on newest mysql version.
• I assume you save the zip file on drive C:\> and extract it there.

So here MySQL 3.23.58 Windows binary no install (trimmed version because this is all I need). And below is how to use it:

MySQL Windows version
---------------------

c:\>cd server\bin

- To start as standalone program
c:\server\bin>mysqld-nt.exe --standalone

- To shutdown
c:\server\bin>mysqladmin -u root [-pXXX] shutdown

- To change password
c:\server\bin>mysqladmin -u root password [oldpass] newpass

Related posts:

1. Install SSH (SFTP) server on Windows 2000 Below is step-by-step installation SSH (and SFTP) server on Windows...
2. MySQL partition is full MySQL databases are located on /var/lib/mysql, if you create a...

Related posts brought to you by Yet Another Related Posts Plugin.

This entry was posted on Saturday, May 3rd, 2008 at 7:18 pm and is filed under Web and System Administrator. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.