centos6.7下安装64位mysql5.5压缩版

下载

1. 打开https://dev.mysql.com/downloads/mysql/5.5.html#downloads
2. 选择下载Linux-Generic中mysql-5.5.61-linux-glibc2.12-x86_64.tar.gz

安装

1. 解压：tar -zxvf mysql-5.5.61-linux-glibc2.12-x86_64.tar.gz;
2. 移动到想要安装的位置：比如 /usr/local/下
   mv mysql-5.5.61-linux-glibc2.12-x86_64.tar.gz /usr/local/mysql;
3. 创建mysql用户和组
   #添加mysql组
   groupadd mysql
   #添加mysql用户
   useradd mysql
4. 安装数据库
   #进入mysql目录
   cd /usr/local/mysql;
   #修改当前目录的拥有者为mysql用户
   chown -R mysql:mysql ./;
   #执行下面语句安装
   ./script/mysql_inistall_db
   –basedir=/usr/local/mysql
   –datadir=/usr/local/mysql/data
   –user=mysql
5. 配置为服务
   cp support-files/mysql.server /etc/init.d/mysql
   #配置成服务并开机自启动
   chkconfig --add mysql
   #启动mysql
   service mysql start
6. 修改root密码
   ./bin/mysqladmin -u root password newpassword;
7. 使得非localhost用户能够远程访问mysql
   GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
   flush privileges;
8. 修改mysql编码
   SHOW GLOBAL VARIABLES LIKE ‘%character_set%’;
   set global character_set_database=utf8;
   set global character_ser_server=utf8;
9. 配置环境变量
   vim /etc/profile
   写入export PATH=$PATH:/usr/local/mysql/bin
   然后执行: source /etc/profile，让修改生效

参考：https://blog.youkuaiyun.com/u012383839/article/details/53024899