======= Install the TAR package using the source code, without installing--mysql-5.6.23 for centos6.5_64bit=== @guoyJoe

Reprint Please specify source:http://blog.csdn.net/guoyjoe/article/details/44836547

First, on the basis of the source installation: I hit a tar package:
Cd/u01/myss06
Tar cvzf My3306.tar.


Second, close the firewall
Chkconfig iptables off
Service Iptables Stop


Vi/etc/selinux/config
Selinux=disabled


Third, check if MySQL is installed on the operating system
[[email protected] backup]# rpm-qa |grep MySQL
Qt-mysql-4.6.2-26.el6_4.x86_64
Mysql-5.1.71-1.el6.x86_64
Mysql-server-5.1.71-1.el6.x86_64
Mysql-devel-5.1.71-1.el6.x86_64
Mysql-libs-5.1.71-1.el6.x86_64


Iv. Delete myql (redhat6.3 server comes with Mysql-libs is mysql-libs-5.1.61-4.el6.x86_64, may conflict with a higher version of Mysql-libs)
Yum Remove Mysql-libs


V. Make sure the MySQL related package is completely deleted
[[email protected] backup]# rpm-qa |grep MySQL


Vi. adding users and groups:
ID MySQL
Userdel-r MySQL
Groupadd MySQL#增加用户组
useradd-d/home/mysql-g MySQL MySQL


Seven, with the MySQL environment variable
Su-mysql
VI. bash_profile
Path= $PATH: $HOME/bin:/u01/my3306/bin


source. bash_profile




Eight, decompression
cd/u01/my3306
TAR-ZXVF My3306.tar




Nine, in the journal will be reported in the RSA report the following error:


RSA private key file not found:/u01/my3306/data//private_key.pem. Some authentication plugins won't work.
RSA public key file not found:/u01/my3306/data//public_key.pem. Some authentication plugins won't work.


Workaround:

1. Check if OpenSSL is installed
$rpm-qa OpenSSL
Openssl-1.0.0-20.el6_2.5.x86_64


2. Generate public and private keys using OpenSSL
$ OpenSSL genrsa-out Mykey.pem 1024
Generating RSA private key, 1024x768 bit long modulus
..........++++++
.++++++
E is 65537 (0x10001)




$ OpenSSL rsa-in mykey.pem-pubout-out mykey.pub
Writing RSA Key


$ ll mykey*
[email protected] my3306]# ll mykey*
-rwxr-xr-x 1 root root 891 Apr 1 20:35 Mykey.pem
-rwxr-xr-x 1 root root 272 Apr 1 20:35 mykey.pub


X. Initializing MySQL Scripts
./scripts/mysql_install_db--defaults-file=/u01/my3306/my.cnf--datadir=/u01/my3306/data--user=mysql


Xi. start MySQL
Vi. bash_profile---Root user add
Path= $PATH: $HOME/bin:/u01/my3306/bin


Mysqld_safe--defaults-file=/u01/my3306/my.cnf--user=mysql &


[Email protected] ~]# Su-mysql
[Email protected] ~]$ Mysql-h127.0.0.1-uroot
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 2
Server Version:5.6.23-log Source Distribution


Copyright (c), Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.


Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.


mysql> show databases;
+--------------------+
| Database |
+--------------------+
| Information_schema |
| MySQL |
| Performance_schema |
| Test |
+--------------------+
4 rows in Set (0.15 sec)


Mysql> Show variables like '%log% ';
+-----------------------------------------+-------------------------------------+
| variable_name | Value |
+-----------------------------------------+-------------------------------------+
| Back_log | 900 |
| Binlog_cache_size | 32768 |
| Binlog_checksum | CRC32 |
| Binlog_direct_non_transactional_updates | OFF |
| binlog_error_action | Ignore_error |
| Binlog_format | ROW |
| Binlog_gtid_simple_recovery | OFF |
| Binlog_max_flush_queue_time | 0 |
| Binlog_order_commits | On |
| Binlog_row_image | Full |
| binlog_rows_query_log_events | OFF |
| Binlog_stmt_cache_size | 32768 |
| Binlogging_impossible_mode | Ignore_error |
| Expire_logs_days | 7 |
| General_log | OFF |
| General_log_file | /u01/my3306/data/mydb3.log |
| Innodb_api_enable_binlog | OFF |
| Innodb_flush_log_at_timeout | 1 |
| Innodb_flush_log_at_trx_commit | 1 |
| Innodb_locks_unsafe_for_binlog | OFF |
| Innodb_log_buffer_size | 67108864 |
| Innodb_log_compressed_pages | On |
| Innodb_log_file_size | 1048576000 |
| Innodb_log_files_in_group | 4 |
| Innodb_log_group_home_dir | /u01/my3306/log/iblog |
| innodb_mirrored_log_groups | 1 |
| Innodb_online_alter_log_max_size | 134217728 |
| Innodb_undo_logs | 128 |
| Log_bin | On |
| Log_bin_basename | /u01/my3306/log/binlog/binlog |
| Log_bin_index | /u01/my3306/log/binlog/binlog.index |
| log_bin_trust_function_creators | OFF |
| log_bin_use_v1_row_events | OFF |
| Log_error | /u01/my3306/log/alert.log |
| Log_output | FILE |
| log_queries_not_using_indexes | On |
| Log_slave_updates | On |
| log_slow_admin_statements | On |
| log_slow_slave_statements | OFF |
| log_throttle_queries_not_using_indexes | 0 |
| log_warnings | 1 |
| Max_binlog_cache_size | 2147483648 |
| Max_binlog_size | 524288000 |
| Max_binlog_stmt_cache_size | 18446744073709547520 |
| Max_relay_log_size | 0 |
| Relay_log | /u01/my3306/log/relaylog |
| Relay_log_basename | /u01/my3306/log/relaylog |
| Relay_log_index | /u01/my3306/log/relay.index |
| Relay_log_info_file | /u01/my3306/log/relay-log.info |
| Relay_log_info_repository | FILE |
| Relay_log_purge | On |
| Relay_log_recovery | OFF |
| Relay_log_space_limit | 0 |
| Simplified_binlog_gtid_recovery | OFF |
| Slow_query_log | On |
| Slow_query_log_file | /u01/my3306/log/slow.log |
| Sql_log_bin | On |
| Sql_log_off | OFF |
| Sync_binlog | 100 |
| Sync_relay_log | 10000 |
| Sync_relay_log_info | 10000 |
+-----------------------------------------+-------------------------------------+
All rows in Set (0.02 sec)






***********************************************************************************************************
In the installation process may be error, generally look at the log
Tail-f/u01/my3306/log/alert.log


In execution: Mysqld_safe--defaults-file=/u01/my3306/my.cnf--user=mysql &
1, Error 1:
2015-04-02 19:18:00 4201 [Note] RSA private key file not found:/u01/my3306/data//private_key.pem. Some authentication plugins won't work.


Solve:
Modify the configuration in the my.cnf to comment out the following two lines
[Mysqld]
#sha256_password_private_key_path =/u01/my3306/mykey.pem
#sha256_password_public_key_path =/u01/my3306/mykey.pub

2, re-execute Mysqld_safe--defaults-file=/u01/my3306/my.cnf--user=mysql &
Error 2:
2015-04-02 19:23:36 6109 [ERROR] Can ' t find messagefile '/u01/my3306/share/mysql/errmsg.sys '
Copy the/bak/share/english/errmsg.sys from the source package to the/u01/my3306/share/mysql/errmsg.sys
Scp/bak/share/english/errmsg.sys 192.168.1.18:/u01/my3306/share/mysql/errmsg.sys


Get!!!!

======= Install the TAR package using the source code, install--mysql-5.6.23 for [email protected]