#备份python旧版本信息
mv /usr/bin/python /usr/bin/python2.6_old#删除旧链接并重新创建链接
rm /usr/bin/python2
ln -s /usr/bin/python2.6_old /usr/bin/python2
#重新建立Python3.6的环境变量
ln -s /usr/local/python3.6.4/bin/python3.6 /usr/bin/python
------------------------------------
yum依赖python2 可能造成yum不能用
------------------------------------------------------------------------
rpm -qa|grep mysql
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64 //卸载
tar -xf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar
1. rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm
2. rpm -ivh mysql-community-libs-5.7.12-1.el6.x86_64.rpm
3. rpm -ivh mysql-community-devel-5.7.12-1.el6.x86_64.rpm
4. rpm -ivh mysql-community-client-5.7.12-1.el6.x86_64.rpm
5. rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm
第三步:环境变量设置
设置SELinux 成为permissive模式,否则启动报错
setenforce 0
确保my.cnf里【client】【mysql】【mysqld】都包含下面一行
socket=/storage/db/mysql/mysql.sock
启动MySQL:service mysqld start
- 取消注释 skip-grant-tables。不验证用户密码
- service restart mysqld
D:\ mysql-5.7.9-winx64 \ bin> mysql
启动之后,别关闭当前cmd,直接输入mysql,进入mysql后,输入下列语句设置用户密码:
mysql>use mysql;
mysql> update user set authentication_string=password('newpassword'),password_expired='N' where user='root';
mysql>flush privileges;
设置完成,exit退出mysql,关闭cmd窗口,接着打开my.cnf文件,将skip-grant-tables注释掉:
#skip-grant-tables,保存文件,打开cmd窗口(管理员方式打开),net stop mysql停止mysql服务,再用 net start mysql重新启动mysql服务。
在cmd窗口下,输入mysql -u root -p
新建用户和数据库
修改密码强度为弱 :
set global validate_password_policy=0;
#flush privileges;
#create database dash DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
#grant all privileges on `dash`.* to 'dashuser';
#flush privileges;
CREATE TABLE `user` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`username` varchar(120) NOT NULL,
`email` varchar(120) DEFAULT NULL,
`password` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
开启服务器端口
修改/etc/sysconfig/iptables 文件,增加如下一行,加到22端口下面,不能加在最后!
-A INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT
重启iptables
service iptables restart
开放一个范围的端口3000到5000
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3000:5000 -j ACCEPT
-----------------------------测试端口是否通
ssh -v -p 1521 username@ip