MySQL Database

  1. Installation and Configuration
    1. System Requirements and Prerequisites
      1. Hardware Requirements
        1. CPU Specifications
          1. Memory Requirements
            1. Storage Considerations
            2. Software Dependencies
              1. Operating System Compatibility
                1. Required Libraries
                  1. Development Tools
                2. Installing MySQL Server
                  1. Windows Installation
                    1. Using MySQL Installer
                      1. Download and Setup Process
                        1. Configuration Wizard
                          1. Service Installation
                          2. Manual Installation Steps
                            1. Binary Package Installation
                              1. Configuration File Setup
                                1. Service Registration
                              2. macOS Installation
                                1. Using Homebrew
                                  1. Installation Commands
                                    1. Service Management
                                      1. Configuration Options
                                      2. Using Native Packages
                                        1. DMG Package Installation
                                          1. System Preferences Integration
                                            1. Startup Configuration
                                          2. Linux Installation
                                            1. Using APT Package Manager
                                              1. Ubuntu/Debian Installation
                                                1. Repository Configuration
                                                  1. Package Updates
                                                  2. Using YUM/DNF Package Manager
                                                    1. CentOS/Red Hat/Fedora Installation
                                                      1. Repository Setup
                                                        1. Service Management
                                                        2. Using Generic Binaries
                                                          1. Binary Download and Extraction
                                                            1. Manual Configuration
                                                              1. User and Group Setup
                                                          2. Initial Server Setup and Security
                                                            1. Running mysql_secure_installation
                                                              1. Script Overview and Purpose
                                                                1. Step-by-Step Walkthrough
                                                                  1. Root Password Configuration
                                                                    1. Anonymous User Removal
                                                                      1. Remote Root Access
                                                                        1. Test Database Removal
                                                                          1. Privilege Table Reload
                                                                        2. Security Hardening
                                                                          1. File System Permissions
                                                                            1. Network Security Configuration
                                                                              1. User Account Management
                                                                            2. MySQL Client Tools
                                                                              1. Command-Line Client (mysql)
                                                                                1. Connection Syntax
                                                                                  1. Host and Port Specification
                                                                                    1. User Authentication
                                                                                      1. Database Selection
                                                                                      2. Basic Command Usage
                                                                                        1. SQL Statement Execution
                                                                                          1. Command History
                                                                                            1. Output Formatting
                                                                                            2. Client Options and Parameters
                                                                                              1. Connection Parameters
                                                                                                1. Output Control Options
                                                                                                  1. Batch Mode Operations
                                                                                                2. MySQL Workbench (GUI)
                                                                                                  1. Installation and Setup
                                                                                                    1. Features and Capabilities
                                                                                                      1. Visual Database Design
                                                                                                        1. SQL Development
                                                                                                          1. Server Administration
                                                                                                          2. Connection Management
                                                                                                            1. Connection Profiles
                                                                                                              1. SSL Configuration
                                                                                                                1. Connection Testing
                                                                                                              2. Third-Party GUI Tools
                                                                                                                1. DBeaver
                                                                                                                  1. Universal Database Tool
                                                                                                                    1. Connection Setup
                                                                                                                      1. Feature Overview
                                                                                                                      2. HeidiSQL
                                                                                                                        1. Windows-Specific Tool
                                                                                                                          1. Interface Overview
                                                                                                                            1. Database Management
                                                                                                                            2. phpMyAdmin
                                                                                                                              1. Web-Based Administration
                                                                                                                                1. Installation and Configuration
                                                                                                                                  1. Security Considerations
                                                                                                                              2. MySQL Configuration
                                                                                                                                1. Configuration File Structure
                                                                                                                                  1. File Locations by Platform
                                                                                                                                    1. Windows Configuration Files
                                                                                                                                      1. Unix/Linux Configuration Files
                                                                                                                                        1. macOS Configuration Files
                                                                                                                                        2. Configuration File Hierarchy
                                                                                                                                          1. Global Configuration
                                                                                                                                            1. User-Specific Configuration
                                                                                                                                              1. Command-Line Overrides
                                                                                                                                            2. Key Configuration Directives
                                                                                                                                              1. Server Configuration
                                                                                                                                                1. datadir
                                                                                                                                                  1. port
                                                                                                                                                    1. socket
                                                                                                                                                      1. bind-address
                                                                                                                                                      2. Performance Configuration
                                                                                                                                                        1. max_connections
                                                                                                                                                          1. innodb_buffer_pool_size
                                                                                                                                                            1. query_cache_size
                                                                                                                                                              1. tmp_table_size
                                                                                                                                                              2. Logging Configuration
                                                                                                                                                                1. log_error
                                                                                                                                                                  1. general_log
                                                                                                                                                                    1. slow_query_log
                                                                                                                                                                      1. log_bin
                                                                                                                                                                    2. Server Variables
                                                                                                                                                                      1. Variable Types
                                                                                                                                                                        1. Dynamic Variables
                                                                                                                                                                          1. Static Variables
                                                                                                                                                                            1. Session vs. Global Variables
                                                                                                                                                                            2. Viewing Variables
                                                                                                                                                                              1. SHOW VARIABLES Command
                                                                                                                                                                                1. Information Schema Queries
                                                                                                                                                                                2. Modifying Variables
                                                                                                                                                                                  1. SET Command Usage
                                                                                                                                                                                    1. Configuration File Changes
                                                                                                                                                                                      1. Runtime Modifications

                                                                                                                                                                                Previous

                                                                                                                                                                                1. Introduction to Databases and MySQL

                                                                                                                                                                                Go to top

                                                                                                                                                                                Next

                                                                                                                                                                                3. MySQL Architecture