安装mysql二进制文件_mysql二进制文件安装

1. 先把安装包拷贝到服务器始中

将以下文件通过传输软件(如sftp)放入到服务器目录下。

文件包含(如下4个)

mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

libaio-0.3.109-13.el7.x86_64.rpm 依赖包

libaio-devel-0.3.109-13.el7.x86_64.rpm 依赖包

my.cnf 配置文件

2. 创建mysql存放目录

mkdir /usr/local/mysql

3. 解压文件到之前创建的目录

tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysql --strip-components=1

4. 创建mysql用户

useradd -M -s /sbin/nologin mysql

5. 修改mysql目录用户所有者

chown -R mysql.mysql /usr/local/mysql

6. 安装依赖包

rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm libaio-devel-0.3.109-13.el7.x86_64.rpm

7. 创建日志目录和日志文件

mkdir /usr/local/mysql/log

chown mysql.mysql /usr/local/mysql/log

8. 对mysql进行初始化

cd /usr/local/mysql

bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize

执行初始化之后记住最后一行出现的随机密码，之后登录mysql需要使用

9. 复制系统脚本

cp support-files/mysql.server /etc/init.d/mysql

10. 增加环境变量并载入

echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile

source /etc/profile

11. 编写my.cnf并拷贝my.cnf到/etc/my.cnf

vim my.cnf

[mysqld]

datadir=/usr/local/mysql/data

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

lower_case_table_names=1

user=mysql

max_allowed_packet=1024M

innodb_file_per_table=1

table_open_cache=256

query_cache_type=1

query_cache_size=265MB

binlog_cache_size=4MB

key_buffer_size=512MB

bulk_insert_buffer_size=32MB

max_connections=1000

wait_timeout=300

back_log=256

max_sort_length=3000

innodb_log_file_size=2048M

innodb_log_buffer_size=16MB

innodb_max_dirty_pages_pct=90

innodb_buffer_pool_size=4096M

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

character_set_server=utf8

skip-name-resolve

[mysqld_safe]

log-error=/usr/local/mysql/log/mysqld.log

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

[client]

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

mv my.cnf /etc/

12、启动

service mysql start

注意：

如果启动报错，说明没有相应的文件，我们创建后，并且给与相应的属组就可以了

touch /usr/local/mysql/log/mysqld.log

touch /usr/local/mysql/data/localhost.localdomain.pid

chown mysql:mysql /usr/local/mysql/log/mysqld.log

chown mysql:mysql /usr/local/mysql/data/localhost.localdomain.pid

service mysql restart

13. 使用mysql客户端进入

14. 修改密码,并重新登录

alter user user() identified by '123456';

15. 开启root远程登录

mysql>use mysql;

mysql>update user set host='%' where user = 'root';

mysql>flush privileges;

16. 设置开机自启

设置开机自启：chkconfig mysql on

开启：service mysql start

关闭：service mysql stop

查看状态：service mysql status