How to install MySQL server on CentOS/RHEL/Oracle server step by step guide


In this tutorial we learn what is MySQL and how to install MySQL on centos/rhel/Oracle  linux server.

What is MySQL database?

MySQL is free and open source most popular relational database management system all over the world. It is used for various web based software application.

Installation steps of MySQL on linux server

To install MySQL server on the linux machine we need to install mysql server  rpm package in the system.

There are two packages one is mysql server which is used to manages database, table, control user rights  and other is mysql client which is used to control mysql server.

To install mysql server and client we need to execute the below command.
[root@localhost ~]# yum install mysql-server mysql –y

Start and enable the MySQL server on linux

After installing the mysql server package we need to start the mysql service and enable the service at the startup mode using the below command.
[root@localhost ~]#service mysqld start
[root@localhost ~]#chkconfig mysqld on

After check the status of the service using the below command.

[root@localhost ~]#service mysqld status

By default mysql service is running on 3306 port. To check this port is listening or not using the below command.

[root@localhost ~]#netstat –tulpn | grep 3306
How to install MySQL on CentOS/RHEL/Oracle server step by step guide
How to install MySQL on CentOS/RHEL/Oracle server step by step guide

That’s all. If this article is helpful please share it!!!!



SHARE

Admin

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment