Running MySQL Database Server on Linux Systems

Provides introductions and tutorial examples about MySQL database server on CentOS systems. Topics include installing MySQL 8.0 on CentOS 8; starting and stoping 'mysqld' as a system service; setting MySQL 'root' password; MySQL file and data locations; MySQL log files; backing up MySQL data; MySQL socket and TCP/IP connections; Open firewall for MySQL connections.

Install MySQL Database Server on CentOS

Manage MySQL Server 'mysqld' on CentOS

Set MySQL Server "root" Password on CentOS

MySQL Server File Locations on CentOS

MySQL Server Data Backups on CentOS

MySQL Server Log Files on CentOS

MySQL Server Socket Connection on CentOS

MySQL Server TCP/IP Connection on CentOS

Open Firewall for MySQL Server on CentOS

"Server sent charset unknown to the client" Error

Performance of Inserting Integers to MySQL Database

Performance Comparison of Inserting Integers vs. Strings

Takeaways:

Table of Contents

 About This Book

 Introduction to Linux Systems

 Cockpit - Web Portal for Administrator

 Process Management

 Files and Directories

 Users and Groups

 File Systems

 Installing CentOS

 SELinux - Security-Enhanced Linux

 Network Connection on CentOS

 Software Package Manager on CentOS - DNF and YUM

 Running Apache Web Server (httpd) on Linux Systems

 Running PHP Scripts on Linux Systems

Running MySQL Database Server on Linux Systems

 Running Python Scripts on Linux Systems

 vsftpd - Very Secure FTP Daemon

 Postfix - Mail Transport Agent (MTA)

 Dovecot - IMAP and POP3 Server

 Email Client Tools - Mail User Agents (MUA)

 GCC - C/C++ Compiler

 Conda - Environment and Package Manager

 Tools and Utilities

 References

 Full Version in PDF/EPUB