参考:https://www.cnblogs.com/bookwed/p/5896619.html?tdsourcetag=s_pctim_aiomsg
1.下载
可以直接复制64位的下载地址,通过命令下载:
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/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
#复制解压后的mysql目录,/usr/local/mysql需要root权限才能访问
cp
-r mysql-5.6.33-linux-glibc2.5-x86_64
/usr/local/mysql
3.添加用户组和用户
#添加用户组
groupadd mysql
#添加用户mysql 到用户组mysql
useradd
-g mysql mysql
4.安装
cd
/usr/local/mysql
mkdir
.
/data/mysql
chown
-R mysql:mysql ./
.
/scripts/mysql_install_db
--user=mysql --datadir=
/usr/local/mysql/data/mysql
(遇到了
Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory)
解决方案:sudo apt-get install libaio1 (https://blog.csdn.net/ty0415/article/details/22958133)
cp
support-files
/mysql
.server
/etc/init
.d
/mysqld
chmod
755
/etc/init
.d
/mysqld
cp
support-files
/my-default
.cnf
/etc/my
.cnf
#修改启动脚本
vi
/etc/init
.d
/mysqld
#修改项:
basedir=
/usr/local/mysql/
datadir=
/usr/local/mysql/data/mysql
#启动服务
service mysqld start
(遇到问题:Failed to start mysqld.service: Unit mysqld.service not found.
解决方案:sudo apt-get install mysql-server
To check that service is running use: ps -ef | grep mysql | grep -v grep
)
#测试连接
.
/mysql/bin/mysql
-uroot
(遇到问题:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
解决方案:
1)创建连接文件到指定目录上 ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
2)测试连接成功登陆 mysql -u root -p
Enter password: (我输的是mysql123456,忘了之前有没有设置过这个密码)
注:mysql退出三种方法:
mysql > exit;
mysql > quit;
mysql > \q;</span></span>
)
#加入环境变量,编辑 /etc/profile,这样可以在任何地方用mysql命令了
vi
/etc/profile
在文件末尾加上
export
PATH=$PATH:
/usr/local/mysql/bin
运行命令
source /etc/profile使其生效
#启动mysql
service mysqld start
#关闭mysql
service mysqld stop
#查看运行状态
service mysqld status