Linux install Mysql 5.6.27
Personal summary in Linux Installation on Mysql 5.6.27 Version database , Record the success of personal operation , Help yourself and others at the same time .
First, download from the official website mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz（Linux Version of tar Installation package ）;
And then through SSH Secure File Transfer Client Put the file on the front page （/home/user） Here are the ordinary users I log in to , If you are logged in root The most privileged user , Then you can put the file directly into /usr/local/mysql below
（ Here it is /usr/local Create a new directory under the directory mysql Folder ------linux Instructions : mkdir /usr/local/mysql）
And then through Shell Client operation Linux System , Enter with release mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz Under the folder directory of , Then decompress tar file ------------ linux Instructions ： tar -zxvfmysql-5.6.27-linux-glibc2.5-x86_64.tar;
After decompression , A file named （mysql-5.6.27-linux-glibc2.5-x86_64） Folder , What's in it is mysql The installer for .
-------------------------------------------------------------------------------------
Add environment variables ,linux command ：vi .bash_profile Join in
export MYSQL_HOME = /usr/local/mysql
export PATH = MYSQL_HOME:$PATH
Press ESC Input :wq Save and exit
-------------------------------------------------------------------------------------
Then copy the pressurized program to the previously created mysql In the folder -------------linux Instructions : cp -rf /home/user/mysql-5.6.27-linux-glibc2.5-x86_64/* /usr/local/mysql （ This can also be done by cutting to save space ,linux Instructions ：mv /home/user/mysql-5.6.27-linux-glibc2.5-x86_64/* /usr/local/mysql)
Add system mysql Group and mysql user , Carry out orders ：groupadd mysql and useradd -r -g mysql mysql
Enter the directory where we installed --------------linux command ： cd /usr/local/mysql
Modify the current directory owner mysql user --------------linux command ： chown -R mysql:mysql ./
mount this database ： linux command --------------linux command ：./scripts/mysql_install_db --user=mysql( The user group we added earlier )
Modify the current directory owner as root user ----------linux command ：chown -R root:root ./
Modify the current data Directory owner mysql user -----------linux command ：chown -R mysql:mysql data
start-up mysql Service and add startup mysql service
----------------- Add startup ------linux command ：cp support-files/mysql.server /etc/init.d/mysql( Put the boot step in the boot initialization Directory )
----------------- start-up mysql service ------linux command ：/etc/init.d/mysql start ( restart restart)
------------------------------------------------------------------------------------------------------------
Some problems that may be encountered are summarized ：
When using mysql when ：
ERROR 2002 (HY000): Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2)
Can't find mysql.sock（ When you encounter similar problems , Can pass linux command ：
find / -name mysql.sock） Find the file directory
Then modify and open my.cnf file （ stay Mysql The configuration file under the installation directory ）
[client]
socket = /var/lib/mysql/mysql.sock( commonly find This is the directory you've found , Default storage )
Create symbolic connection ：
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
------------------------------------------------------------------------------------------------------------
modify Mysql User name and password ：
---- When you don't log in to the database , Input （ stay mysql Installation directory ）./bin/mysqladmin -p xxx password cx
among xxx It's the previous password ,cx It's the revised password
Then there will be a warning
Warning: Using a password on the command line interface can be insecure. This means that the change has been successful . Common mistakes ：
Mistake 1 ： With the original password, you have logged in to mysql 了 , If you change it again, you will report an error . Must pay attention to , Directly in the terminal , Change before login .
Mistake 2 ： take -p123456 It's written in -p 123456. That will give you an error ,-p No space is allowed after .
Mistake 3 ：password There's a... In front “-”. It's also a mistake .
----------------------------------------
adopt Navicat Premium Connect to database
---- There may be mistakes 1
Error1: 2003:Can't connect to MySQL server on 'localhost'
Solve the closure linux A firewall ：
chkconfig iptables off
reboot
----- error 2
Error2: 1130 - Host'ClientIP' is not allowed to connect to this MySQL server
solve ： Sign in mysql
stay linux command ：grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
This command allows all root user , Input password Log in to mysql server.
% Is to represent all host users , Can be modified to a single ip（192.168.1.1 Only this is allowed ip visit ）
-------------------------------
Next is the question of use , When I was using it, I encountered DML operation failed , Then I found out linux The case requirements for letters in are very strict ,
So in windows There's no problem developing and using it under , however linux There will be errors in .
stay windows This should also be noted during development , Try to unify the format . Especially in the database , Tables in the database are lowercase ,
But we are window Visit in the environment mysql It does not require case .
---------------------- There is another important issue , That's when I query in Chinese , There will be no data ,
stay window Here you can get . I went to know the relevant knowledge again , Find me in linux Installation on mysql The character set is not set up when ,
In other words, the character set does not use utf8. Now let's modify ：
Sign in mysql View use SHOW VARIABLES LIKE ‘character%’; Next character set , It is shown as follows ：
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
We'll find that database and server All are lantin1, Not at all utf8
We can modify mysql Medium my.cnf file ,linux command ; vi /usr/local/mysql/my.cnf
And then add in ：
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
character-set-server=utf8
[mysql]
no-auto-rehash
default-character-set=utf8
among mysql and mysqld It's different
restart mysql service service mysql restart
