Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL5.6.17 compiler installation under CentOS     - The sublime into IDE (Linux)

- Linux remote connectivity tools -OpenSSH (Linux)

- Sublime Text 3 shortcuts summary (Linux)

- Nginx supports user multi-threaded downloads and resume broken (Server)

- Linux System Getting Started Learning: Debian download, installation and graphical interface (Linux)

- Design and implementation of environment sniffer running under Linux (Linux)

- Let your PHP 7 faster the Hugepage (Linux)

- Spring MVC Exception Handling (Programming)

- Linux process or thread is bound to a CPU (Programming)

- MongoDB 3.2 to upgrade from 3.0.7 (Database)

- Use the TC flow control test under Linux (Linux)

- Install the Solaris 10 operating system environment over the network to sparc (Linux)

- Spring Data study notes -Helloworld (Programming)

- File sharing and fork function (Programming)

- C data types is how it is supported by most computer systems (Programming)

- Python is not C (Programming)

- Linux based serial programming (Programming)

- Camera-based face recognition OpenCV crawl and storage format (Python) (Linux)

- Python Flask environment to build (Linux)

- Sudo and Root Account in Ubuntu related (Linux)

 
         
  MySQL5.6.17 compiler installation under CentOS
     
  Add Date : 2017-04-13      
         
         
         
  Production environment, MySQL server on top of what the best service is not installed again! ! !
First, the preparatory work:

# Yum -y install make gcc-c ++ cmake bison-devel ncurses-devel
 Second, the deployment Mysql:

# Tar zxf mysql-5.6.17.tar.gz
# Cd mysql-5.6.17
# Cmake \
-DCMAKE_INSTALL_PREFIX = / Usr / local / mysql \
-DMYSQL_DATADIR = / Usr / local / mysql / data \
-DSYSCONFDIR = / Etc \
-DWITH_MYISAM_STORAGE_ENGINE = 1 \
-DWITH_INNOBASE_STORAGE_ENGINE = 1 \
-DWITH_MEMORY_STORAGE_ENGINE = 1 \
-DWITH_READLINE = 1 \
-DMYSQL_UNIX_ADDR = / Var / lib / mysql / mysql.sock \
-DMYSQL_TCP_PORT = 3306 \
-DENABLED_LOCAL_INFILE = 1 \
-DWITH_PARTITION_STORAGE_ENGINE = 1 \
-DEXTRA_CHARSETS = All \
-DDEFAULT_CHARSET = Utf8 \
-DDEFAULT_COLLATION = Utf8_general_ci
# Make && make install
Third, configure Mysql:

1, set permissions:

# Groupadd mysql
# Useradd -g mysql mysql
# Chown -R mysql: mysql / usr / local / mysql
 2, the initial configuration:

# Cd / usr / local / mysql
# Scripts / mysql_install_db --basedir = / usr / local / mysql --datadir = / usr / local / mysql / data --user = mysql
1 Note: When you start the MySQL service, searches my.cnf according to a certain order, first in the / etc directory to find, the search will find "$ basedir / my.cnf", in this case, it is / usr / local /mysql/my.cnf, which is the default location for the new version of MySQL configuration file!
2 after the CentOS 6.4 operating system minimum installation is complete, in the / etc directory there will be a my.cnf, need this file renamed to other names, such as: /etc/my.cnf.bak, otherwise, the file MySQL is configured correctly can interfere with the installation source, resulting not start.
3 After using "yum update" to update the system, you will more need to check the / etc directory a my.cnf, if more, rename it to something else. Otherwise, MySQL will use this configuration file to start, not start properly may cause problems.
3, set the boot and start Mysql:

# Cp support-files / mysql.server /etc/init.d/mysql
# Chkconfig mysql on
# Service mysql start // start Mysql
4, configuration variables mysql command, or execute each command mysql had to switch to the installation directory

# Vim / etc / profile
1 # define the Mysql command -------------------- ------------------------ ----- #
2 export PATH = / usr / local / mysql / bin: $ PATH
# Source / etc / profile
Fourth, configure user:

After a successful start MySQL, the default root no password, we need to set the root password.

# Mysql -uroot
mysql> SET PASSWORD = PASSWORD ( 'You_password'); // You_password password you want to set
Set the root user remote access to:

. Mysql> GRANT ALL PRIVILEGES ON * * TO 'root'@'192.168.%' IDENTIFIED BY 'You_password' WITH GRANT OPTION; // when the red You_password for remote access, root user password, and different local.
Fifth, configure the firewall

Firewall port 3306 is not turned on by default, to remote access, you need to open this port
Open the / etc / sysconfig / iptables
In the "-A INPUT -m state --state NEW -m tcp -p -dport 22 -j ACCEPT", added with:

1 -A INPUT -m state --state NEW -m tcp -p -dport 3306 -j ACCEPT
Then save and close the file, run the following command in the terminal, refresh the firewall configuration:

# Service iptables restart
Deployed!

Extended!

CentOS 7 default firewall using Firewalld do so modified iptables, after reboot the system simply does not work.
Firewalld add the port as follows:

firewall-cmd --zone = public --add-port = 3306 / tcp --permanent
firewall-cmd --reload
     
         
         
         
  More:      
 
- Use $ BASH ENV variable to mention the right way under Linux (Linux)
- Create your own YUM repository (Linux)
- Sort search algorithm Java - application examples with recursive dichotomy (Programming)
- ARM constant expression (Programming)
- Tab set to four spaces in Vim (Linux)
- How to install the latest version of the Eclipse in Ubuntu 14.04 (Linux)
- Linux command line to put on your coat GUI (Linux)
- Programmer editor Vim (Linux)
- MySQL my.cnf sql_mode schema modifications (Database)
- Seven kinds of NIC binding mode Detail (Linux)
- Linux security-related basics (Linux)
- Lucene Getting Started Tutorial (Server)
- Ubuntu comes with gedit editor to add Markdown preview widget (Linux)
- Redis master-slave replication switch (Database)
- Why you can have JavaScript string method (Programming)
- Detailed use Zabbix monitoring Nginx (Server)
- CentOS7 install JDK (Linux)
- How to install PlayOnLinux 4.2.5 under Ubuntu 14.04 / 12.04 (Linux)
- Repair after installing Ubuntu no boot device error (Linux)
- VirtualBox snapshots (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.