源码安装mysql 5.6.33版本

以下操作为针对mysql 5.6.33版本的 源码安装方式，主要步骤

>>>>>>>>>>>>>编译>>>>>>>>>>>>>>>>>>>>>>>>>>

cmake \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_DATADIR=/usr/local/mysql/data/mysql \

-DMYSQL_USER=mysql \

-DMYSQL_TCP_PORT=3306 \

-DENABLE_DOWNLOADS=1


make && make install

>>>>>>>>>>>>初始化数据库>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/mysql.pid --tmpdir=/tmp

 

>>>>>>>my.cnf配置>>>>>>>>>>>>>>>>>>>>>>>

[client]

port = 3306

socket = /usr/local/mysql/mysql.sock

 [mysqld]

character-set-server = utf8

collation-server = utf8_general_ci

 skip-external-locking

skip-name-resolve

 user = mysql

port = 3306

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

tmpdir = /usr/local/mysql/temp

# server_id = .....

socket = /usr/local/mysql/mysql.sock

log-error = /var/log/mysql/mysql_error.log

pid-file = /usr/local/mysql/mysql.pid

 open_files_limit = 10240

 back_log = 600

max_connections=500

max_connect_errors = 6000

wait_timeout=605800

 #open_tables = 600

#table_cache = 650

#opened_tables = 630

 max_allowed_packet = 32M

 sort_buffer_size = 4M

join_buffer_size = 4M

thread_cache_size = 300

query_cache_type = 1

query_cache_size = 256M

query_cache_limit = 2M

query_cache_min_res_unit = 16k

 tmp_table_size = 256M

max_heap_table_size = 256M

 key_buffer_size = 256M

read_buffer_size = 1M

read_rnd_buffer_size = 16M

bulk_insert_buffer_size = 64M

 lower_case_table_names=1

 default-storage-engine = INNODB

 innodb_buffer_pool_size = 2G

innodb_log_buffer_size = 32M

innodb_log_file_size = 128M

innodb_flush_method = O_DIRECT

 #####################

thread_concurrency = 32

long_query_time= 2

slow-query-log = on

slow-query-log-file = /var/log/mysql/mysql-slow.log

 [mysqldump]

quick

max_allowed_packet = 32M

 [mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

>>>>>>>>>>>>>>>>>更新root密码>>>>>>>>>>

安全期间，设置只允许localhost访问
update user set Password = password('password') where User='root' and host='localhost';
flush privileges;

>>>>>>>>>>>>>用户&权限>>>>>>>>>>>>>>>>>>

 insert into mysql.user(Host,User,Password) values("%","dtstest",password("tYe1qEtFtqkEJY4y"));

赋权限
grant all privileges on ads_ds.* to user@"%" identified by 'tYe1qEtFtqkEJY4y';

flush privileges;