Open SUSE12.2 MySQL5.6数据库安装配置(二)
-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host =
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user =
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port =
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /opt/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
# The safe_mysqld script
[safe_mysqld]
log-error = /var/log/mysql/mysqld.log
socket = /opt/mysql/mysql.sock
[mysqldump]
socket = /opt/mysql/mysql.sock
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld_multi.log
四、从给出的配置文件可以看到几个信息与默认的不一样
1、basedir路径的配置
2、datadir路径的配置
3、[client] socket路径的配置
4、[mysqld] socket路径的配置
5、[safe_mysqld] socket路径的配置
6、[mysqldump] socket路径的配置
由于datadir路径配置为“/opt/mysql”,则需要把默认路径"/var/lib"下整个"mysql"文件夹复制到"/opt"下。以下是需要特别注意的地方:先查看一下"/var/lib"下"mysql"的权限和所有者;发现该文件夹的所有者为mysql。再查看"/opt"下刚才复制的"mysql"文件夹所有者,发现该所有者是root,此时如果启动mysql服务,会报错误:StartingMySQL.The server quit without updating PID file。修改"/opt"目录下的"mysql"文件夹所有者:
/opt>chown -R mysql:mysql mysql
注意:[client] socket路径的配置、[mysqld] socket路径的配置、[safe_mysqld] socket路径的配置、[mysqldump] socket路径的配置,都是配置在"/opt/mysql"下。否则会报没有找到mysql.sock错误。
启动mysql服务:service mysql start
查看mysql服务状态:service mysql status
发现一切正常,利用安装时随机生成的root密码(在`/.mysql_secret中)登陆,修改root密码或添加新用户。