2.6.1. MySQL

2.6.1.1. Databases
- 2.6.1.1.1. Create database
- 2.6.1.1.2. Create database user
- 2.6.1.1.3. Data for connection to database
- 2.6.1.1.4. Change database user password
- 2.6.1.1.5. Restrict access to MySQL
- 2.6.1.1.6. Import database to hosting account
- 2.6.1.1.7. Export database from hosting account
- 2.6.1.1.8. Optimize database tables
- 2.6.1.1.9. Clear database
- 2.6.1.1.10. Delete database user
- 2.6.1.1.11. Delete database
- 2.6.1.1.12. Change database user privileges
- 2.6.1.1.13. Disable two-step authentication in phpMyAdmin
- 2.6.1.1.14. Force terminate all database queries
- 2.6.1.1.15. List of active MySQL processes
2.6.1.2. MySQL clients
- 2.6.1.2.1. phpMyAdmin
- 2.6.1.2.2. HeidiSQL (Windows)
- 2.6.1.2.3. Sequel Pro (macOS)
- 2.6.1.2.4. DBeaver
- 2.6.1.2.5. DataGrip
- 2.6.1.2.6. MySQL Workbench
2.6.1.3. Issues when working with databases
- 2.6.1.3.1. Incorrect encoding when retrieving data from database
- 2.6.1.3.2. Error 1153 Got a packet bigger than 'max_allowed_packet' bytes
- 2.6.1.3.3. Database connection error
- 2.6.1.3.4. Error max_user_connections
- 2.6.1.3.5. Large database size
- 2.6.1.3.6. When IP access restriction is enabled, access to Views is lost
2.6.1.4. Connect site to database
2.6.1.5. Import database
2.6.1.6. Export database
2.6.1.7. Temporary access to specific database
2.6.1.8. Slow queries
2.6.1.9. Database optimization
2.6.1.10. Database query optimization
2.6.1.11. MySQL server configuration
2.6.1.12. MySQL server load
2.6.1.13. Storage types and their change
2.6.1.14. Change MySQL version
2.6.1.15. What is INFORMATION_SCHEMA
2.6.1.16. Create database copy
2.6.1.17. Change database charset
2.6.1.18. MySQL limitations
2.6.1.19. MySQL settings
2.6.1.20. MySQL query log (General Query Log)
2.6.1.21. MySQL performance log (Performance Schema)
2.6.1.22. Why database size varies from place to place