阿里云部署杂记-节约时间

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

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

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

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

Mysql

rpm -qa|grep -i mysql

查看，有则删 - yum remove '软件名'

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 错误提示：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 登录root帐号需要密码，不过我们没有。于是就是忘记密码的操作了。

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

重启mysql，service mysqld restart

登录mysql，# mysql -u root

修改密码

mysql>use mysql;

mysql>update mysql.user set authentication_string=password('密码') where user='root';

mysql>flush privileges;

mysql>exit;

恢复/etc/my.cnf，将skip-grant-tables删除或者注释掉

service mysqld restart

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

SET PASSWORD = PASSWORD('it_workers365'); 

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

set global validate_password_policy=0; --再试

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

flush privileges;

如果客户端连接报错：

Host '180.167.219.98' is not allowed to connect to this MySQL server"

grant all PRIVILEGES on *.* to root@'180.167.219.98'  identified by 'it_workers365';

flush privileges;