DIFFERENCE BETWEEN ORACLE AND MySQL -05

DIFFERENCE BETWEEN ORACLE AND MySQL -05 Please refer my previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -04 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle ,we need to write Parameters to set (or)… 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

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

Installing MySQL on Red Hat Enterprise Linux Using the MySQL Yum Repository(Article -08).

Installing MySQL on Red Hat Enterprise Linux Using the MySQL Yum Repository.   Installing YUM basic packages of OS. Download RPM files from http://dev.mysql.com/downloads/repo/yum/ click on download button. Click on download option on browser copy the URL and execute  following command.

If wget command… 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