mysql 修改默认存储位置

[mysqld]#datadir=/var/lib/mysql#socket=/var/lib/mysql/mysql.sockdatadir=/opt/tools/mysqlsocket=/opt/tools/mysql/mysql.sockuser=mysqldefault-character-set=utf8log-slow-queries = /opt/logs/mysql/slowquery.loglong_query_time = 1  #单位是秒log-queries-not-using-indexes# Disabling symbolic-links is recommended to prevent assorted security risksset-variable=max_connections=1000max_allowed_packet=20Minnodb_buffer_pool_size=1G# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0[mysql.server]user=mysqlbasedir=/opt/tools/mysql[client]#用来让本机客户端连接的，否则本机连接就会报找不到 /var/lib/mysql/mysql.sock 错误socket=/opt/tools/mysql/mysql.sock[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid