- Download the latest stable (recommended, generally available) release of MySQL
- Extract with an unzip tool such as WinZip
- Run the MySQL install program (setup.exe) and then either:
- Choose Custom Setup
- Change the installation directory to C:\MySQL5 and the data directory to c:\MySQL5\data\. We recommend installing into a directory without spaces, e.g., c:\MySQL5* or *c:\MySQL5\data. The default directory usually includes spaces, which seems to cause problems with MySQL.
- Accept the license agreement
- Accept to Configure Instance
- Select "Detailed Configuration"
- Select "Developer Machine"
- Select "Multifunctional Database"
- InnoDB Tablespace Settings, Use the default (c: and Installation Path).
- Select "DSS/OLAP"
- Enable TCP/IP Networking (Port 3306), check "Add firewall exception..." and leave "Enable Strict Mode" checked.
- Default Character Set, select "Best support for Multilingualism" (utf8)
- Check "Installed as Windows Service" and leave "Launch the MySQL Server automatically" checked.
- Root password (password) (Note: Do NOT forget this root password for MySQL! You will need it later.)
- Execute the configuration. The installer should step through the process and give you green check marks at each stage
- If you run into problems, check the Installation Troubleshooting page or the Troubleshooting MySQL page
- Enable the MySQL port in Windows Firewall
- Open Windows Firewall (Start ? Settings ? Control Panel ? Windows Firewall)
- Under the "Exceptions" tab, click the "Add Port" button
- Name: MySQL
- Port number: 3306
- Optional: For added security, click the "Change scope" button and limit to "My network (subnet) only". This will prevent computers outside of your local area network from being able to access your database directly.
Other Operating Systems
- Install the MySQL server package: sudo apt-get install mysql-server
- Enter a root password