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
mysql-community-release-fc20-5.noarch
|
The fc20-5
changes with point releases, but assuming
that you’re installing the fc20-5
release:
shell> sudo yum localinstall mysql-community-release-fc20-5.noarch
|
- 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:
shell> mysql_secure_installation
|
- Set the MySQL Service to start with the Fedora operating system with the following
command (not
chkconfig
):
shell> sudo systemctl enable 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:
#socket=/var/lib/mysql/mysql.sock
|
Add the bind-address
and port
lines
below after you know the actual IP address of the server to the
my.cnf
file in the /etc
directory.
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.
bind-address=nnn.nnn.nnn.nnn
port=3306
|
- 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
|