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 [...]
What is MYI, MYD and FRM in mysql
Sep-10th-2010
By piyushmap in Linux tutorials, Mysql
Howto MySQL Remote Access ?
Dec-14th-2008
By piyushmap in Mysql
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) [...]
