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.