How to Install MySql on CentOS server

MySQL is a widely used open-source relational database management system (RDBMS) that is designed to handle large amounts of data. MySQL is known for its reliability, ease of use, and performance, making it a popular choice for web applications, data warehousing, and other data-intensive tasks.

MySQL is based on a client-server architecture, with the MySQL server managing the data storage and retrieval, and the MySQL client connecting to the server to perform database operations. MySQL uses SQL (Structured Query Language) to create, read, update, and delete data in a database.

One of the key features of MySQL is its scalability. It can handle large amounts of data and can be easily scaled to meet the needs of growing applications. Additionally, MySQL offers a variety of tools for optimizing performance, such as the InnoDB storage engine, which provides support for transactions and row-level locking.

Another benefit of MySQL is its flexibility. It can be used with a wide range of programming languages, such as PHP, Java, C++, and Python, making it a great option for developers who work with multiple languages.

MySQL also provides a variety of security features such as password encryption, access control, and SSL support to ensure that data stored in the database is secure.

One limitation of MySQL is that it is not as feature-rich as some other RDBMS, such as PostgreSQL or Oracle. Additionally, MySQL’s licensing model can be restrictive for some users, as it is not fully open-source.

Overall, MySQL is a powerful, reliable, and widely used RDBMS that is well-suited for data-intensive applications. Its scalability, flexibility, and security features make it a great option for developers and businesses of all sizes. However, it may not be the best choice for users who need a more feature-rich RDBMS or who prefer a fully open-source licensing model.

How to install MySql on CentOS server

Please check whether MySql packages are available under yum.

yum list mysql*

If yes, then install mysql using below command.

yum install mysql*

Now install the Mysql database on the server using below command.

mysql_install_db

It will create mysql database on mysql server.  Now, we have to reset the password for the Mysql server root user. Please use below command.

/usr/bin/mysqladmin -u root password ‘new-password’

Replace the ‘new-password’ with the password you would like to set.

Now, create my.cnf under root home directory using below command.

vi /root/.my.cnf

Now, insert the below lines in .my.cnf file

[client]

user=”root”

password=”new-password”

Please replace the “new-password” with the password you have used above while setting up  with the mysqladmin command.

Your Mysql server is now installed and configured on your machine. You can check the same using below command.

mysql

Try start Mysql service using the below command:

service mysql start