Note: Text covers an earlier version. |
Installing MySQL
Installing MySQL is not much more difficult than installing any other program. You download and run an installer. You can use the default options in most cases. (An exception is the security settings, see below)- Download the latest version of MySQL Community Server from Oracle. Here is a direct link (2014-03-22) http://dev.mysql.com/downloads/mysql/ to the download page. When you have selected a version you are encouraged to create an Oracle account, but that is not necessary, at the bottom of the page, there is a link that enables download without an account.
- Run the installer. Accept the license agreement and choose Typical installation. MySQL is now installed. After clicking through some information pages, you get an option to configure MySQL now (Launch the MySQL Instance Configuration Wizard). Do that.
- Configuring MySQL. You can use Standard Configuration. Then choose Install as Windows Service and Launch Automatically.
- If you prefer a details installation we recommend Developer Machine (unless you plan for more than 20000 competitors) and Non-Transactional Database Only. You can specify how many MeOS-clients you wish to connect (Number of Concurrent Connections). Activate TCP/IP and choose a port (the default is warmly recommended).
- Now you see the page Security options. Choose Modify Security Settings and type a password for the root account. If you only are using MySQL for MeOS you can use the root account and skip creating a special account for MeOS. Then check Enable root access from remote machines. In MeOS you specify the user name root and your password.
- Turn off or configure internal network firewalls.
- Try to connect MeOS to the server. Try first the server computer. You can then specify localhost in the field MySQL server. On other computers you need to specify the server name on the network or its IP address (IPv4), which you can find out by clicking Show status for the connection in Windows network and sharing center.
To post a comment, you need to log in.