4 MySQL_Video_Tutorial_MY_CNF

In this video tutorial you will learn about default configuration file my.cnf for mysql server. you can add / change various configuration parameters in this file so that when ever you restart server, new configuration values will get in effect.
On Ubuntu /etc/default/my.cnf OR on centos / redhat / fedora it is /etc/my.cnf
[mysqld]
user = mysql
port = 3306
datadir = /var/lib/mysql
socket = /var/run/mysqld/mysqld.sock
pid = /var/run/mysqld/mysqld.pid
tmpdir = /tmp