Mysqlinnodb solution for failed data file creation _ MySQL

Solve the problem of mysqlinnodb data file creation failure bitsCN.com
Troubleshooting of data file creation failure in mysql innodb/etc/my. cnf configuration [mysqld] datadir =/var/lib/mysqlsocket =/var/lib/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-char Acter-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: 2000 M; ibdata2: 10 M: 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 highinno Db_buffer_pool_size = 1024Minnodb_additional_mem_pool_size = 20 M # Set .. _ log_file_size to 25% of buffer pool limit = bytes = 1innodb_lock_wait_timeout = 50 [client] default-character-set = gbk [mysqld_safe] log-error =/var/log/mysqld. logpid-file =/var/run/mysqld. pid failed to start mysqld, directory permission set to 777, and/usr/bin/mysql_install_db -- User = mysql the reason seems to be that the innodb data directory must be in the subdirectory configured by datadir! View Logs/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 modify/etc/my. cnf configuration [mysqld] datadir =/var/lib/m Ysqlsocket =/var/lib/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 foll Owing if you are using InnoDB tablesinnodb_data_home_dir =/var/lib/mysql/innodb/innodb_data_file_path = ibdata1: 2000 M; ibdata2: 10 M: 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 = 20 M # Set .. _ log_file_size to 25% of buffer pool limit = bytes = 1innodb_lock_wait_timeout = 50 [client] default-character-set = gbk [mysqld_safe] log-error =/var/log/mysqld. logpid-file =/var/run/mysqld. pid started successfully. BitsCN.com