絮叨两句:
博主是一名大数据开发实习生,利用博客记录自己所学的知识,也希望能帮助到正在学习的同学们
人的一生中会遇到各种各样的困难和折磨，逃避是解决不了问题的，唯有以乐观的精神去迎接生活的挑战
少年易老学难成，一寸光阴不可轻。
最喜欢的一句话:今日事,今日毕

安装包

链接：https://pan.baidu.com/s/1J-zUJ4LPadbXCl5b8Rv0tw
提取码：egrk

CentOS7 安装mysql

使用:wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
报错:-bash: wget: command not found
解决办法:yum -y install wget
安装mysql:👇
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum install mysql-community-server

安装成功后重启mysql服务

 service mysqld restart //重启服务service mysqld status  //查看状态

初次安装mysql，root账户没有密码

[root@node01 yum.repos.d]# mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.49 MySQL Community Server (GPL)Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)mysql>

为mysql添加用户（同时设置密码）

 mysqladmin      -u    root      password    '123456'

mysql 解决中文乱码问题

show variables like 'character_set_%';

mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
2、设置mysql各个角色的编码编辑/etc/my.cnf文件（安装mysql后系统自动添加的），在文件中添加一下内容,最后保存退出[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8	3、重启mysql service mysqld restart4、再次确认编码格式show variables like 'character_set_%';mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql 远程连接

1、查看当前哪些用户可以访问进入mysql shellshow databases;use  mysql ;select host, user ,password  from user;mysql> select host, user ,password  from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| node01    | root |                                           |
| 127.0.0.1 | root |                                           |
| ::1       | root |                                           |
| localhost |      |                                           |
| node01    |      |                                           |
+-----------+------+-------------------------------------------+
6 rows in set (0.00 sec)
2、修改配置,在user表中添加所有用户可以访问本mysql服务命令： grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;'root'@'%' ：   %  表示所有主机   root  表示主机上使用的用户  123456  表示用户所使用的密码
3、刷新生效
flush privileges;
检查更新
select host, user ,password  from user; mysql> select host, user ,password  from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| node01    | root |                                           |
| 127.0.0.1 | root |                                           |
| ::1       | root |                                           |
| localhost |      |                                           |
| node01    |      |                                           |
| %         | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+-----------+------+-------------------------------------------+
7 rows in set (0.00 sec)
5、远程连接
使用sql软件进行连接

mysql开启自启

vi /etc/rc.local在文件中添加 service  mysqld start即可

安装jdk

第一步上传1.8jdk的压缩包，并解压文件上传的路径为/export/softjdk解压的路径是/export/install
第二步：配置环境变量在/etc/profile.d目录下创建一个java.sh文件，在该文件内编辑环境变量export   JAVA_HOME=/export/install/jdk1.8.0_144export   PATH=PATH:JAVA_HOME/bin	说明：	JAVA_HOME=/export/install/jdk1.8.0_144       配置Java的home，路径是jdk解压路径	export   PATH=PATH:JAVA_HOME/bin     将JAVA_HOME内的bin目录配置到系统路境内（$JAVA_HOME后必须加一个/bin）第三步：source  /etc/profile  让环境变量生效说明：百度上查询的linux配置方法大部分是在 /etc/profile 最后追加配置项（export   JAVA_HOME   和export   PATH），这种方法不建议使用。容易误操作核心配置文件（ /etc/profile ），误操作有导致系统崩溃的风险。第四步：验证是否配置成功[root@node01 profile.d]# jps2490 Jps	第五步：验证版本java -version   查看当前java版本若版本不正确（不是java  1.8）需要更新链接先删除原始的链接rm -rf /etc/alternatives/java在更新新的链接ln -s /export/install/jdk1.8.0_144/bin/java   /etc/alternatives/java第六步：验证版本java -version   查看当前java版本

安装Tomcat

第一步：上传解压将tomcat 压缩包上传到/export/soft文件夹将压缩包解压到/export/install内tar  -zxvf  apache-tomcat-6.0.53.tar.gz  -C   /export/install解压完毕表示安装完毕第二步：启动tomcat 进入解压后目录的bin目录内实行启动./startup.sh第三步：查看启动日志日志路径：在安装路径内的logs内，有个catalina.out文件所有的日志信息都在catalina.out内第四步：关闭tomcat./shutdown.sh
1：web项目的发布web项目打成war包，上传到安装目录下的webapp。启动tomcat,web项目自动部署2：项目内的日志会全部输出到logs/catalina.out

---

若能帮助到你,记得点赞支持，谢谢