1、新建用户组和用户
1groupadd mysql 2useradd mysql -g mysql
2、解压Mysql软件包
tar -zxvf /data/soft/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /data/webserver
3、重命名解压后的文件夹
1cd /data/webserver 2mv mysql-5.7.18-linux-glibc2.5-x86_64 mysql
4、创建数据目录
1mkdir data 2chown -R mysql:mysql /data/webserver/mysql/ 3chmod -R 755 /data/webserver/mysql/
5、初始化数据库
1cd /data/webserver 2./bin/mysqld --user=mysql --basedir=/data/webserver/mysql --datadir=/data/webserver/mysql/data --initialize
执行完命令后，会看到如下输出信息，注意记住root密码，后续步骤需要用到。
6、数据库配置-mysqld
1cp /data/webserver/mysql/support-files/mysql.server /etc/init.d/mysqld 2chmod 755 /etc/init.d/mysqld 3vi /etc/init.d/mysqld
修改/etc/init.d/mysqld文件，正确设置basedir,datadir。
7、配置数据库-my.cnf
在/etc目录下创建my.cnf配置文件。
vi /etc/my.cnf
my.cnf配置文件内容如下：
1# For advice on how to change settings please see 2# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html 3 4[mysqld] 5 6# Remove leading # and set to the amount of RAM for the most important data 7# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. 8# innodb_buffer_pool_size = 128M 9 10# Remove leading # to turn on a very important data integrity option: logging 11# changes to the binary log between backups. 12# log_bin 13 14# These are commonly set, remove the # and set as required. 15# basedir = ..... 16basedir=/data/webserver/mysql 17# datadir = ..... 18datadir=/data/webserver/mysql/data 19# port = ..... 20# server_id = ..... 21# socket = ..... 22#socket=/tmp/mysql.sock 23 24# Remove leading # to set options mainly useful for reporting servers. 25# The server defaults are faster for transactions and fast SELECTs. 26# Adjust sizes as needed, experiment to find the optimal values. 27# join_buffer_size = 128M 28# sort_buffer_size = 2M 29# read_rnd_buffer_size = 2M 30 31sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 32ft_min_word_len = 1 33innodb_buffer_pool_size = 6G 34innodb_buffer_pool_instances = 8 35innodb_buffer_pool_load_at_startup = 1 36innodb_buffer_pool_dump_at_shutdown = 1 37innodb_lru_scan_depth = 2000 38innodb_lock_wait_timeout = 5 39innodb_io_capacity = 4000 40innodb_io_capacity_max = 8000 41innodb_flush_method = O_DIRECT 42innodb_file_format = Barracuda 43innodb_file_format_max = Barracuda 44innodb_undo_logs = 128 45innodb_flush_neighbors = 1 46innodb_log_file_size = 4G 47innodb_log_buffer_size = 16777216 48innodb_purge_threads = 4 49innodb_large_prefix = 1 50innodb_thread_concurrency = 64 51innodb_print_all_deadlocks = 1 52innodb_strict_mode = 1 53innodb_sort_buffer_size = 67108864
8、修改密码
1/data/webserver/mysql/bin/mysql -uroot -p 2SET PASSWORD = PASSWORD('123456'); 3grant all privileges on *.* to root@'%' identified by '123456'; 4flush privileges;
9、启动数据库
service mysqld start