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 some version of MySQL Community Server from Oracle. Here is a direct link (2019-05-14) 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. MeOS does not make use of any new features in MySQL 8.0, so choose the version that works best with your computer.
Instructions for MySQL 5.7 and earlier
- 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.
Instructions för MySQL 8.0
- Download MySQL Community Server version 8.0. You will be asked to create an account, but you may skip this step, just click “No thanks”.
- Choose the web installer.
- Select to install Server only, standalone MySQL server.
Note
Select Legacy Authentication Method in the setup. - Enter a root account password, and add a user (user name and password) for use with MeOS. The default settings will work.
- MySQL configures the firewall rules automatically. Remember to configure the network as private (home/office) in Windows otherwise it will not work with other computers.
To post a comment, you need to log in.