搜索到
8
篇与
linux
的结果
-
记mysql在阿里云ubuntu服务器的配置过程 1. MySQL配置1.1 安装MySQLapt-get install mysql-server1.2 配置MySQL初始化配置mysql_secure_installation VALIDATE PASSWORD PLUGIN can be used to test passwords... Press y|Y for Yes, any other key for No: N (我的选项) Please set the password for root here... New password: (输入密码) Re-enter new password: (重复输入)By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them... Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (我的选项)Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network... Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y (我的选项)By default, MySQL comes with a database named 'test' that anyone can access... Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (我的选项)Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (我的选项)检查mysql服务状态systemctl status mysql.service,显示如下图则表示没有问题1.3 配置MySQL远程访问首先编辑数据库文件vim /etc/mysql/mysql.conf.d/mysqld.cnf 注释掉bind-address = 127.0.0.1进入mysql数据库mysql -u root -p之后输入之前配置的密码即可进入之后执行以下命令use mysql select user,host from user; # 查询user表中数据 update user set host='%' where user='root'; # 修改root账号的host字段为：% # 给任意主机root账户连接mysql服务器权限： GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root的密码' WITH GRANT OPTION; flush privileges; # 刷新权限表，使配置生效 重启mysql服务sudo /etc/init.d/mysql restart如果出现1064 错误：修改加密规则：alter user '用户名'@'%' identified with mysql_native_password by '密码';刷新权限：flush privileges;重启mysql -
记nginx在阿里云ubuntu服务器上的配置过程 1. Nginx配置1.1 安装Nginx首先键入apt-get update更新安装源然后键入apt-get install nginx安装nginx设置开机启动systemctl enable nginx(有的说使用标准安装默认开机自启，这里我并没有去验证)此时就可以通过ip地址访问Nginx网页，如果阿里云的域名解析已经做好，也可以使用域名访问。1.2 配置SSL证书及默认HTTPS访问如果你购买了域名并购买了SSL证书（有免费的）在ssl证书页面定位到需要下载的证书实例，根据服务器类型下载对应的文件，并解压登录阿里云服务器，进入Nginx安装目录（默认目录为/etc/nginx）创建cert目录mkdir cert使用远程登录工具（如Xshell或者MobaXterm）附带的本地文件上传功能，将下载的证书文件和密钥文件上传到Nginx服务器的cert目录下(我这里用的MobaXterm)打开Nginx默认配置文件vim /etc/nginx/sites-available/default按i建进入编辑模式，在配置文件中新增以下server代码server { listen 443 default_server; listen [::]:443 default_server; ssl on; root /usr/share/nginx/html;# 站点目录 index index.html index.htm; ssl_certificate /etc/nginx/cert/domain_name.pem; #将domain_name.pem替换成你证书的文件名称 ssl_certificate_key /etc/nginx/cert/domain_name.key;#将domain_name.key替换成你证书的密钥文件名称 ssl_session_timeout 5m; ssl_ciphers ECDHE-RSA-AES128-GCM-SHA256:ECDHE:ECDH:AES:HIGH:!NULL:!aNULL:!MD5:!ADH:!RC4; ssl_protocols TLSv1 TLSv1.1 TLSv1.2; ssl_prefer_server_ciphers on; }修改完毕之后，按Esc键后输入：wq,然后按回车键保存文件并退出编辑模式重启Nginx服务器service nginx restart可选：设置HTTP请求自动跳转HTTPS在需要跳转的HTTP站点添加以下rewrite语句即可rewrite ^(.*)$ https://$host$1 permanent;
-
-
-
-
-
-
