全新安裝後，MariaDB 將無法啟動。沒有錯誤，沒有日誌

Question 1

請執行：

service mariadb restart; journalctl -xe

因此，您可以確保沒有其他訊息將 mysql/mariadb 輸出推送到 -xe 視圖之外。

也許資料庫從未初始化。

因此了解 /etc/my.cnf 的內容可能會有所幫助。

讓我們知道 datadir 所在的位置。

datadir    = /var/lib/mysql

但據我所知，它在某些發行版和版本中更改為 /var/lib/mariadb

如果設定了 datadir，並且非常重要：資料目錄為空且資料庫未執行：

執行mysql_安裝_資料庫手動。

** 也許必須更改 datadir。

chown -R mysql:mysql /var/lib/mysql

然後再試一次：

service mariadb start; journalctl -xe

也許使用它作為初始 my.cnf

    # This is default example of MySQL/MariaDB configuration provided with openSUSE package
# It is based on upstream defaults with some additional examples.


# The following options will be passed to all MariaDB clients
[client]
# password  = your_password
# port       = 3306
# socket     = /var/run/mysql/mysql.sock

[xtrabackup]
target_dir = /DATA/BACKUP/mysql
datadir = /var/lib/mysql/

[mysqld]
socket                          = /var/lib/mysql/mysql.sock
innodb_buffer_pool_size         = 20G
innodb_file_format              = Barracuda
innodb_file_per_table           = ON
innodb_buffer_pool_instances    = 20
innodb_thread_concurrency       = 4
innodb_purge_threads            = 4
innodb_strict_mode              = 1
innodb_old_blocks_time          = 1000
innodb_stats_on_metadata        = 0
innodb_write_io_threads         = 4
innodb_read_io_threads          = 4
innodb_io_capacity              = 200000
innodb_open_files               = 10000
innodb_log_file_size            = 1G
innodb_log_buffer_size          = 1G
innodb_log_files_in_group       = 3
transaction-isolation           = READ-COMMITTED


server-id                       = 1
#skip-networking
bind-address                   = 0.0.0.0

log_bin                        = master-mysql-bin
back_log                       = 500
concurrent_insert              = ALWAYS
expire_logs_days               = 10
delay-key-write                = ALL
myisam-recover-options         = FORCE,BACKUP
key_buffer_size                = 512M
join_buffer_size               = 256M
max_allowed_packet             = 128M
max_heap_table_size            = 1024M
tmp_table_size                 = 1024M
thread_stack                   = 192K
table_open_cache               = 10240
table_definition_cache         = 10240
open_files_limit               = 100000
net_retry_count                = 16384
query_cache_type               = 0
query_cache_size               = 0M
query_cache_limit              = 0M
query_cache_min_res_unit       = 1K
thread_cache_size              = 100
max_connections                = 100
ft_max_word_len                = 20
ft_min_word_len                = 3
long_query_time                = 5
local-infile                   = 0
log-warnings                   = 2
performance_schema             = ON
log-slave-updates
log-queries-not-using-indexes
skip-external-locking
skip-symbolic-links
skip-name-resolve

!includedir /etc/my.cnf.d

然後手動啟動mysql/mariadb：

# To ensure the service is stoppen:
service mariadb stop

/usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql

Answer