yum install MySQL - Remote Access

This post explains all the steps needed to install Mysql on Linux(RedHat, CentOS, Fedora) and configure it to access db from remote machines.

Install Mysql Client

$ yum install mysql

Install Mysql Server

$ yum install mysql-server

Upgrade Mysql Installation

$ mysql_upgrade

Login as root user

$ mysql -u root
mysql>

List the grants this user has

mysql> SHOW GRANTS;

Grant all privileges to login as root from any remote machine

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION