8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Home » Articles » Mysql » Here
Oracle MySQL Articles
Database Administration
MySQL : Installation on Linux - A description of the basic steps necessary to install MySQL on Linux.
MySQL : Useful Startup Options - This article lists a few of the startup options that will probably jump out at you during the early days of learning MySQL.
MySQL : Backup and Recovery - A quick guide to performing basic backup and recovery of MySQL databases.
MySQL : Example Backup Schedule - This article contains an example of how you might go about setting up a backup schedule for MySQL.
MySQL : Users and Permissions - Learn how to create new users and grant permissions to those user in MySQL.
MySQL : Configure SSL Connections - This article describes how to enable SSL connections to MySQL.
MySQL : Password-less Logins Using Option Files - Learn how to configure password-less logins to MySQL using option files.
MySQL : Converting Table Character Sets From latin1 to utf8 - Safely convert the character set of a table from latin1 to utf8.
MySQL : OPTIMIZE TABLE, ANALYZE TABLE, CHECK TABLE and REPAIR TABLE Commands - This article describes some common table maintenance operations in MySQL.
MySQL : Killing Threads (PROCESSLIST, KILL) - This article describes how to kill threads (or sessions) in MySQL Databases.
MySQL : Identify Locked Tables - Identify locked tables in MySQL using the SHOW OPEN TABLES command.
MySQL : Managing Log Files - A brief description of how to manage MySQL log files.
MySQL : Upgrade MySQL 5.6 to 5.7 - This article gives an overview of the steps needed to perform an in-place upgrade of MySQL 5.6 to 5.7.
Development
MySQL : How TRUNCATE TABLE affects AUTO_INCREMENT - Learn how the TRUNCATE TABLE command affects AUTO_INCREMENT columns in MySQL and what you can do about it.
MySQL : Running Batch Scripts - This article describes how to run batch scripts against a MySQL database.
MySQL : Connections in SQL Developer - Use SQL Developer to connect to MySQL databases.
Cloud
Amazon Web Services (AWS) : Relational Database Services (RDS) for MySQL - This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for MySQL.
Oracle Cloud : MySQL Cloud Service - Create Service - The Oracle MySQL Cloud Service allows you to quickly deploy MySQL databases on the Oracle Public Cloud.
Miscellaneous
Install phpMyAdmin On Linux - Learn how to install phpMyAdmin on Linux servers.
External Articles
MySQL Documentation: MySQL Reference Manuals - The main documentation site for MySQL.