Home  >  Article  >  Operation and Maintenance  >  One article explains how to install MySQL with yum on Linux/UNIX

One article explains how to install MySQL with yum on Linux/UNIX

藏色散人
藏色散人forward
2021-09-25 17:08:461903browse

The following column linux system tutorial will introduce to you how to install MySQL on yum on Linux/UNIX. I hope it will be helpful to friends in need!

Install MySQL on yum on Linux/UNIX

It is recommended to use RPM package for installation on Linux platform Mysql, MySQL AB provides the download address of the following RPM package:

  • MySQL-MySQL server. You need this option unless you only want to connect to a MySQL server running on another machine.
  • MySQL-client- MySQL client program, used to connect to and operate the Mysql server.
  • MySQL-devel- Libraries and include files, if you want to compile other MySQL clients, such as Perl modules, you need to install this RPM package.
  • MySQL-shared- This package contains shared libraries (libmysqlclient.so*) that some languages ​​and applications need to dynamically load using MySQL.
  • MySQL-bench - Benchmark and performance testing tool for MySQL database servers.

Before installation, we can check whether the system comes with MySQL installed:

rpm -qa | grep mysql

If your system has it installed, you can choose to uninstall it:

rpm -e mysql  // 普通删除模式 
rpm -e --nodeps mysql  // 强力删除模式,如果使用上面命令删除时,提示有依赖的其它文件,则用该命令可以对其进行强力删除

Install the official Version

Next we use the yum command to install MySQL under the Centos7 system. It should be noted that the MySQL database has been removed from the default program list in the CentOS 7 version, so we need to download it from the official website before installation. Yum resource package, the download address is: https://dev.mysql.com/downloads/repo/yum/

Note: We need to enable administrator rights to install during the installation process. Otherwise, the installation will fail due to insufficient permissions.
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
yum install mysql-server

Permission settings:

chown mysql:mysql -R /var/lib/mysql

Initialize MySQL:

mysqld --initialize

Start MySQL:

systemctl start mysqld

View MySQL running status:

systemctl status mysqld

Note: If we start the mysql service for the first time, the mysql server will first perform initial configuration.

Install the community version

In addition, you can also use MariaDB instead. The MariaDB database management system is a branch of MySQL, which is mainly maintained by the open source community and is licensed under the GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there was a potential risk of MySQL being closed source, so the community adopted a branch approach to avoid this risk.

MariaDB aims to be fully compatible with MySQL, including API and command line, making it an easy replacement for MySQL.
yum install mariadb\-server mariadb

The relevant commands for the mariadb database are:

systemctl start mariadb #启动MariaDB 
systemctl stop mariadb #停止MariaDB 
systemctl restart mariadb #重启MariaDB 
systemctl enable mariadb #设置开机启动

Verify MySQL installation

After successfully installing MySQL, some basic tables will be initialized. After the server starts, you can Verify that MySQL is working properly with a simple test.

Use the mysqladmin tool to get the server status:

Use the mysqladmin command to check the server version. On Linux, the binary file is located in the /usr/bin directory. On Windows, the binary file is located in C :\mysql\bin .

[root@host]# mysqladmin --version

This command on Linux will output the following results, which are based on your system information:

mysqladmin Ver  8.23  Distrib  5.0.9-0,  for redhat-linux-gnu on i386

If no information is output after the above command is executed, it means that your Mysql was not installed successfully.

After Mysql is installed successfully, the default root user password is empty. You can use the following command to create the root user's password:

[root@host]# mysqladmin -u root password "new_password";

Now you can connect to the Mysql server through the following command:

[root@host]# mysql -u root -p *******

Note: When entering the password, the password will not be displayed. Just enter it correctly.

Recommended study: "linux video tutorial"

The above is the detailed content of One article explains how to install MySQL with yum on Linux/UNIX. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:segmentfault.com. If there is any infringement, please contact admin@php.cn delete