Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MariaDB database storage path modify configuration issues     - Under CentOS using yum command to install the Task Scheduler crontab (Linux)

- Diagnose and resolve the SSH connection slow (Linux)

- Linux 6 install Oracle 11g (64bit) (Database)

- CentOS7 boot systemd introduction and use of management (Linux)

- Use Ambari rapid deployment Hadoop big data environment (Server)

- How to install Nginx on FreeBSD 10.2 as an Apache reverse proxy (Server)

- Linux top command to get started (Linux)

- Use NTFS-3G to mount NTFS partitions under Linux U disk and removable hard disk (Linux)

- Linux command line ten magic usage (Linux)

- Comparison of Nginx and Nginx + (Server)

- Linux / CentOS 7.0 installation and configuration under Tomcat 8.0 (Server)

- Ubuntu file security removal tool (Linux)

- Ubuntu Locale configuration problem solving Can not set LC_CTYPE (Linux)

- Oriented C ++ test-driven development (Programming)

- Why learn and use C language (Programming)

- SQL Server memory Misunderstanding (Database)

- Configuring xdebug debugging environment in Ubuntu 14.04 under the PhpStorm (Linux)

- Role Object of registerNatives () method (Programming)

- How to install CentOS 7.x in OpenERP (Odoo) (Linux)

- CentOS 6.5 / 6.6 modify the default SSH port number (Linux)

 
         
  MariaDB database storage path modify configuration issues
     
  Add Date : 2018-11-21      
         
         
         
 

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
##

     
         
         
         
  More:      
 
- MySQL monitoring tools -orzdba (Database)
- CentOS 6.3 compile and install LNMP environment (Server)
- VMware virtual machine to use bridged mode fast Internet access (Linux)
- Linux6.1 / 6.5 dual-NIC Binding (Linux)
- IDS Intrusion Detection System built (Linux) (Linux)
- Based shell: using read, the command-line script to achieve mass participation and input two integer calculation (Programming)
- LogStash log analysis display system (Linux)
- Linux security settings (Linux)
- MySQL stored procedures and triggers (Database)
- Oracle partition table data migration, process management automation (Database)
- ActiveMQ-based shared file system HA solutions (Server)
- C ++ sequence containers basics summary (Programming)
- Linux asynchronous read documents by AIO (Programming)
- Ubuntu 15.10 / 14.04 install subtitling software Aegisub (Linux)
- CentOS 7 source code to compile and install PHP5.6 Nginx1.7.9 and MySQL (LNMP build environment) (Server)
- Element content of Java HashSet change issues (Programming)
- Build Python3.4 + PyQt5.3.2 + Eric 6.0 development platform Ubuntu 14.04 (Server)
- Fedora 20, Fedora 19, CentOS 6 and RHEL6 users how to install Wine 1.7.15 (Linux)
- MySQL partition table Comments (Database)
- Oracle PL / SQL selective basis (IF CASE), (LOOP WHILE FOR) (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.