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

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 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

MySQL Architecture-01(Article -04)

MySQL Architecture     When a query comes to MySQL from Client program   it will go to Query parsing  (hear it will check for SQL syntax by checking every character in SQL query and generate SQL_ID for each SQL query.) then it will sent to Optimization … Read More