MySQL is not running, but lock file (/ var / lock / subsys / mysql) the existence of this problem exists generally determined by three reasons: 1: configuration files enough authority, all of the files related to the configuration of all the changes for the mysql user rights 2: pid mysql is not running, rm -rf / var / lock / subsys / mysql, to re-create a new default pid file permissions to 660 3: my.cnf configuration file errors, we need to re-edit
Can not open and lock privilege tables: Table 'mysql.user' does not exist The problem is due myql storage file system comes with no database can be entered or the database mysql_install_db the path to re-edit the default / directory var / lib / mysql is
posted below my own mariadb configuration (from the database)
[client] port = 3306 socket = /var/lib/mysql/mysql.sock default-character-set = utf8
[mysqld_safe] socket = /var/lib/mysql/mysql.sock nice = 0
[mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = / var / lib / mysql /mysql.sock log_error = /var/log/mysqld/error.log port = 3306 basedir = / usr datadir = / data tmpdir = / tmp lc-messages-dir = / usr / share / mysql skip-external-locking bind-address = 0.0.0.0 skip- name-resolve lower_case_table_names = 1 max_connections = 1000 connect_timeout = 15 wait_timeout = 600 max_allowed_packet = 16M thread_cache_size = 128 sort_buffer_size = 16M bulk_insert_buffer_size = 16M tmp_table_size = 128M max_heap_table_size = 128M query_cache_limit = 0 query_cache_size = 0
long_query_time = 10
log_bin = / var / log / mysqld / mysql-bin log_bin_index = / var / log / mysqld / mysql-bin.index
expire_logs_days = 10 max_binlog_size = 100M
binlog_ignore_db = mysql server_id = 5005 log_slave_updates = 1 slave_skip_errors = all # auto_increment_offset = 1 ### auto_increment_increment = 2 # binlog_format = row # ## ## replicate-do-db = #key_buffer_size = 1024M ## # # collation-server = utf8_general_ci # init-connect = 'SET NAMES utf8' # character-set-server = utf8 # # default_storage_engine = InnoDB # innodb_buffer_pool_size = 30720M # innodb_log_buffer_size = 32M # innodb_file_per_table = 1 # innodb_open_files = 400 # innodb_io_capacity = 400 # innodb_flush_method = O_DIRECT #innodb_flush_log_at_trx_commit = 2 # innodb_log_file_size = 512M # # key_buffer = 16M # thread_stack = 192K # myisam-recover = BACKUP # # [mysqldump] #quick # quote-names # max_allowed_packet = 16M # # [isamchk] # key_buffer = 16M ## |