I built a new image on VMWare Fusion for my class, which required installing MySQL 5.6 on Fedora, Version 20. If you don’t know how to add your user to the
sudoers list, you should check this older and recently updated blog post.
- Download the MySQL Yum Repository and launch the downloaded RPM.
- Install MySQL on Fedora, Version 20, which you can find with the following command:
shell> rpm -qa | grep mysql
fc20-5 changes with point releases, but assuming that you’re installing the
shell> sudo yum localinstall mysql-community-release-fc20-5.noarch.rpm
- Install MySQL on Fedora with the following command:
shell> sudo yum install mysql-server
- Start the MySQL service on Fedora with the following command:
shell> sudo service mysqld start
- Secure the MySQL installation with the following command:
- Set the MySQL Service to start with the Fedora operating system with the following command (not
shell> sudo systemctl enable mysqld.service
It sets the following two links:
ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/mysql.service'
ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'
Restart the Fedora operating system to effect the changes.
- Reset the MySQL configuration file to enable external connections through Port 3306 with the following changes to the my:
Remark out the
socket line, like this:
port lines below after you know the actual IP address of the server to the
my.cnf file in the
You substitute the actual IP address for the
nnn.nnn.nnn.nnn on the
bind_address line with the actual IP address returned by the
ifconfig command, like this:
Then, add these two lines to the my.cnf file.
It’s actually easier to use localhost.localdomain than an IP address when you use DHCP, like:
If you plan to connect from a host system, like Windows or Mac OS X, to a virtual Linux environment using DHCP, change
- Restart the mysqld service with the following syntax:
shell> sudo service mysqld restart
You can check whether MySQL is listening on Port 3306 with this syntax:
shell> sudo netstat –anp | grep 3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 1311/mysqld
Go to this page if you want to install MySQL Workbench.