Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Free compiler install MySQL-5.6.14     - MySQL flip-flop (Database)

- Based on Python: OpenCV simple image manipulation (Programming)

- MySQL full-index scan bug (Database)

- How to fix fatal error: security / pam_modules.h: No such file or directory (Linux)

- Virtualbox virtual machine can not copy CentOS Network (Linux)

- Linux server startup and logon security settings (Linux)

- Introduces Linux kernel compilation system and compiler installation (Linux)

- ORA-04091 and Compound Trigger (Oracle 11g) (Database)

- Detailed Linux su command to switch users Mistakes (Linux)

- MySQL script incremental backups (innobackupex) (Database)

- Use Visual Studio 2015 to develop Android program (Programming)

- Two alert log ORA Errors (Database)

- Xtrabackup creates a slave node without downtime (Database)

- MySQL / MariaDB database master-slave replication (Database)

- Management DB2 logs (Database)

- How to install Linux Go Language (Linux)

- Find details block device with Linux blkid command (Linux)

- Linux system Passwd file detailed analysis (Linux)

- The ActiveMQ JMS installation and application examples for Linux (Linux)

- Cobbler Add custom YUM source (Linux)

 
         
  Free compiler install MySQL-5.6.14
     
  Add Date : 2018-11-21      
         
       
         
  Today, leader requires compiler installed mysql-free production environment, so only below. Directory has been involved in the processing, we needed to change it yourself!

1 Free download mysql-compiled packages:
wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz

2 Set the mysql directory:
tar -zxvf mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.6.14-linux-glibc2.5-x86_64 / usr / local / mysql
groupadd mysql
useradd -g mysql -M mysql
mkdir -p / work / mysql / data
chown -R mysql.mysql / work / mysql / data

3 Initialize the MySQL database:

# Tip: Run the following command before the system does not confirm the initial installation mysql /etc/my.cnf
/ Usr / local / mysql / scripts / mysql_install_db --basedir = / usr / local / mysql --datadir = / work / mysql / data --user = mysql

 
4 Add mysqld become a system service and set from the start:
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on

5 Start mysql:
/etc/init.d/mysqld start

6 password:
/ Usr / local / mysql / bin / mysqladmin -u root password 'your password'

About 7 my.cnf:
mysqld-5.5 or later my.cnf this document at the time of the initialization, will be automatically installed to /usr/local/mysql/my.cnf. And major changes inside the configuration options

 
8 faults:
Fatal error: Can not open and lock privilege tables: Table 'mysql.user' does not exist

 
Solution:
This issue is the need to re-initialize the mysql database
mysql_install_db --basedir = / usr / local / mysql --datadir = / work / mysql / data --user = mysql

9 About my my.cnf:
/usr/local/mysql/my.cnf
# For advice on how to change settings please see
# Http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[Mysqld]
# 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
# These are commonly set, remove the # and set as required.
basedir = / usr / local / mysql
datadir = / work / mysql / data
port = 3306
# Server_id = .....
socket = /tmp/mysql.sock
# 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
sql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

 
ps: according to the contents of the above can be made into a key installation script themselves. So I do not like before a long wait.
     
         
       
         
  More:      
 
- Linux NIC configuration (Linux)
- Oracle SQL statement to retrieve data paging table (Database)
- Linux Security (Linux)
- CentOS 6.6 compile and install phpMyAdmin configuration PostgreSQL9.4.1 (Database)
- Git bulk delete remote tag (Linux)
- Computer black magic: tail recursion (Programming)
- Linux simple commands (Linux)
- CentOS install expect (Linux)
- About ORA-02391 solution (Database)
- CentOS7 boot systemd introduction and use of management (Linux)
- SUSE Linux network configuration and firewall configuration (Linux)
- Linux System Getting Started Tutorial: How to Force Change your password at next logon Linux (Linux)
- Linux protobuf-c (Linux)
- Install DB2 V10 and Data Studio V3 under Linux (Ubuntu) environment (Database)
- Arronax allows you to easily create desktop startup file (Linux)
- Use Nginx as a load balancer (Server)
- When a software RAID data recovery and reconstruction of how failure (Linux)
- Ubuntu users how to install the latest Nvidia graphics drivers (Linux)
- Installation of Gitlab under Ubuntu (Linux)
- Lua regex (string function) (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.