What is MYI, MYD and FRM in mysql

Sep-10th-2010

Hi, Mysql data stores into /var/lib/mysql directory. Here is the content of a folder containing a database : root@map007 [/var/lib/mysql]# ls -l cphulkd/ total 348 drwx——  2 mysql mysql   4096 Sep  8 21:37 ./ drwxr-x–x 85 mysql mysql   4096 Sep  8 08:05 ../ -rw-rw—-  1 mysql mysql   8590 Feb 28  2010 auths.frm -rw-rw—-  1 mysql [...]

Howto MySQL Remote Access ?

Dec-14th-2008

Step # 1: Login through ssh to your server Step # 2: Enable networking Once connected you need edit the mysql configuration file my.cfg using text editor such as vi. # vi /etc/my.cnf Step # 3: Once file opened, locate line that read as follows [mysqld] Make sure line skip-networking is commented (or remove line) [...]