MySQL服务器问题

启动MySQL服务器程序,确认状态

1)启动MySQL服务程序

启动服务并查看状态:

[root@dbsvr1 pub]# service mysql start
Starting MySQL...                                     [确定]
[root@dbsvr1 pub]# service mysql status
MySQL running (31724)                                 [确定]

服务器进程为mysqld,监听的默认端口为TCP 3306:

[root@dbsvr1 pub]# netstat -anpt | grep mysql
tcp        0      0 :::3306        :::*       LISTEN      31724/mysqld

2)查看MySQL服务器进程、运行用户

提供连接服务的进程为mysqld,由其父进程mysqld_safe启动。

[root@dbsvr1 pub]# ps -elf | grep mysqld

4 S root     31619     1  0  80   0 -  2834 wait   15:14 pts/0    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid file=/var/lib/mysql/dbsvr1.tarena.com.pid

4 S mysql    31724 31619  0  80   0 - 252496 poll_s 15:14 pts/0   00:00:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/dbsvr1.tarena.com.err --pid-file=/var/lib/mysql/dbsvr1.tarena.com.pid

数据库的默认存放位置为 /var/lib/mysql:

[root@dbsvr1 pub]# ls /var/lib/mysql/
auto.cnf               ibdata1      mysql               RPM_UPGRADE_HISTORY
dbsvr1.tarena.com.err  ib_logfile0  mysql.sock          RPM_UPGRADE_MARKER-LAST
dbsvr1.tarena.com.pid  ib_logfile1  performance_schema  test