Little remember MySQL boot failed no log processing

Originally MySQL good, before cleaning up a tmp under the things, MySQL in the query when prompted:

Can'/TMP/IB0N3FRL

Then stop the boot:

[[Email protected]_linux mysql]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

Startup failed, look at the log, found that the configuration did not add the log configuration

Find my.cnf, add log-error=/var/log/mysql/mysql-error.log under [mysqld]

Configure the MySQL error log, MySQL directory self-setting, which remember a little, chown-r mysql:mysql/tmp/mysql

Give MySQL directory permissions because I am root, MySQL run permissions for MySQL, no permissions

To start MySQL again:

180222 Ten: $: -innodb:mutexes and Rw_locks use GCC atomic builtins180222 Ten: $: -innodb:compressed Tables Use Zlib1.2.3180222 Ten: $: -innodb:using Linux Native AIO^g/usr/libexec/mysqld:can't create/write to file'/tmp/mysql_data/ibagn543'(errcode:13)180222 Ten: $: -InnoDB:Error:unable to create temporary file; Errno: -180222 Ten: $: -[ERROR] Plugin'InnoDB'init function returned error.180222 Ten: $: -[ERROR] Plugin'InnoDB'Registration asa STORAGE ENGINE failed.180222 Ten: $: -[ERROR] unknown/Unsupported Storage Engine:innodb180222 Ten: $: -[ERROR] aborting180222 Ten: $: -[Note]/usr/libexec/mysqld:shutdown complete

The original is can ' t create/write to file, then it is good to solve, to see if the Mysql_data directory exists.

Chmod-r 777/tmp

Give the Write permission to start MySQL:

[Email protected]_linux mysql]# service mysqld startstarting mysqld:                                           [  OK  ]

Just do it.

Little remember MySQL boot failed no log processing