Tuesday, September 23, 2014

How to install & configure MySql 5.1 on Centos 6.5 64 bit

How to install & configure MySql 5.1 on Centos 6.5 64 bit

Login as root

yum update -y
yum install -y mysql mysql-server

Add for auto-restart
chkconfig mysqld on

Start MySql Server
service mysqld start

For secure run this script
mysql_secure_installation
add root password, remove test database and anonymous user

Add port on iptables
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
service iptables save
service iptables restart

mysql -uroot -pyourpassword
you will be in mysql prompt to quit type exit.

 

No comments:

Post a Comment