下载地址： https://dev.mysql.com/downloads/mysql
实验一： linux 使用rpm包安装MySQL5.6
需要介质: MySQL-devel-5.6.20-1.el6.x86_64.rpm MySQL-server-5.6.20-1.el6.x86_64.rpm MySQL-client-5.6.20-1.el6.x86_64.rpm
rpm -qa| grep mysql
mount /dev/cdrom /mnt yum install perl -y
rpm -ivh MySQL-devel-5.6.20-1.el6.x86_64.rpm rpm -ivh MySQL-client-5.6.20-1.el6.x86_64.rpm rpm -ivh MySQL-server-5.6.20-1.el6.x86_64.rpm
service mysql start
临时密码 /root/.mysql_secret
/usr/bin/mysql_secure_installation
实验二： linux6上使用二进制包安装MySQL5.6
需要介质: mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz
1.修改主机名 hostname master vi /etc/sysconfig/network
2.关闭防火墙 service iptables stop chkconfig iptables off chkconfig --list iptables
3.关闭selinux vi /etc/selinux/config
4.安装rpm包(libaio必须)
vi /etc/yum.repos.d/dvd.repo [dvd] name=dvd baseurl=file:///mnt enable=1 gpgcheck=0
mount /dev/cdrom /mnt yum install -y gcc* gcc-c++ ncurses* ncurses-devel* cmake* make* perl* bison* libaio-devel* libgcrypt*
5.修改内核参数 vi /etc/security/limits.conf
mysql soft nproc 2047 mysql hard nproc 16384 mysql soft nofile 1024 mysql hard nofile 65536
vi /etc/pam.d/login
session required pam_limits.so
vi /etc/profile
if [ /$USER = "mysql" ]; then if [ /$SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi
6.创建用户 groupadd -g 1001 mysql useradd -u 1001 -g mysql mysql echo 'mysql' | passwd --stdin mysql
7.创建安装目录 mkdir -p /usr/local/mysql mkdir -p /var/lib/mysql
8.上传介质并解压 tar -zxvf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz cd mysql-5.6.40-linux-glibc2.12-x86_64 mv * /usr/local/mysql chown -R mysql:mysql /usr/local/mysql chown -R mysql:mysql /var/lib/mysql/
9.初始化数据库
MySQL5.6 /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/var/lib/mysql
MySQL5.7/8.0 /usr/local/mysql/bin/mysqld --initialize(--initialize-insecure) --user=mysql --basedir=/usr/local/mysql --datadir=/var/lib/mysql
10.创建配置文件 vi /etc/my.cnf
[mysqld] port = 3306 basedir = /usr/local/mysql datadir = /var/lib/mysql
character-set-server = utf8 max_connections= 100 innodb_buffer_pool_size = 104857600
11.添加变量，并使之生效 echo 'export PATH=/usr/local/mysql/bin:$PATH' >>/etc/profile source /etc/profile echo $PATH
12.拷贝mysqld服务(可选) cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld
13.启动数据库 service mysqld start
14.开机自启动(可选)
chkconfig --add mysqld chkconfig mysqld on chkconfig mysqld --list
实验三： 数据库的多种启动方式 1.服务 service mysqld start
2.mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &
3.mysqld --defaults-file=/etc/my.cnf --user=mysql &
实验四： 数据库的多种关闭方式 1.服务 service mysqld stop
2. mysqladmin -uroot -pmysql shutdown
