MYSQL

INSTALLING

Install the rpm of Mysql.

PROCESS OF MYSQL CONFIGURATION

1. Show “my.cnf” file by following command.

Its configuration file made in /etc directory with the name of “my.cnf”

root@amirpc ~]#cat /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with mysql 3.x

# clients (those using the mysqlclient10 compatibility package).

old_passwords=1

[mysql.server]

user=mysql

basedir=/var/lib

[mysqld_safe]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

2. Mysql server socket created in following directory.

root@amirpc ~]# /var/lib/mysql

3. Start services by following command.

root@amirpc ~]#service mysqld start

4. Use Mysql by following command.

root@amirpc ~]#mysql