Linux学习 (4) 安装mysql

#UNINSTALL MYSQL PACKAGES
yum remove mysql mysql-server


#ROMOVE MYSQL DIRECTORY
mv /var/lib/mysql /var/lib/mysql_bkup


Installing mysql 5.7 on centos 6

1. download yum repo
    wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm

2. install yum repo
    yum -y localinstall mysql57-community-release-el6-7.noarch.rpm

3. verify yum repo
    yum repolist enabled | grep "mysql.*-community.*"

3a. to enable/disable a particular release
# yum-config-manager --disable mysql57-community
# yum-config-manager --enable mysql56-community


4. install 
    yum -y install mysql-community-server --nogpgcheck
    service mysqld start
    service mysqld status
    mysql --version


5. securing the installation
    grep 'temporary password' /var/log/mysqld.log
    mysql_secure_installation --> follow the prompts
        remove anonymouse users
        disallow root remote login


6. Login
   mysql -u root -p
　　#在提示Enter password中，输入步骤5 grep的密码

7.reset default password
  set password for root@localhost = password('123');



8. 检查MySQL是否开机自动启动
    chkconfig --list | grep mysqld


9. 设置MySQL开启自动启动

　　chkconfig mysqld on


　　
Useful links:
http://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
http://www.tecmint.com/install-latest-mysql-on-rhel-centos-and-fedora/

　　配置MySQL

# For advice on how to change settings please see 
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html 
[mysqld] 
# 
# Remove leading # and set to the amount of RAM for the most important data 
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 
# innodb_buffer_pool_size = 128M 
# 
# Remove leading # to turn on a very important data integrity option: logging 
# changes to the binary log between backups. 
# log_bin 
# 
# Remove leading # to set options mainly useful for reporting servers. 
# The server defaults are faster for transactions and fast SELECTs. 
# Adjust sizes as needed, experiment to find the optimal values. 
# join_buffer_size = 128M 
# sort_buffer_size = 2M 
# read_rnd_buffer_size = 2M 
datadir=/data1/mysql 
socket=/var/lib/mysql/mysql.sock 
# Disabling symbolic-links is recommended to prevent assorted security risks 
symbolic-links=0 
log-error=/var/log/mysqld.log 
pid-file=/var/run/mysqld/mysqld.pid 
max_connections=40960 
innodb_buffer_pool_size=100G 
innodb_log_files_in_group=5 
innodb_log_file_size=1G 
innodb_buffer_pool_instances=32 
innodb_flush_neighbors=1 
table_open_cache=81920 
table_open_cache_instances=64 
thread_cache_size=320 
open_files_limit=65535 
innodb_open_files=65535 
innodb_page_size=16k 
innodb_io_capacity=20000 
innodb_io_capacity_max=50000 
innodb_old_blocks_pct=38 
innodb_old_blocks_time=1000 
innodb_read_ahead_threshold=56 
innodb_random_read_ahead=OFF 
innodb_buffer_pool_dump_pct=25 
bulk_insert_buffer_size=800m 
innodb_flush_log_at_trx_commit=0 
sync_binlog=0 
[client] 
socket=/var/lib/mysql/mysql.sock 
#socket=/data1/mysql/mysql.sock