以下操作为针对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
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;
>>>>>>>>>>>>>>>>>更新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;