Shulou(Shulou.com)06/01 Report--

Introduction to MySQL installation, configuration and Management of Linux platform _ MySQL Database Foundation and Project practice 03

Video tutorial learning address

Http://edu.51cto.com/course/12294.html

Oracle/MySQL database learning special QQ group: 336282998, 189070296

After learning Brother Feng, you can be familiar with the following contents:

I. course content

1. Introduction of MySQL project scenario based on Linux platform.

2. MySQL database runtime environment preparation-optimal configuration

2.1) how to check the official documentation to understand the environmental requirements

2.2) install the virtual machine environment and operating system

2.3) 9 steps for optimal configuration of operating system

2.4) preparation of operating system YUM environment

2.5) the most standardized configuration of disks and partitions required for MySQL

3. How to download MySQL database

4. Install MySQL by binary file under Linux platform

4.1) pre-installation configuration

4.2) preparation of mysql parameter files-according to production environment standards

4.3) mysql database initialization-according to production environment standard

4. 4) mysql boot auto startup configuration

4.5) important configuration and password issues in the later stage of mysql

4.6) mysql start and stop log analysis

4.7) mysql remote connection and testing

5. Install MySQL through source code on Linux platform

5.1) pre-installation configuration and required software package check

5.2) prepare the source code editing tool

5.3) preparation of mysql parameter files-according to production environment standards

Mysql database initialization-per production environment standard

5.5) mysql boot auto startup configuration

Important configuration and password problems in the later stage of mysql

5.7) mysql start and stop log analysis

5.8) mysql remote connection and testing

6. Install MySQL through YUM on Linux platform

6.1) Environmental preparation

6.2) download yum repository

6.3) install mysql

6.4) Post-configuration and testing

7. Install MySQL through RPM on Linux platform

7.1) Environmental preparation

Download the rpm software package

7.3) install mysql

7.4) later configuration and testing

8. Configuration and running parameter settings of MySQL after installation

9. Test and remote connection after MySQL installation

10. MySQL basic management commands

11. How to uninstall MySQL version on Linux platform

11.1) Uninstall the binary installation mode

11.2) Uninstall the source code installation method

11.3) Uninstall the YUM installation mode

11.4) Uninstall the RPM installation mode

II. Special topic recommendation

Video tutorial on MySQL High availability replication and distributed Cluster Architecture (Special Series)

Http://edu.51cto.com/topic/1622.html

This series of courses, the only one in the network, is the mainstream architecture of Internet MySQL at present, involving multiple servers, nearly 100 databases, and project experiments with tens of millions of data.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.