阿里云部署杂记节约时间

vsftp 配置实用记录
为实例安全组配置规则中增加21端口&＃xff0c;0.0.0.0/0不区分服务可用&＃xff08;阿里云服务器其他端口需要外部访问的均需配置后重启方可用&＃xff09;

查看RPM是否安装了相关包
rpm -qa | grep vsftpda

打开配置文件 /etc/vsftpd/vsftpd.conf 取消匿名用户实用限制注释 anon_upload_enable&＃61;YES anon_mkdir_write_enable&＃61;YES 重启
yum -y install vsftpd
service vsftpd start

windows
cmd -> ftp IP -> anonymous -> 服务器密码
简单命令&＃xff0c;dir/put/get等
命令大全 https://www.aliyun.com/jiaocheng/175790.html

Mysql

rpm -qa|grep -i mysql

查看&＃xff0c;有则删 - yum remove &＃39;软件名&＃39;

wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm rpm -ivh mysql57-community-release-el7-7.noarch.rpm

yum install mysql-server

yum install mysql-devel

yum install mysql

service mysqld start
https://www.cnblogs.com/thinkingandworkinghard/p/6711255.html

mysql -u root 错误提示&＃xff1a;ERROR 1045 (28000): Access denied for user &＃39;root&＃39;&＃64;&＃39;localhost&＃39; (using password: NO) 登录root帐号需要密码&＃xff0c;不过我们没有。于是就是忘记密码的操作了。

在/etc/my.cnf文件中添加skip-grant-tables

重启mysql&＃xff0c;service mysqld restart

登录mysql&＃xff0c;# mysql -u root

修改密码

mysql>use mysql;

mysql>update mysql.user set authentication_string&＃61;password(&＃39;密码&＃39;) where user&＃61;&＃39;root&＃39;;

mysql>flush privileges;

mysql>exit;

恢复/etc/my.cnf&＃xff0c;将skip-grant-tables删除或者注释掉

service mysqld restart

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

SET PASSWORD &＃61; PASSWORD(&＃39;it_workers365&＃39;); 

如果失败&＃xff0c;ERROR 1819 (HY000): Your password does not satisfy the current policy requirements;

set global validate_password_policy&＃61;0; --再试

ALTER USER &＃39;root&＃39;&＃64;&＃39;localhost&＃39; PASSWORD EXPIRE NEVER;

flush privileges;

如果客户端连接报错&＃xff1a;

Host &＃39;180.167.219.98&＃39; is not allowed to connect to this MySQL server"

grant all PRIVILEGES on *.* to root&＃64;&＃39;180.167.219.98&＃39;  identified by &＃39;it_workers365&＃39;;

flush privileges;