linux安装mysql数据库

1、下载mysql源安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm#

2、安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm

3、检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"

4、安装mysql
yum install mysql-community-server

5、启动mysql
service mysqld start

6、获取默认密码
mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码
grep 'temporary password' /var/log/mysqld.log

7、登录mysql
mysql -uroot -pmysql

8、修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码'
或者
set PASSWORD=PASSWORD('密码')

9、修改mysql配置文件
vim /etc/my.cnf

# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character_set_server=utf8
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
lower_case_table_names = 1

max_connections=1000
sort_buffer_size=8M
query_cache_size=256M
query_cache_type=0
table_open_cache=6000
thread_cache_size=400
innodb_buffer_pool_size=6G
innodb_buffer_pool_instances=8
innodb_log_file_size=512M
innodb_log_files_in_group=4
bulk_insert_buffer_size=64M
max_allowed_packet=20M
innodb_log_buffer_size=800M
innodb_strict_mode=0
innodb_thread_concurrency=16
innodb_io_capacity=500
innodb_flush_log_at_trx_commit=2
tmp_table_size = 512M

max_length_for_sort_data=8192
join_buffer_size = 4M
innodb_print_all_deadlocks = 1
binlog_cache_size = 10M
binlog_stmt_cache_size=10M
innodb_lock_wait_timeout=300

10、创建新用户
create user factor@'%' identified by 'Admin@666'

11、给用户赋权限
grant all on *.* to factor@'%'