chown -R mysql:mysql /usr/local/mysql/data
一.MySQL版本选择的潜规则 5.6:GA 6-12个月 并且小版本是偶数版 5.7:GA 6-12个月 并且小版本是偶数版 5.7.17 以上版本,(MGR自带的高可用) 二.二进制安装MySQL 1.下载 [root@web01 ~]# wget https://downloads.mysql.com/archives/get/file/mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz 2.解压 [root@oldboy ~]# tar xf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz 3.移动到安装目录 [root@oldboy ~]# mv mysql-5.6.40-linux-glibc2.12-x86_64 /usr/local/mysql-5.6.40 4.软链接 [root@oldboy ~]# ln -s /usr/local/mysql-5.6.40 /usr/local/mysql 5.进入MySQL程序目录 [root@oldboy ~]# cd /usr/local/mysql 6.拷贝配置文件 [root@oldboy /usr/local/mysql/support-files]# cp my-default.cnf /etc/my.cnf 7.拷贝启动脚本 [root@oldboy /usr/local/mysql/support-files]# cp mysql.server /etc/init.d/mysqld 8.创建mysql用户 [root@oldboy /usr/local/mysql/support-files]# useradd mysql -s /sbin/nologin -M 9.进入mysql初始化目录 [root@oldboy /usr/local/mysql]# cd scripts/ 10.安装依赖包 [root@oldboy /usr/local/mysql/scripts]# yum install -y libaio-devel 11.初始化mysql [root@oldboy /usr/local/mysql/scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 12.添加环境变量 [root@oldboy /usr/local/mysql/scripts]# vi /etc/profile export PATH="/usr/local/mysql/bin:$PATH" 13.加载环境变量 [root@oldboy /usr/local/mysql/scripts]# source /etc/profile 14.启停MySQL 启动:[root@oldboy /usr/local/mysql/scripts]# /etc/init.d/mysqld start 停止:[root@oldboy /usr/local/mysql/scripts]# /etc/init.d/mysqld stop 15.连接MySQL [root@oldboy /usr/local/mysql/scripts]# mysql 16.设置MySQL密码 [root@oldboy /usr/local/mysql/scripts]# mysqladmin -uroot -p password '123' 17.修改密码 [root@oldboy /usr/local/mysql/scripts]# mysqladmin -uroot -p123 password '1' [root@oldboy /usr/local/mysql/scripts]# mysql -uroot -p1 三.MySQL的物理结构 MySQL的物理结构就是最底层的数据文件 四.开发规范 库名,表名,小写