Linux Apps Tutorials - Herong's Tutorial Examples
∟Running MySQL Database Server on Linux Systems
This chapter 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:
- MySQL server can be installed with the "dnf install mysql-server" command
on CentOS 8 systems.
- MySQL server can be started and stopped with "service mysqld start/stop" commands.
- MySQL server starts with no password for "root".
You can set one with "mysqladmin -u root -p password new_password" command.
- MySQL command programs are located in "/usr/bin" directory.
- MySQL data and log files are located in "/var/lib/mysql" directory.
- MySQL data can be backed up with the "mysqldump" command.
- MySQL can log all queries with the "eneral_log" setting.
- MySQL supports socket connections for client programs on the server host
using "localhost" as the host name.
- MySQL supports TCP/IP connections for remote clients on port 3306.
- MySQL allows a remote user to access only if the user is created with
his/her IP address specified.
- MySQL requires the server and gateway to open firewall for inbound TCP
messages on port 3306.
- "Server sent charset unknown to the client" error is returned
when using older PHP mysqli_connect() function to connect to MySQL 8.0.
- MySQL server is 100 times slower on my CentOS computer than my macOS computer
with default settings.
Table of Contents
About This Book
Introduction to Linux Systems
Process Management
Files and Directories
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
Conda - Environment and Package Manager
GCC - C/C++ Compiler
Graphics Environments on Linux
SquirrelMail - Webmail in PHP
Tools and Utilities
References
Full Version in PDF/EPUB