nginx 和 mysql 的基本安装

yum -y install gcc zlib zlib-devel pcre-devel openssl openssl-devel
mkdir nginx
wget  http://nginx.org/download/nginx-1.21.6.tar.gz
tar -xvf nginx-1.21.6.tar.gz 
cd nginx-1.21.6
ls
./configure --with-http_stub_status_module --with-http_ssl_module
ls
make
make install
ll
# 编辑服务器配置端口为8899
vim conf/nginx.conf 
cd sbin
# 启动服务
./nginx -c /usr/local/nginx/conf/nginx.conf
  
./nginx 启动

./nginx -s stop 关闭

./nginx -s reload 重启

mysql
yum安装方法
https://cloud.tencent.com/developer/article/1504265

netstat -antlpe|grep mysql
cd /telecom_file/
df -h
tar zxvf mysql-8.0.11-el7-x86_64.tar.gz
mv mysql-8.0.11-el7-x86_64 /usr/local/mysql
cd /usr/local/mysql/
groupadd mysql
useradd -g mysql mysql
mkdir data
chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql
cd bin
# 如果报错需要安装libaio
yum -y install libaio
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
# 启动的时候会报错
mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
chown -R mysql:mysql /var/log/mariadb/
# 疑问：初始化前是否有 /etc/my.cnf 配置文件，这个配置文件是什么时候生成的
# 启动报错的问题
# 启动提示找不到pid，这里要注意修改etc/my.cnf的配置文件里面的相关路径
/usr/local/mysql/support-files/mysql.server start

# 启动的时候有个报错：
#Starting MySQL.2023-12-26T02:39:28.348916Z mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.
# ERROR! The server quit without updating PID file (/usr/local/mysql/data/evm-clbbjt9vg37k01kbh700.pid).

# 解决只要通过建立lib下的mysql，启动的时候就会自动在目录类建立mysql.sock文件
mkdir /var/lib/mysql
chmod 777 /var/lib/mysql

# RROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock
#
# https://blog.csdn.net/Aria_Miazzy/article/details/92803246
# 带上127.0.0.1
mysql -h 127.0.0.1 -u root -p


#password bxxx2
mv /etc/my.cnf /etc/my.cnf.backup
rm -rf /etc/my.cnf
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
/usr/local/mysql/bin/mysql -u root -p

## 若忘记密码
./mysqld_safe --skip-grant-tables &
/usr/local/mysql/bin/mysql -u root -p
flush privileges
ALTER USER 'root'@'localhost'IDENTIFIED BY '密码';


## 以下语句是错误语句，在8.0版本以上不能使用
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "bjdxx@32132" WITH GRANT OPTION;


create user 'root'@'%' identified by  'bxxxx32';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
select User,Host from user;