- Setup Type: the default is Typical, which will be sufficient for our purposes.
- Several other panels follows which you can go through, and then
See Wizard Completed with these options, then
Configure the MySQL server now
Configure now. You can reconfigure it through a program menu item later as well.
Register the MySQL Server now
Uncheck it now. If you want, you can do it later.
- Select Configuration Type: take the default, Detailed Configuration. It's a good idea just to see the choices that you're making even if you take the defaults.
- Server Type: probably the default, Developer Machine.
- Database Usage: probably the default, Multifunctional Database.
- InnoDB Tablespace Settings: Take the defaults.
- Concurrent Connections Settings: Take the default, Decision Support (DSS/OLAP)
- Networking Options: Keep the defaults, Enable TCP/IP Networking and Enable Strict Mode.
- Default Character Set: probably the default, Standard Character Set.
- Windows options:
You want both, so check the second checkbox.
Install As Windows Service Include Bin Directory in Windows PATH
- Security Options:
Uncheck this checkbox to maintain
the initial empty root password.
Modify Security Settings
- Ready To Execute: Go for it! Press the Execute button. If the "Start Service" fails, go back to the Windows Options panel and select a different name for the Windows service. If the Apply security settings fails, it may be that you already have a password.
\Program Files\Mysql\MySQL Server 5.6The actual databases reside in a subfolder named data, typically in an "Application Data" folder:
\Documents and Settings\All Users\Application Data\MySQL Server 5.6\dataThe Windows Programs menu contains the item:
MySQL command-line client: (accessses the command-line mysql as administrative)After the installation MySQL will probably start up automatically as a background service. Perhaps the easiest way to get to Services is to key this word into the Search Box of the Run menu. Look for MySQL in the list of services, the startup type should be "automatic" and it should be "started" after installation.
Command line management of MySQLThe binaries in the bin subfolder of the installation folder. Hopefully MySQL has already installed this folder in your PATH environment variable. If not, add it through the system Environment Variables. Use the Search Box or
Control Panel → System → Advanced → Environment Variables
Instead, install the mysql client package in Cygwin, but don't install the mysql server package. Then you will be able to access the Windows MySQL database with an added option like this:
$ mysql --protocol TCP ...To simplify this usage, create an alias by adding this line to your ~/.bashrc file:
alias mysql='mysql --protocol TCP'Open a new Cygwin shell and my can now use the mysql client as you would on a Windows command shell, e.g.:
$ mysql -u root