MYSQL版本:5.1.44-community
mysqld_safe 是用来启动、监控和在出问题时重新启动mysqld的相关程序;(mysqld_safe 在MySQL4之前的版本叫做:safe_mysqld).
二所ATC系统数据库位置:
/usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/DBM.pid
即/var/lib/mysql
启动设置:chkconfig --list |grep mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
即/var/lib/mysql
启动设置:chkconfig --list |grep mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
查看数据目录路径名等变量:
#mysqladmin -uroot -pabc variables
| storage_engine | MyISAM |
| datadir | /var/lib/mysql/ |
| character_sets_dir | /usr/share/mysql/charsets/ |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_database | latin1 |
| character_set_server | latin1 |