一、服务器可连接外网
1、宝塔面板安装
https://www.bt.cn/bbs/thread-19376-1-1.html
2、使用phpstudy安装集成环境
https://www.xp.cn/linux.html
二、服务器不可连接外网
1、使用yum安装
2、yum不可用,离线安装
jdk安装
jdk安装
1、下载jdk
2、解压 tar -zxvf
3、vim /etc/profile
4、编辑内容如下
export JAVA_HOME=/usr/local/jdk1.8.0_181 #jdk安装目录
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib:$CLASSPATH
export JAVA_PATH=${JAVA_HOME}/bin:${JRE_HOME}/bin
export PATH=$PATH:${JAVA_PATH}
5、文件生效 source /etc/profile
mysql安装
1、下载mysql
2、解压 tar xvJf
3、重命名文件夹 mv
4、创建data文件夹 存储文件 mkdir data
5、创建用户组以及用户和密码
groupadd mysql
useradd -g mysql mysql
6、授权用户 chown -R mysql.mysql /usr/local/mysql
7、初始化基础信息 ./bin/mysqld --user=mysql --basedir=/usr/local/mysql-8.0 --datadir=/usr/local/mysql-8.0/data/ --initialize
8、编辑my.cnf
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /usr/local/mysql/data
default_storage_engine = InnoDB
performance_schema_max_table_instances = 400
table_definition_cache = 400
skip-external-locking
key_buffer_size = 1024M
max_allowed_packet = 100G
table_open_cache = 4096
sort_buffer_size = 16M
net_buffer_length = 4K
read_buffer_size = 16M
read_rnd_buffer_size = 256K
myisam_sort_buffer_size = 256M
thread_cache_size = 512
tmp_table_size = 512M
default_authentication_plugin = mysql_native_password
lower_case_table_names = 1
sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
explicit_defaults_for_timestamp = true
#skip-name-resolve
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
binlog_expire_logs_seconds = 600000
slow_query_log=1
slow-query-log-file=/usr/local/mysql/data/mysql-slow.log
long_query_time=3
#log_queries_not_using_indexes=on
early-plugin-load = ""
innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data
innodb_buffer_pool_size = 4096M
innodb_log_file_size = 2048M
innodb_log_buffer_size = 512M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_max_dirty_pages_pct = 90
innodb_read_io_threads = 40
innodb_write_io_threads = 40
[mysqldump]
quick
max_allowed_packet = 500M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 1024M
sort_buffer_size = 16M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
9、添加mysqld服务到系统 cp -a ./support-files/mysql.server /etc/init.d/mysql
10、授权以及添加服务
chmod +x /etc/init.d/mysql
chkconfig --add mysql
11、启动 mysql service mysql start
12、查看启动状态 service mysql status
13、将mysql命令添加到服务 ln -s /usr/local/mysql-8.0/bin/mysql /usr/bin
14、登录mysql mysql -uroot -p 密码使用之前随机生成的密码
15、修改root密码 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; 其中123456是新的密码自己设置
16、执行 flush privileges; 使密码生效
17、选择mysql数据库 use mysql;
18、修改远程连接并生效
update user set host='%' where user='root';
flush privileges;