阿里云java mysql环境_阿里云搭建centos java mysql nginx环境
1.上傳下載
yum install lrzsz
sz下載
rz上傳
2.安裝壓縮命令
yum install -y unzip zip;
3.安裝java
rpm -ivh jdk-8u161-linux-x64.rpm
4.安裝mysql
yum install libaio
yum -y remove mariadb-libs-5.5*
rpm -ivh mysql-community-common-5.7.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.21-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.21-1.el7.x86_64.rpm
啟動(dòng)配置mysql
vi? /etc/my.cnf
在[mysqld]下添加:
skip-grant-tables=1
service mysqld restart
mysql -u root -p
update user set host='%' where host='localhost';
update user set authentication_string = password('xxx'), password_expired = 'N', password_last_changed = now() where user = 'root';
再把上面的skip-grant-tables=1去掉,這樣就可以密碼登錄了。
mysql5.7默認(rèn)分組字段必須在查詢字段里,修改這個(gè)配置:
mysql命令行,執(zhí)行命令
select @@sql_mode;
這樣就可以查出sql_mode的值,復(fù)制這個(gè)值,在my.cnf中添加配置項(xiàng)(把查詢到的值刪掉only_full_group_by這個(gè)選項(xiàng),其他的都復(fù)制過去):
sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION;
再加一行,設(shè)置默認(rèn)編碼
character-set-server=utf8
設(shè)置innodb緩存,加快查詢速度,其值按自己機(jī)器定:
innodb_buffer_pool_size=256M
5.安裝nginx
yum install gcc-c++
yum install -y pcre pcre-devel
yum install -y zlib zlib-devel
yum install -y openssl openssl-devel
下載并解壓nginx-1.10.2,進(jìn)入nginx-1.10.2目錄
chmod a+x ./configure
./configure
make
make install
安裝成功了,查找安裝路徑:
whereis nginx
cd /usr/local/nginx/sbin/
啟動(dòng): ./nginx
退出:./nginx -s quit
nginx的負(fù)載均衡:
cd /usr/local/nginx/conf
vi nginx.conf
http{
include /usr/local/nginx/conf.d/*.conf;
}
進(jìn)入conf.d文件夾,編輯自己網(wǎng)站xx.conf,假如域名是www.xx.com,本地啟動(dòng)了兩個(gè)端口8280 8281:
upstream tomcats{
server 127.0.0.1:8280;
server 127.0.0.1:8281;
}
server {
listen 80;
server_name www.xx.com;
index index.html;
location / {
#上面配置的服務(wù)器組
proxy_pass http://tomcats;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_connect_timeout90;
proxy_send_timeout90;
proxy_read_timeout90;
client_max_body_size10m;
client_body_buffer_size1m;
proxy_buffer_size64k;
proxy_buffers 32 32k;
proxy_busy_buffers_size128k;
proxy_temp_file_write_size1m;
limit_conn perip 5;
limit_conn perserver 20;
limit_rate 100k;
index index.html index.htm index.jsp;
}
}
漏洞修復(fù)
yum -y install wget
評(píng)論:
提交
總結(jié)
以上是生活随笔為你收集整理的阿里云java mysql环境_阿里云搭建centos java mysql nginx环境的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 中东也“扛不住” 阿联酋油价飞涨:地主家
- 下一篇: 四川雅安芦山突发6.1级地震!转存!遭遇