Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

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 : Managing Log Files - A brief description of how to manage MySQL log files.

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.

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.