Open SUSE12.2 MySQL5.6数据库安装配置(二)

2014-11-24 11:24:15 · 作者: · 浏览: 1
-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密码或添加新用户。