How to Install MySQL on Linux

December 19, 2011 2 comments
I will explain how to install MySQL on Linux [Redhat, Fedora] platform.

Type the following command as root user:
# yum install mysql-server mysql

Start MySQL Service:-
To start mysql server type the following command:-
# chkconfig mysqld on
# /etc/init.d/mysqld start

 Setup mysql root password:-
# mysqladmin -u root password yourpass

Connecting to MySQL:-
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7369

Thanls,
Vishal Vyas
Vishal Vyas

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi eu sem ultrices, porttitor mi eu, euismod ante. Maecenas vitae velit dignissim velit rutrum gravida sit amet eget risus. Donec sit amet mollis nisi, nec commodo est.

2 comments:

  1. AnonymousDecember 21, 2011 at 4:08 AM

    which Port to allow in Iptable rules?

    ReplyDelete
  2. Vishal VyasDecember 25, 2011 at 9:41 PM

    Hi,

    MySQL is open source database server and by default it listen on TCP port 3306.

    iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT

    Thanks,
    Vishal

    ReplyDelete

Designed with by Way2themes | Distributed by Blogspot Themes