MySQL Basics-Installation, management

Mysqlinstallation

MySQL for all platforms is https://dev.mysql.com/downloads/mysql/. Pick the version of MySQL Community Server you need and the corresponding platform.

Install MySQL on Linux/unix

The following RPM packages are recommended for installing Mysql,mysql AB on Linux platforms using the RPM package:

• MySQL -MySQL server. You need this option unless you only want to connect to a MySQL server that is running on another machine.
• mysql-client -MySQL client program for connecting and operating 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 the RPM package.
• mysql-shared -The package contains some languages and applications that require dynamic loading of shared libraries (libmysqlclient.so*), using MySQL.
• mysql-bench -Baseline and performance testing tools for MySQL database servers.

Before installing, we can detect whether the system comes with MySQL installed:

- | grep MySQL

If you have a system installed, you can choose to uninstall:

RPM-E MySQL //  Normal Delete mode rpm-e--nodeps mysql //  Brute Force Delete mode, if you use the above command to delete, prompted to have other dependent files, then use this command can be Brute Force removal

Install MySQL:

Next we install MySQL under the CENTOS7 system using the Yum command, it is important to note that the CentOS 7 version of the MySQL database has been removed from the default program list, so before installing we need to go to the official website to download the Yum Resource pack: Https://dev.mysql . com/downloads/repo/yum/

MySQL Basics-Installation, management