Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Free compiler install MySQL-5.6.14     - Windows Server 2012 R2 Datacenter install SQL Server 2016 CTP (Database)

- Python developer of time-saving method (Programming)

- Oracle Client Dedicated and Shared connection mode (Database)

- CentOS7 install and configure Nagios (Server)

- Elasticsearch 2.20 Highlight (Server)

- grep command Series: grep command to search for multiple words (Linux)

- CentOS 5.8 (64) Python 2.7.5 installation error resolved (Linux)

- Use Aptik Battery Monitor monitoring Ubuntu laptop battery usage (Linux)

- Computer security protection remove local and remote system log files (Linux)

- Git Getting Started tutorial (Linux)

- Linux disk management practices (Linux)

- Usage sed some of the parameters (Linux)

- Linux FAQ - How to fix tar:Exitingwith failure status due to previous errors (Linux)

- Keepalived + HAProxy high availability load balancing (Server)

- Java NIO2: Buffer (Programming)

- What Java 8 fastest garbage collector (Programming)

- Linux Systemd-- To start / stop / restart services in RHEL / CentOS 7 (Linux)

- Linux network cut package is not fully defragment (Linux)

- 10 tips daily Docker (Server)

- Linux log management make the system more secure (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:      
 
- CentOS set up FTP server (Server)
- tcpdump Linux system security tools (Linux)
- To install Samba server on CentOS 6.6 (Server)
- Configuring Proxy on a Unix terminal, accelerate Android Studio Construction (Linux)
- iptables using summary (Linux)
- Lua study notes under ubuntu (Linux)
- Easy to install Ubuntu 15.04 and Ubuntu 15.04 GNOME on Wayland trial (Linux)
- RHEL6.4 one key installation Redmine (Linux)
- Through eight skills to let you become a super Linux end-user (Linux)
- System with Windows Remote Desktop to connect Ubuntu 15.04 (Linux)
- OpenSUSE GPG Comments (Linux)
- The Linux role of each directory contents (Linux)
- Learn to read the source code of vmstat (Linux)
- X security settings in Ubuntu (Linux)
- MySQL performance comparison of large amounts of data storage (Database)
- CentOS7 + Redis Live Installation and Configuration (Linux)
- Raspberry Pi 2 to install the latest version of the FPC and Lazarus 1.5 (Linux)
- ASP.NET 5 (vNext) Linux deployment (Server)
- Linux folder and extract the differential file comparison techniques -rsync Magical (Linux)
- MySQL 5.7.9 source compiler installation instructions (Database)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.