MySQL_5.5.32 二进制包安装
2019-10-06 本文已影响0人
DB哥
Linux系统环境
[root@nginx01 ~]# cat /etc/redhat-release #==》系统版本
CentOS release 6.7 (Final)
[root@nginx01 ~]# uname –r #==》内核版本
2.6.32-573.el6.x86_64
[root@nginx01 ~]# uname -m #==》系统架构
x86_64
[root@nginx01 ~]# echo $LANG #==》系统字符集
en_US.UTF-8
[root@nginx01 www]# mysql –V #==》mysql版本
mysql Ver 14.14 Distrib 5.5.32, for linux2.6 (x86_64) using readline 5.1
MySQL配置文件
提示:/application/mysql是MySQL程序目录
#==》MySQL启动脚本,一般复制到/etc/init.dmysqld
/application/mysql/support-files/mysql.server
#==》MySQL主配置文件,一 般复制到/etc/my.cnf
/application/mysql/support-files/my-small.cnf /etc/my.cnf
#==》MySQL所有二进制命令存放目录,一般复制到/usr/local/sbin目录下
/application/mysql/bin/
#==》MySQL错误日志
/application/mysql/data/nginx01.err
一、解压mysql二进制安装包
标注:MySQL5.5.32官方下载地址
https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz
[root@nginx01 tools]# mkdir -p /root/tools #==》创建存放软件的目录
[root@nginx01 tools]# ls -l /root/tools/ #==》查看上传的mysql安装包
-rw-r--r-- 1 root root 186722932 May 15 08:37 mysql-5.5.32-linux2.6-x86_64.tar.gz
[root@nginx01 tools]#tar –zxf mysql-5.5.32-linux2.6-x86_64.tar.gz #==》解压
[root@nginx01 tools]# ls -l /root/tools/ #==》检查
total 183368
drwxr-xr-x 13 root root 4096 Jun 25 14:01 mysql-5.5.32-linux2.6-x86_64
-rw-r--r-- 1 root root 186722932 May 15 08:37 mysql-5.5.32-linux2.6-x86_64.tar.gz
二、安装mysql前准备工作
[root@nginx01 tools]# useradd -s /sbin/nologin -M mysql #==》创建mysql虚拟用户
[root@nginx01 tools]# tail -1 /etc/passwd #==》检查
mysql:x:502:502::/home/mysql:/sbin/nologin
[root@nginx01 tools]# mkdir -p /application/
[root@nginx01 tools]# mv /root/tools/mysql-5.5.32-linux2.6-x86_64 /application/mysql #==》mysql安装文件目录移动到指定目录
[root@nginx01 tools]# cd /application/mysql/
[root@nginx01 mysql]# ls
bin COPYING data docs include INSTALL-BINARY lib man mysql-test README scripts share sql-bench support-files
[root@nginx01 mysql]# mkdir -p /application/mysql/data #==》创建mysql的data目录
[root@nginx01 mysql]# chown -R mysql.mysql /application/mysql/data #==》递归修改data目录用户和用户组
[root@nginx01 mysql]# ls -ld /application/mysql/data #==》检查
drwxr-xr-x 3 mysql mysql 4096 Jun 25 14:01 /application/mysql/data
[root@nginx01 mysql]# ls -l /application/mysql/data
total 4
drwxr-xr-x 2 mysql mysql 4096 Jun 25 14:01 test
三、安装mysql并启动
[root@nginx01 mysql]# cd /application/mysql/
[root@nginx01 mysql]# pwd
/application/mysql
[root@nginx01 mysql]# ./scripts/mysql_install_db --user=mysql --basedir=/application/mysql/ --datadir=/application/mysql/data/ #==》初始化mysql
[root@nginx01 mysql]# /bin/cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld #==》复制mysql启动文件到/etc/init.d目录下
[root@nginx01 mysql]# /bin/cp /application/mysql/support-files/my-small.cnf /etc/my.cnf #==》复制mysql配置文件到/etc/my.cnf
[root@ nginx01 mysql]# cp /application/mysql/bin/* /usr/local/sbin/ #==》复制mysql相关命令到环境变量PATH指定的目录下
[root@nginx01 mysql]# vim /etc/init.d/mysqld #==》修改mysqld启动文件添加如下内容
basedir=/application/mysql
datadir=/application/mysql/data
[root@nginx01 mysql]# grep -E "^basedir=|^datadir=" /etc/init.d/mysqld
basedir=/application/mysql
datadir=/application/mysql/data
[root@nginx01 mysql]# /etc/init.d/mysqld start #==》启动mysql
Starting MySQL... SUCCESS!
四、测试mysql
[root@nginx01 mysql]# mysql #==》登录mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.32 MySQL Community Server (GPL)
Copyright (c) 2000, 2013, 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 clear the current input statement.
mysql>
[root@nginx01 mysql]# mysqladmin -u root password '123456' #==》设置mysql登录用户和密码
[root@nginx01 mysql]# mysql -uroot -p123456 #==》登录mysql
mysql> show databases; #==》查看mysql数据库
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.02 sec)
mysql> select user,host from mysql.user; #==》查看user表user和host字段
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| | localhost |
| root | localhost |
| | nginx01 |
| root | nginx01 |
+------+-----------+
6 rows in set (0.02 sec)
mysql> drop user 'root'@'::1'; #==》删除user表内的无效用户
Query OK, 0 rows affected (0.03 sec)
mysql> drop user ''@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> drop user ''@'nginx01';
Query OK, 0 rows affected (0.00 sec)
mysql> drop user 'root'@'nginx01';
Query OK, 0 rows affected (0.02 sec)
mysql> select user,host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | localhost |
+------+-----------+
2 rows in set (0.00 sec)