mysqlinnodb创建数据文件失败的解决_MySQL
2020-11-09
来源：华佗健康网
mysql innodb创建数据文件失败的解决 /etc/my.cnf配置 [mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Default to using old password format for compatibility with mysql 3.x# clients (those using the mysqlclient10 compatibility package).old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks;# to do so, uncomment this line:# symbolic-links=0 default-character-set=utf8default-storage-engine=innodb# Uncomment the following if you are using InnoDB tablesinnodb_data_home_dir = /var/mysql/innodb/innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextendinnodb_log_group_home_dir = /var/mysql/innodb/log/innodb_log_arch_dir = /var/mysql/innodb/log/ # You can set .._buffer_pool_size up to 50 - 80 %# of RAM but beware of setting memory usage too highinnodb_buffer_pool_size = 1024Minnodb_additional_mem_pool_size = 20M# Set .._log_file_size to 25 % of buffer pool sizeinnodb_log_file_size = 192Minnodb_log_buffer_size = 18Minnodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 50 [client]default-character-set=gbk [mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid 启动mysqld失败，目录权限已设置为777， 并已 /usr/bin/mysql_install_db --user=mysql 原因似乎是innodb的数据目录必须处于datadir配置的子目录下！ 查看日志 /var/log/mysqld.log......................... 120817 13:08:17 InnoDB: Operating system error number 13 in a file operation.InnoDB: The error means mysqld does not have the access rights toInnoDB: the directory.InnoDB: File name /var/mysql/innodb/ibdata1InnoDB: File operation call: 'create'.InnoDB: Cannot continue operation.120817 13:08:17 mysqld ended 修改/etc/my.cnf配置 [mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Default to using old password format for compatibility with mysql 3.x# clients (those using the mysqlclient10 compatibility package).old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks;# to do so, uncomment this line:# symbolic-links=0 default-character-set=utf8default-storage-engine=innodb# Uncomment the following if you are using InnoDB tablesinnodb_data_home_dir=/var/lib/mysql/innodb/innodb_data_file_path=ibdata1:2000M;ibdata2:10M:autoextendinnodb_log_group_home_dir=/var/lib/mysql/innodb/log/innodb_log_arch_dir=/var/lib/mysql/innodb/log/# You can set .._buffer_pool_size up to 50 - 80 %# of RAM but beware of setting memory usage too highinnodb_buffer_pool_size=1024Minnodb_additional_mem_pool_size=20M# Set .._log_file_size to 25 % of buffer pool sizeinnodb_log_file_size=192Minnodb_log_buffer_size=18Minnodb_flush_log_at_trx_commit=1innodb_lock_wait_timeout=50 [client]default-character-set=gbk [mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid 启动成功。 bitsCN.com
显示全文