可以通过编译安装,可以在gitlab获取源码,使用cmake,make编译安装。需要解决依赖主要是boost和bison。
yum install -y cmake make gcc gcc-c++ ncurses-devel bison
mkdir mysql-compile && cd mysql-compile
curl -o mysql-server-5.7.zip https://codeload.github.com/mysql/mysql-server/zip/5.7
unzip mysql-server-5.7.zip
mkdir mysql-5.7 && cd mysql-5.7
mkdir boost && cd boost && curl -O https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz && cd ..
cmake ../mysql-server-5.7/ -DWITH_BOOST=boost
make
make install
创建mysql用户组 useradd -s /sbin/nologin mysql
初始化mysql,会生成root初始化密码,注意保存 /usr/local/mysql/bin/mysqld --initialize --user=mysql
[Server] A temporary password is generated for root@localhost: a?!g(,=/W88k
/usr/local/mysql/bin/mysqld_safe --user=mysql &
修改root 密码为 123456 : alter user 'root'@'localhost' identified by "123456";
添加mysql远程登录账号 : mysql> create user root@'%' identified by '888888';
Query OK, 0 rows affected (0.02 sec)
mysql> grant all privileges on *.* to root@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
查看目前的帐号,有%的root账号表示远程登录账号配置成功
mysql> select user,host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)
mysql> quit
配置为系统服务并加入开机启动
[root@localhost ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@localhost ~]# chmod 755 /etc/init.d/mysqld
[root@localhost ~]# chkconfig --list|grep mysqld
[root@localhost ~]# chkconfig mysqld on
[root@localhost ~]# chkconfig --list|grep mysqld
mysqld 0:关 1:关 2:开 3:开 4:开 5:开 6:关
在防火墙中开启mysql的3306的远程访问,这样就可以使用navicat等工具连上mysql
[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
success
[root@localhost ~]# firewall-cmd --reload
success
redis安装
linux安装redis 完整步骤
安装:
1.获取redis资源
wget http://download.redis.io/releases/redis-4.0.8.tar.gz
2.解压
tar xzvf redis-4.0.8.tar.gz
3.安装
cd redis-4.0.8
make
cd src
make install PREFIX=/usr/local/redis
4.移动配置文件到安装目录下
cd ../
mkdir /usr/local/redis/etc
mv redis.conf /usr/local/redis/etc
5.配置redis为后台启动
vi /usr/local/redis/etc/redis.conf //将daemonize no 改成daemonize yes
6.将redis加入到开机启动
vi /etc/rc.local //在里面添加内容:/usr/local/redis/bin/redis-server /usr/local/redis/etc/redis.conf (意思就是开机调用这段开启redis的命令)
7.开启redis
/usr/local/redis/bin/redis-server /usr/local/redis/etc/redis.conf
常用命令
redis-server /usr/local/redis/etc/redis.conf //启动redis
pkill redis //停止redis
卸载redis:
rm -rf /usr/local/redis //删除安装目录
rm -rf /usr/bin/redis-* //删除所有redis相关命令脚本
rm -rf /root/download/redis-4.0.4 //删除redis解压文件夹