show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
---
ps -aux|grep mysql
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
root 17773 0.0 0.1 3704 528 pts/2 S+ 03:31 0:00 tail -f /var/log/mysqld.log
root 18113 0.0 0.2 4488 1196 pts/1 S 03:43 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log
mysql 18149 0.1 3.5 137036 18236 pts/1 Sl 03:43 0:00 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock
root 18169 0.0 0.0 3836 460 pts/1 R+ 03:44 0:00 grep mysql
---
vi /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]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
##
ls -al /var/lib/mysql
total 20556
drwxr-xr-x 7 mysql mysql 4096 May 21 03:43 .
drwxr-xr-x 27 root root 4096 May 20 17:39 ..
drwx------ 2 mysql mysql 4096 May 18 15:25 carmamembers
-rw-rw---- 1 mysql mysql 10485760 May 21 03:43 ibdata1
-rw-rw---- 1 mysql mysql 5242880 May 21 03:43 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Apr 5 2006 ib_logfile1
drwx------ 2 mysql mysql 12288 Jan 22 11:42 kenyan
drwx------ 2 mysql mysql 4096 Dec 27 17:44 mail
drwx------ 2 mysql mysql 4096 Jun 6 2006 mysql
srwxrwxrwx 1 mysql mysql 0 May 21 03:43 mysql.sock
drwx------ 2 mysql mysql 4096 Feb 19 04:59 test