Answer the question
In order to leave comments, you need to log in
Mysql doesn't want to run on archlinux. Why?
I just installed MYSQL (pacman installed MariaDB, although I don't think it matters), but MYSQL doesn't want to start.
The log is like this:
151209 01:38:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-12-09 01:38:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-09 01:38:41 0 [Note] /usr/bin/mysqld (mysqld 5.6.27-75.0) starting as process 22045 ...
2015-12-09 01:38:41 22045 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
2015-12-09 01:38:41 22045 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)
/usr/bin/mysqld: Table 'mysql.plugin' doesn't exist
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[client]
port = 3306
socket = /run/mysqld/mysqld.sock
[mysqld]
port = 3306
socket = /run/mysqld/mysqld.sock
datadir = /var/lib/mysql
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]
log-error = /var/log/mysqld.log
pid-file = /run/mysqld/mysqld.pid
Answer the question
In order to leave comments, you need to log in
Was the startup script executed (it also sets the root password) before starting the service?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question