Mysql will not start
Just installed a new Centos 7 server with Cpanel.
Wanted to create a new main user, but that would not work because Mysql was not running.
Can't start mysql, the log is stating this:
This is the my.cnf:
It looks like mysql can't write a tmp file. The only thing I did for tmp is to run the /scripts/securetmp script. The directory /mysqlmp does not exist, and even if I create it as root, mysql will not start. Edit: Just checked something else. /etc/systemd/system does not contain any mysqld.service but there is a mysql.service file. I don't know if that is important.
171206 02:47:20 mysqld_safe mysqld from pid file /var/lib/mysql/srv.domainname.nl.pid ended
171206 02:47:36 mysqld_safe Logging to '/var/lib/mysql/srv.domainname.nl.err'.
171206 02:47:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-12-06 02:47:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp se
rver option (see documentation for more details).
2017-12-06 02:47:36 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated
files. Consider setting it to a valid, non-empty path.
2017-12-06 02:47:36 0 [Note] /usr/sbin/mysqld (mysqld 5.6.38) starting as process 2946 ...
2017-12-06 02:47:36 2946 [Note] Plugin 'FEDERATED' is disabled.
2017-12-06 02:47:36 2946 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-06 02:47:36 2946 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-06 02:47:36 2946 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-06 02:47:36 2946 [Note] InnoDB: Memory barrier is not used
2017-12-06 02:47:36 2946 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-06 02:47:36 2946 [Note] InnoDB: Using Linux native AIO
2017-12-06 02:47:36 2946 [Note] InnoDB: Using CPU crc32 instructions
2017-12-06 02:47:36 2946 /usr/sbin/mysqld: Can't create/write to file '/mysqltmp/ibysu3zM' (Errcode: 2 - No such file or directory)
2017-12-06 02:47:36 7fc686470740 InnoDB: Error: unable to create temporary file; errno: 2
2017-12-06 02:47:36 2946 [ERROR] Plugin 'InnoDB' init function returned error.
2017-12-06 02:47:36 2946 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-12-06 02:47:36 2946 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-12-06 02:47:36 2946 [ERROR] AbortingThis is the my.cnf:
[mysqld]
max_connections=500
# safe-show-database
local-infile=0
max_allowed_packet=268435456
innodb_buffer_pool_size=512M
innodb_lock_wait_timeout=180
open_files_limit=22506
tmpdir="/mysqltmp"
default-storage-engine=MyISAM
innodb_file_per_table=1It looks like mysql can't write a tmp file. The only thing I did for tmp is to run the /scripts/securetmp script. The directory /mysqlmp does not exist, and even if I create it as root, mysql will not start. Edit: Just checked something else. /etc/systemd/system does not contain any mysqld.service but there is a mysql.service file. I don't know if that is important.
-
Stupid me. Just overlooked a setting I put in the my.cnf myself. This is solved, topic can be closed. 0 -
Hello, I'm glad to see the issue is now solved. Could you let us know the specific setting that caused the issue? Thank you. 0
Please sign in to leave a comment.
Comments
3 comments