How to install mysql server in RedHat and CentOS

by

In this post we will learn about,how to install mysql server in RedHat and CentOS. MySQL is a relational database management system (RDBMS), and ships with no GUI tools to administer MySQL databases or manage data contained within the databases.
Read More About MySQL Server

By-Default Port no. of MySQL : 3306 (It is a TCP based protocol)

In Red Hat or CentOS install the MySQL Server by following command

yum install -y mysql-server

To start/stop/restart the mysql-server

To Start the MySQL server : /etc/init.d/mysqld start

To Stop the MySQL Server : /etc/init.d/mysqld stop

To Restart the MySQL Server : /etc/init.d/mysqld restart

To Check the status of MySQL Server : /etc/init.d/mysqld status

How To Check on which port no. the mysql is running

# netstat -tanp|grep mysqld
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 17925/mysqld

The output of netstat command shows the MySQL server is running at port no. 3306 in localhost IP Address(127.0.0.1) ,it is Listening and have the PID no. 17925 with program name mysqld

Related posts:

  1. Find mysql commands history without mysql server login
  2. How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
  3. How to Install awstat in Redhat and CentOS
  4. Install MySQL Server 5.6 in CentOS 6.x and Red Hat 6.x Linux
  5. How to change hostname or FQDN in CentOS and Redhat
  6. How to check default storage engine in MySQL server
  7. Set delay replication to MySQL slave server
  8. How to install mysql server 5.6 on Ubuntu 14.04 LTS ( Trusty Tahr )
  9. How to install MySQL Server 5.7 on Ubuntu 14.04 LTS
  10. How to reset forgot root password in CentOS 6.x and Redhat 6.x

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.