linux 二进制安装mysql_linux安装mysql二进制安装

linux系统centos 6.5，mysql版本5.5.60

所需安装包mysql-5.5.60-linux-glibc2.12-x86_64.tar.gz、ncurses-devel-5.7-4.20090207.el6.x86_64.rpm、libaio-devel-0.3.107-10.el6.x86_64.rpm

创建更新包目录，并将三个安装包上传至该目录下，赋予执行权限

[root@oldboy ~]# mkdir -p /home/oldboy/tools

[root@oldboy~]# cd /home/oldboy/tools

[root@oldboy tools]#chmod +x *[root@oldboy tools]# rpm-ivh --nodeps ncurses-devel-5.7-4.20090207.el6.x86_64.rpm

[root@oldboy tools]# rpm-ivh libaio-devel-0.3.107-10.el6.x86_64.rpm

创建用户和组、解压二进制mysql安装包、并创建软连接

[root@oldboy tools]# groupadd mysql

[root@oldboy tools]# useradd-M mysql -g mysql -s /sbin/nologin

[root@oldboy tools]#tar zxf mysql-5.5.60-linux-glibc2.12-x86_64.tar.gz

[root@oldboy tools]#mkdir -p /application/[root@oldboy tools]#mv mysql-5.5.60-linux-glibc2.12-x86_64 /application/mysql-5.5.60[root@oldboy tools]#ln -s /application/mysql-5.5.60/ /application/mysql

二进制安装mysql

[root@oldboy tools]# cd /application/mysql/scripts/[root@oldboy scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

…………………

Installing MySQL system tables...180724 15:59:23 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.180724 15:59:23 [Note] /application/mysql//bin/mysqld (mysqld 5.5.60) starting as process 48877 ...

OK

Filling help tables...180724 15:59:23 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.180724 15:59:23 [Note] /application/mysql//bin/mysqld (mysqld 5.5.60) starting as process 48884 ...

OK

…………………

Please report any problems at http://bugs.mysql.com/

将mysql的可执行文件bin目录加入PATH环境变量

[root@oldboy scripts]# echo 'export PATH=/application/mysql/bin:$PATH'>>/etc/profile

[root@oldboy scripts]# source/etc/profile

[root@oldboy scripts]#echo$PATH/application/mysql/bin:/application/mysql/bin:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

复制mysql配置文件和启动文件，

[root@oldboy scripts]# cd ..

[root@oldboy mysql]#mv /etc/my.cnf /etc/my.cnf.bak[root@oldboy mysql]#cp support-files/my-small.cnf /etc/my.cnf

[root@oldboy mysql]#cp support-files/mysql.server /etc/init.d/mysqld[root@oldboy mysql]#sed -i 's#/usr/local/mysql#/application/mysql#g' /etc/init.d/mysqld

[root@oldboy mysql]#chmod +x /etc/init.d/mysqld

启动mysql

[root@oldboy mysql]# /etc/init.d/mysqld start

Starting MySQL.Logging to'/application/mysql/data/oldboy.err'.

..[ OK ]

给root用户设置密码，并通过root登录mysql数据库

[root@oldboy ~]# /application/mysql//bin/mysqladmin -u root password 'oldboy'

[root@oldboy ~]# mysql -uroot -poldboy

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connectionid is 2Server version:5.5.60MySQL Community Server (GPL)

Copyright (c)2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type'help;' or 'h' for help. Type 'c' to clearthe current input statement.

mysql>show databases;+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| test |

+--------------------+

4 rows in set (0.00 sec)