1.下载
cd /usr/local
wget http://linux.wuzhanzhou.com/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
2.解压
tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz
cp -r mysql-5.6.33-linux-glibc2.5-x86_64/* /usr/local/mysql
3.添加用户组和用户
groupadd mysql
useradd -g mysql mysql
4.data下创建文件夹
cd /usr/local/mysql/data
mkdir mysql
5.mysql文件夹权限
chown -R mysql:mysql /usr/local/mysql/*
6.安装(mysql文件夹下)
./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql
首次安装可能会报错:
1. --Data::Dumper。 执行:yum -y install autoconf即可。
2. --error while loading shared libraries: libaio.so.1。执行:yum install libaio-devel.x86_64即可。
7.配置文件
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
cp support-files/my-default.cnf /etc/my.cnf
输入:yes
8.修改启动脚本
vi /etc/init.d/mysqld
修改项:
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/mysql
9.配置环境变量
vim /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
10.启动服务
#启动mysql
service mysqld start
service mysqld stop
service mysqld status
或者使用如下命令操作mysql:
systemctl restart mysqld.service
systemctl start mysqld.service
systemctl stop mysqld.service
# 加入开机自启
chkconfig --add mysqld
chkconfig mysqld on
11.远程连接
mysql -uroot
use mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
12.修改端口号
vim /etc/my.cnf
[mysqld]
port=35066
查看端口号:
> mysql;
>show global variables like 'port';