DIFFERENCE BETWEEN ORACLE AND MySQL. The Oracle Database is an object-relational database management system (ORDBMS). MySQL is an open source relational database management system (RDBMS). Both the Oracle Database and MySQL are database management systems currently produced and managed by the Oracle Corporation. The Oracle… Read More

Table Maintenance in MySQL (Article -16)

Table Maintenance  in MySQL. This page contains several commands you will use to optimize, analyse and repair tables. It also presents the mysqlcheck command line tool. Table maintenance will separated in five ways .They are  : Check Table Repair Table Analyse Table Optimise Table mysqlcheck  … Read More

MySQL Clients (Articles -10).

MySQL Clients   Learning Objectives : List the available clients for administrative tasks and their basic  purposes. Invoke mysql clients and common command line options. Invoke and us the MySQL command line client MySQL. Use the mysqladmin for administrative clients APIs (Drivers and Connectors).  … Read More

LOG FILES IN MySQL(Article -09)

LOG FILES IN MySQL. Before going to look on logfiles we need to know what is the use of my.cnf file. By default my.cnf file will be in /etc/my.cnf location, when ever you try to restart MySQL server look for my.cnf in /etc/ location.

Read More

Improving MySQL installation Security.(Article 07).

Improving  MySQL installation Security(UNIX Platform). 1.The mysql_secure_installation programs enables security improvement . Set password for root accounts. Remove remote root accounts. Remove anonymous accounts. Remove the test database. 2.Invoking the program It will prompt for actions to perform . Only applicable to Unix/Linux operating systems.… Read More