面包妹 發表於 2019-5-7 12:58:00

CentOS 7 64位

<div class="cnblogs_code">
<pre><span style="font-size: 15px"><strong>1.查看Ip:ip addr</strong></span><br>以前记得使用的是 ifconfig</pre>
&nbsp; &nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190507123138341-1331374878.png" alt="">
<p>&nbsp; &nbsp;这里提示没有发现命令</p>
<p>&nbsp;</p>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190507123233602-1892486568.png" alt=""></p>
<p>&nbsp; 使用 ip addr 出现了上边的结果。系统刚刚在虚拟机中装好,所以显示的是上边的结果。但是出现了ip: 127.0.0.1</p>
<pre> </pre>
</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre>2.修改ip配置,联网<br><br> vi /etc/sysconfig/network-scripts/ifcfg-ens33<br><br>初始化状态,linux是默认不打开网络的noboot=no</pre>
&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190507123726759-1117940592.png" alt="">
<p>&nbsp; 我们需要修改其配置。</p>
<p>&nbsp; 把最后的这个参数改为 yes</p>
<p>&nbsp; 然后重启服务:&nbsp;&nbsp;sudo service network restart&nbsp;</p>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190507124218061-2110761204.png" alt=""></p>
<p>&nbsp;成功后,我们再次查看ip,现在的IP显示的就是我们联网后的ip地址了。可以使用第三方的工具链接使用了。</p>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190507124506510-1695721222.png" alt=""></p>
<p>&nbsp; 我这里使用mac终端链接的</p>
<p>&nbsp; &nbsp; &nbsp;1.连接服务器</p>
<p>&nbsp; &nbsp; &nbsp;2.出现了一个提示。看不懂。就直接写 yes&nbsp;</p>
<p>&nbsp; &nbsp; &nbsp;3.输入连接服务器时候的用户的密码&nbsp; 就是 root@xxxx&nbsp; 这里的root的密码</p>
<p>&nbsp; &nbsp; &nbsp;4.成功连接,可以执行操作了!</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre>静态ip配置<br><br>查看ip<br>ip a s和 ip addr差不多<br><br></pre>
<img src="https://img2018.cnblogs.com/blog/1197493/201906/1197493-20190620110005233-1183592146.png" alt="">
<p>&nbsp;</p>
<p>然后修改文件</p>
<p>cd /etc/sysconfig/network-scripts/</p>
<p>vi ifcfg-ens33&nbsp; &nbsp;可能有的人这个文件名称不同 但是大多也是 ifcfg-enxxxxxx</p>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre>我的配置文件<br><br>TYPE=<span style="color: rgba(0, 0, 0, 1)">Ethernet
PROXY_METHOD</span>=<span style="color: rgba(0, 0, 0, 1)">none
BROWSER_ONLY</span>=<span style="color: rgba(0, 0, 0, 1)">no
BOOTPROTO</span>=<span style="color: rgba(0, 0, 0, 1)">staic这里原来是dhcp动态获取,我们需要改为静态的 staic
DEFROUTE</span>=<span style="color: rgba(0, 0, 0, 1)">yes
IPV4_FAILURE_FATAL</span>=<span style="color: rgba(0, 0, 0, 1)">no
IPV6INIT</span>=<span style="color: rgba(0, 0, 0, 1)">yes
IPV6_AUTOCONF</span>=<span style="color: rgba(0, 0, 0, 1)">yes
IPV6_DEFROUTE</span>=<span style="color: rgba(0, 0, 0, 1)">yes
IPV6_FAILURE_FATAL</span>=<span style="color: rgba(0, 0, 0, 1)">no
IPV6_ADDR_GEN_MODE</span>=stable-<span style="color: rgba(0, 0, 0, 1)">privacy
NAME</span>=<span style="color: rgba(0, 0, 0, 1)">ens33
UUID</span>=b75a8452-56f1-4d33-920d-<span style="color: rgba(0, 0, 0, 1)">3f9205df8d1b
DEVICE</span>=<span style="color: rgba(0, 0, 0, 1)">ens33
ONBOOT</span>=<span style="color: rgba(0, 0, 0, 1)">yes联网必须为yes<br>#这里是我们配置的ip
DNS1</span>=<span style="color: rgba(128, 0, 128, 1)">172.16</span>.<span style="color: rgba(128, 0, 128, 1)">174.2这里这个dns使用公共的就可以8.8.8.8或者 114.114.114.114</span><span style="color: rgba(0, 0, 0, 1)">
DNS2</span>=<span style="color: rgba(128, 0, 128, 1)">8.8</span>.<span style="color: rgba(128, 0, 128, 1)">4.4dns这个有几个公开的,</span><span style="color: rgba(0, 0, 0, 1)">
IPADDR</span>=<span style="color: rgba(128, 0, 128, 1)">172.16</span>.<span style="color: rgba(128, 0, 128, 1)">174.133这个是我们使用动态dhcp时候获取的ip,我就使用这个了</span><span style="color: rgba(0, 0, 0, 1)">
NETMASK</span>=<span style="color: rgba(128, 0, 128, 1)">255.255</span>.<span style="color: rgba(128, 0, 128, 1)">255.0   这个就这样写就可以</span><span style="color: rgba(0, 0, 0, 1)">
GATEWAY</span>=<span style="color: rgba(128, 0, 128, 1)">172.16</span>.<span style="color: rgba(128, 0, 128, 1)">174.2<span style="color: rgba(255, 0, 0, 1)">网管这里,不太懂,原来写的192.168.1.1反正就是192.168.xx.xx就是不行,连不上网,具体原因未知,待查找(主要是自己不懂),<strong>这里需要写的和ip地址差不多,只改最后一个数就可以</strong></span></span><span style="color: rgba(0, 0, 0, 1)">
#NM_CONTROLLED</span>=NO<br><br><span style="color: rgba(255, 0, 0, 1); font-family: 隶书; font-size: 15px"><strong>ps: GATEWAY 网关,这个其实就是不同网络段之间交互的一个转换器,比如 192.168.1.2和192.168.2.3交互传递消息如果没有网关,那么就不能够交互,<br>自己的网关管理自己的ip,所以网关需要和ip地址相似,只是最后一个位数不同,这里分享一个地址,解释的很到位:<br>https://baike.baidu.com/item/%E7%BD%91%E5%85%B3/98992?fr=aladdin<br></strong></span><br><br></pre>
</div>
<p>然后重启服务</p>
<p>service network restart</p>
<p>重启服务还可以使用 systemctl restart network</p>
<p>然后ping一下</p>
<p>ping www.baidu.com</p>
<p>出现数据就表示通了,链接成功!</p>
<p><img src="https://img2018.cnblogs.com/blog/1197493/201906/1197493-20190620111510886-1756030555.png" alt="">&nbsp;</p>
</div>
</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre>3.安装jdk<br><br>参考:https://www.cnblogs.com/sxdcgaq8080/p/7492426.html<br>   https://www.cnblogs.com/xuliangxing/p/7066913.html<br><br><span style="font-size: 14pt">检测系统中是否存在jdk</span></pre>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">1⃣️在命令窗口键入:

rpm -qa | grep java
命令说明:

rpm   管理套件   

-qa   使用询问模式,查询所有套件

grep  查找文件里符合条件的字符串

java   查找包含java字符串的文件</span></pre>
</div>
<p>&nbsp;因为自己的系统上没有jdk,所以直接下载去安装,不用删除。这里可能使用这个命令后没有出现数据,那么最好的方式就是使用 java -version 这个就可以知道有没有安装jdk了</p>
<p>&nbsp;</p>
<p>&nbsp;<span style="font-size: 14pt"><strong>下载安装</strong></span></p>
<p>&nbsp; 1⃣️官网下载</p>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190509122612129-700438024.png" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;2⃣️然后通过第三方连接工具FileZilla 把下载好的jdk文件放到linux上,目录任意,我放到了 /tmp&nbsp; 下</p>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190509122811781-1561981396.png" alt=""></p>
<p>&nbsp; 3⃣️ 把文件拷贝到 /usr/java/ 下,如果没有java文件夹,就自己创建一个&nbsp;</p>
<p>&nbsp; &nbsp; 命令:进入usr目录 cd /usr</p>
<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;查看是否有java文件夹 ls</p>
<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;不存在创建java文件夹 mkdir java</p>
<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;好了文件创建完成</p>
<p>&nbsp; &nbsp; 复制jdk文件到java下 命令: cp jdk-xxxx /usr/java/&nbsp; &nbsp; 这里注意⚠️:java后要跟上 / 斜杠,否则就会在usr下就会变成一个java到一个文件</p>
<p>&nbsp; 4⃣️<span style="color: rgba(255, 0, 0, 1); font-size: 16px"><strong>解压jdk文件</strong></span></p>
<p>&nbsp; &nbsp; 命令: <span style="color: rgba(255, 0, 255, 1)">tar zxvf jdk-xxxx</span></p>
<p>&nbsp; <span style="color: rgba(255, 0, 0, 1); font-size: 16px"><strong>5⃣️配置jdk</strong></span></p>
<p>&nbsp; <span style="color: rgba(255, 0, 255, 1)">&nbsp;vi /etc/profile</span></p>
<p>&nbsp; &nbsp;编辑这个文件在文档末尾换行加入以下配置&nbsp; jdk到路径需要写自己的jdk的名称&nbsp;</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(255, 0, 255, 1)">JAVA_HOME=/usr/java/jdk1.8.0_211
CLASSPATH=$JAVA_HOME/lib/
PATH=$PATH:$JAVA_HOME/bin
export PATH JAVA_HOME CLASSPATH</span></pre>
</div>
<p>&nbsp; 6⃣️让服务立即生效</p>
<p>&nbsp; &nbsp;命令:&nbsp;<strong>source /etc/profile</strong></p>
<p><strong>&nbsp; 7⃣️</strong>检查是否安装成功</p>
<p>&nbsp; &nbsp;java -vsersion</p>
<p>&nbsp; &nbsp;出现以下信息为安装成功</p>
<p>&nbsp; &nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190509123903994-402307206.png" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><span style="color: rgba(255, 0, 0, 1)"><span style="font-size: 16px"><strong>ps</strong></span>:还有一种也是很简单的</span></p>
<p>rpm文件的安装</p>
<p>rpm -ivh jdk-8u131-linux-x64.rpm</p>
<p>然后配置,配置和上边的一样</p>
<p>可以参考:https://www.cnblogs.com/taohaijun/p/7153176.html</p>
<p>&nbsp;</p>
<p><span style="font-family: 仿宋; font-size: 18px; color: rgba(255, 0, 255, 1)">「 jdk的安装最主要的就是把解压出来的文件加配置环境变量,然后重启服务就可以使用 」</span></p>
</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<div class="cnblogs_code">
<pre>4.mysql的安装</pre>
<div class="cnblogs_code">
<pre><span style="color: rgba(255, 0, 255, 1)"><strong><span style="color: rgba(0, 0, 255, 1)">2020.7.20一直用的,安全可以使用,出现问题可以看后边的,那个是以前的,现在这个没有出现问题</span></strong><br><span style="color: rgba(0, 0, 255, 1)">下载安装包:<br>wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
&nbsp;
执行安装命令:<br>rpm -ivh mysql-community-release-el7-5.noarch.rpm
&nbsp;
安装服务:<br>yum install mysql-server 在需要确认的地方输入y&nbsp;即yes的意思
&nbsp;
设置权限:<br>chown mysql:mysql -R /var/lib/mysql
&nbsp;
开启mysql服务:<br>systemctl start mysqld
&nbsp;
设置mysql&nbsp;密码:<br>mysqladmin -u root password "your_password";.
&nbsp;
验证密码进入mysql:<br>mysql -u root -p密码
&nbsp;
开启允许局域网内连接(登陆mysql后在mysql控制台下执行)所有用户可以通过这个密码连接数据库
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'leenleda2020' WITH GRANT OPTION;
&nbsp;
刷新权限:FLUSH PRIVILEGES;</span><br><br><span style="color: rgba(0, 0, 255, 1)">记得打开防火墙端口和刷新</span><br><span style="color: rgba(0, 0, 255, 1)">firewall-cmd --zone=public --add-port=3306/tcp --permanent</span><br><span style="color: rgba(0, 0, 255, 1)">firewall-cmd --reload</span><br><br></span></pre>
</div>
<pre><br><br><br>1.下载并安装MySQL官方的Yum Repository<br><br>   wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm<br> <br>2.使用上面的命令直接安装Yum Repository<br>   yum -y install mysql57-community-release-el7-10.noarch.rpm<br><br>3.安装MySQL服务器<br>    yum -y install mysql-community-server<br><br>4.启动MySQL<br>    systemctl start mysqld.service<br><br>5.查看MySQL运行状态<br>    systemctl status mysqld.service<br><br>6.MySQL已经开始正常运行,需要找出root的密码<br>    grep <span class="hljs-string">"password" /var/<span class="hljs-keyword">log/mysqld.<span class="hljs-keyword">log</span></span></span><br><br>7.登陆mysql<br>    mysql -uroot -p      回车<br>    然后复制粘贴找出的密码<br>    进入mysql<br> 8.修改密码<br>   alter user user() identified by "123456"; //可以</pre>
<pre>   ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; //这个修改成功后没有实验。应该可以,毕竟其他人的博客有这个修改密码</pre>
<pre><br><br><span style="font-size: 18px; color: rgba(255, 0, 0, 1)"><strong>下边是操作过程中遇到的问题。</strong></span><br><br></pre>
<div class="cnblogs_code">
<pre>问题1:把查找出的密码直接复制到 -p后边报错了。</pre>
<pre># mysql -uroot -pEVzwOA!<span style="color: rgba(0, 0, 0, 1)">qQ8ow
</span>-bash: !qQ8ow: <span style="color: rgba(0, 0, 255, 1)">event</span> not found<br><br>解决方式:</pre>
<pre># mysql -uroot -p<br> Enter password:xxx<br>密码换行输出</pre>
</div>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">2</span>.mysql&gt; ALTER USER <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">'</span>@<span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">localhost</span><span style="color: rgba(128, 0, 0, 1)">'</span> IDENTIFIED BY <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">;
ERROR </span><span style="color: rgba(128, 0, 128, 1)">1819</span><span style="color: rgba(0, 0, 0, 1)"> (HY000): Your password does not satisfy the current policy requirements

修改密码时候报错,这里是应为mysql版本问题,高版本中加了校验规则,所以,不符合的,就会报错了<br>参考:https://blog.csdn.net/wltsysterm/article/details/79649484<br><br><span style="font-size: 14px">validate_password_policy作用<br></span></span>判断修改密码时候新密码是否符合当前的策略,不满足报错,不让修改。</pre>
<pre>validate_password_length<br> 密码最小长度</pre>
<pre><span style="color: rgba(0, 0, 0, 1)">解决:<br><br></span>mysql&gt; <span class="hljs-keyword">set <span class="hljs-keyword">global validate_password_policy=<span class="hljs-number">0;</span></span></span></pre>
<pre><span class="hljs-keyword"><span class="hljs-keyword"><span class="hljs-number">mysql&gt; <span class="hljs-keyword">set <span class="hljs-keyword">global validate_password_length=<span class="hljs-number">1;</span></span></span></span></span></span></pre>
<pre></pre>
</div>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">3</span><span style="color: rgba(0, 0, 0, 1)">.查看校验策略时候报错
mysql</span>&gt; show variables like <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">validate_password</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">;
ERROR </span><span style="color: rgba(128, 0, 128, 1)">1820</span> (HY000): You must reset your password <span style="color: rgba(0, 0, 255, 1)">using</span> ALTER USER statement before executing <span style="color: rgba(0, 0, 255, 1)">this</span><span style="color: rgba(0, 0, 0, 1)"> statement.


这里也是没有修改密码之前使用。报错,修改密码后就没事了。退出登陆后加上%的数据</span><span style="color: rgba(0, 0, 0, 1)">
show variables like </span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">validate_password%</span><span style="color: rgba(128, 0, 0, 1)">'</span>;</pre>
<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190511190317221-200660201.png" alt="">
<pre></pre>
</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">4</span>.mysql&gt; show variables like <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">default_password_lifetime</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)">;
ERROR </span><span style="color: rgba(128, 0, 128, 1)">1820</span> (HY000): You must reset your password <span style="color: rgba(0, 0, 255, 1)">using</span> ALTER USER statement before executing <span style="color: rgba(0, 0, 255, 1)">this</span><span style="color: rgba(0, 0, 0, 1)"> statement.

这个就不知道什么错误了。修改密码后再次测试,就好了。不知道为什么。这里只是查看没有用到。可以暂时不考虑</span></pre>
</div>
<p>&nbsp;</p>
<pre><br>mysql&gt; <span class="hljs-keyword">set <span class="hljs-keyword">global validate_password_policy=<span class="hljs-number">0;<br>mysql&gt; <span class="hljs-keyword">set <span class="hljs-keyword">global validate_password_length=<span class="hljs-number">1;</span></span></span></span></span></span></pre>
<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190511184710266-1814845971.png" alt="">
<p><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190511184844208-277188282.png" alt=""></p>
<p><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190511184907973-1822648075.png" alt=""></p>
<p>&nbsp;</p>
<p>最后一个问题:</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">Yum Repository,以后每次 yum 操作都会自动更新,需要把这个卸载掉

# yum -y remove mysql57-community-release-el7-<span style="color: rgba(128, 0, 128, 1)">10</span>.noarch</pre>
</div>
<p>安装基本都是参看这个:https://blog.csdn.net/baidu_32872293/article/details/80557668</p>
<p>&nbsp;</p>
<p><span style="color: rgba(0, 0, 255, 1); font-size: 16px">好了这里安装好了,然后就是配置mysql了</span></p>
<p>外部连接是被拒绝的</p>
<p><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190511191457775-1245959827.png" alt=""></p>
<p>&nbsp; 因为没有授权,所以远程是不让连接的</p>
<p>&nbsp;1.授权</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">#任何主机
mysql</span>&gt;GRANT ALL PRIVILEGES ON *.* TO <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">root</span><span style="color: rgba(128, 0, 0, 1)">'</span>@<span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">%</span><span style="color: rgba(128, 0, 0, 1)">'</span> IDENTIFIED BY <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">123456</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)"> WITH GRANT OPTION;

#指定主机
mysql</span>&gt;GRANT ALL PRIVILEGES ON *.* TO <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">jack</span><span style="color: rgba(128, 0, 0, 1)">'</span>@’<span style="color: rgba(128, 0, 128, 1)">10.10</span>.<span style="color: rgba(128, 0, 128, 1)">50.127</span>’ IDENTIFIED BY <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">654321</span><span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(0, 0, 0, 1)"> WITH GRANT OPTION;

# 然后刷新权限
mysql</span>&gt;flush privileges;<br><br></pre>
<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190511191737103-1900476765.png" alt="">
<pre><br>授权后还是远程连接不上,错误:2003 - Can't connect to MySQL server on '172.16.174.128' (61 "Connection ref</pre>
<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512102419727-1177802161.png" alt="">
<p>&nbsp;</p>
<p>描述:其实这里是防火墙的问题,防火墙屏蔽了这个端口号。我们这里简单粗暴的方式就是直接关闭防火墙</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)"># <span style="color: rgba(255, 0, 0, 1)">systemctl disable firewalld</span>
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
# <span style="color: rgba(255, 0, 0, 1)">service firewalld stop</span>
Redirecting to /bin/systemctl stop firewalld.service</span></pre>
</div>
<p>然后测试就会成功了</p>
<p><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512103449996-1268034819.png" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;配置一下编码:</p>
<pre>
default-character-set =utf8<br><br><br><br><strong>数据库表名称不区分大小写<br></strong>lower_case_table_names=1</pre>
<pre><br><br>//这里可以配置一下sql_mode   ,默认情况下,我们如果插入的日期默认值为 '0000-00-00 00:00:00'就会下边的错误</pre>
<pre>1067 - Invalid default value for 'actionenddate', Time: 0.001000s</pre>
<div class="cnblogs_code">
<pre>sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'</pre>
</div>
<p>&nbsp;这里边就把几个参数去掉了,就可以了</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>防火墙相关知识:https://blog.csdn.net/qq_21441989/article/details/79111513</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)"><span style="color: rgba(255, 0, 0, 1)"><strong><span style="font-size: 16px">防火墙命令</span></strong></span>
systemctl是CentOS7的服务管理工具中主要的工具,它融合之前service和chkconfig的功能于一体。
启动一个服务:systemctl start firewalld.service
关闭一个服务:systemctl stop firewalld.service
重启一个服务:systemctl restart firewalld.service
显示一个服务的状态:systemctl status firewalld.service
在开机时启用一个服务:systemctl enable firewalld.service
在开机时禁用一个服务:systemctl disable firewalld.service
查看服务是否开机启动:systemctl is-enabled firewalld.service
查看已启动的服务列表:systemctl list-unit-files|grep enabled
查看启动失败的服务列表:systemctl --failed<br><br></span></pre>
<div>&nbsp; 那怎么开启一个端口呢</div>
<div>&nbsp; 添加</div>
<div>&nbsp; firewall-cmd&nbsp;<span class="attribute">--zone=<span class="attribute-value">public&nbsp;<span class="attribute">--add-port=<span class="attribute-value">80/tcp&nbsp;--permanent &nbsp; &nbsp;(--permanent永久生效,没有此参数重启后失效)</span></span></span></span></div>
<pre></pre>
<div>&nbsp; 重新载入</div>
<div><span class="attribute">&nbsp; &nbsp;firewall-cmd&nbsp;--reload</span></div>
<pre></pre>
<div>&nbsp; 查看</div>
<div><span class="attribute"><span class="attribute-value"><span class="attribute"><span class="attribute-value">&nbsp; firewall-cmd&nbsp;<span class="attribute">--zone=&nbsp;<span class="attribute-value">public&nbsp;<span class="attribute">--query-port=<span class="attribute-value">80/tcp</span></span></span></span></span></span></span></span></div>
<pre></pre>
<div>&nbsp; 删除</div>
<div>&nbsp; &nbsp;firewall-cmd&nbsp;<span class="attribute">--zone=&nbsp;<span class="attribute-value">public&nbsp;<span class="attribute">--remove-port=<span class="attribute-value">80/tcp&nbsp;--permanent</span></span></span></span></div>
</div>
</div>
<p>&nbsp;</p>
<p>&nbsp;mysql启动关闭命令</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">启动: service mysqld start
关闭: service mysqld stop<br>重启: service mysqld restart   ==systemctl restart mysqld</span></pre>
<p>&nbsp; 配置MySQL的开机自动启动</p>
<p><code class="language-cs">&nbsp; chkconfig --<span class="hljs-keyword">add mysql</span></code></p>
<p><code class="language-cs"></code><code class="language-cs"><span class="hljs-keyword">&nbsp; chkconfig mysqld <span class="hljs-keyword">on</span></span></code></p>
<pre><span style="color: rgba(0, 0, 0, 1)">查看mysql进程<br>ps -ef | <span class="hljs-keyword">grep mysqld</span><br></span></pre>
</div>
<p>&nbsp;</p>
<p>mysql相关的一些知识</p>
<h6 class="title-article"><span style="font-size: 14px">CentOS系统MySQL双机热备配置(主从同步)&nbsp;</span>https://blog.csdn.net/weixin_42604515/article/details/81299206</h6>
<pre>mysql安装成功。<br><br><br><br></pre>
<div class="cnblogs_code">
<pre>mysql中的配置<br><br>1.查看mysql 中的配置文件参数<br>show variables like '%xxx%'这里最后的参数就和我们平时写sql时候的模糊查询一样<br><br></pre>
<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190520190541333-1654957873.png" alt="">
<p>所有含有log的参数都出来了我们可以查看了&nbsp;</p>
<p>&nbsp;2.这里开启一下binlog日志</p>
<p>&nbsp; mysql 5.7 开启方式</p>
<p>&nbsp; &nbsp;vi /etc/my.cnf</p>
<p><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190520190749582-626189988.png" alt=""></p>
<p>只加了三行 网上荡的。</p>
<div class="cnblogs_code">
<pre>log_bin=<span style="color: rgba(0, 0, 0, 1)">mysql_bin
binlog</span>-format=<span style="color: rgba(0, 0, 0, 1)">Row
server</span>-id=<span style="color: rgba(128, 0, 128, 1)">1</span></pre>
</div>
<p>然后连接进入mysql 查看参数配置,这些是默认的配置,如果想改动,可以改动,需要去搜索一下。</p>
<p><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190520190959353-2018893241.png" alt=""></p>
<p>&nbsp;</p>
<p>这里边就是生成的binlog日志,后期出现问题了,可以更具binlog日志恢复数据</p>
<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190520191216850-1962548477.png" alt=""></div>
<p>&nbsp;3.使用binlog恢复数据</p>
<p class="p1"><span class="s1">查看binlog<span class="s1">日志</span></span></p>
<p class="p1">mysqlbinlog --no-defaults --base64-output=decode-rows -v mysql-bin.003271</p>
<p>&nbsp;</p>
</div>
</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(255, 0, 0, 1)"><strong>nginx安装<br></strong></span></pre>
<p><span style="color: rgba(255, 0, 0, 1)">一. gcc 安装</span><br>安装 nginx 需要先将官网下载的源码进行编译,编译依赖 gcc 环境,如果没有 gcc 环境,则需要安装:</p>
<pre><code class="hljs sql">yum <span class="hljs-keyword"><span class="hljs-keyword">install gcc-<span class="hljs-keyword">c++</span></span></span></code></pre>
<p><span style="color: rgba(255, 0, 0, 1)">二. PCRE pcre-devel 安装</span><br>PCRE(Perl Compatible Regular Expressions) 是一个Perl库,包括 perl 兼容的正则表达式库。nginx 的 http 模块使用 pcre 来解析正则表达式,所以需要在 linux 上安装 pcre 库,pcre-devel 是使用 pcre 开发的一个二次开发库。nginx也需要此库。命令:</p>
<pre><code class="hljs cmake">yum <span class="hljs-keyword"><span class="hljs-keyword">install -y pcre pcre-devel</span></span></code></pre>
<p><span style="color: rgba(255, 0, 0, 1)">三. zlib 安装</span><br>zlib 库提供了很多种压缩和解压缩的方式, nginx 使用 zlib 对 http 包的内容进行 gzip ,所以需要在 Centos 上安装 zlib 库。</p>
<pre><code class="hljs cmake">yum <span class="hljs-keyword"><span class="hljs-keyword">install -y zlib zlib-devel</span></span></code></pre>
<p><span style="color: rgba(255, 0, 0, 1)">四. OpenSSL 安装</span><br>OpenSSL 是一个强大的安全套接字层密码库,囊括主要的密码算法、常用的密钥和证书封装管理功能及 SSL 协议,并提供丰富的应用程序供测试或其它目的使用。<br>nginx 不仅支持 http 协议,还支持 https(即在ssl协议上传输http),所以需要在 Centos 安装 OpenSSL 库。</p>
<pre><code class="hljs cmake">yum <span class="hljs-keyword"><span class="hljs-keyword">install -y openssl openssl-devel<br><br><br><br>[<br><span style="text-decoration: underline"><strong><span style="color: rgba(255, 0, 0, 1); text-decoration: underline">上边的几个可以合成一个命令</span></strong></span><br><span style="font-size: 16px"><strong><span style="color: rgba(0, 0, 255, 1)">   yum -y install gcc zlib zlib-devel pcre-devel openssl openssl-devel</span></strong></span><br>]<br><br></span></span></code></pre>
<p><span style="color: rgba(255, 0, 0, 1)">五 nginx</span> 使用<code>wget</code>命令下载(推荐)。确保系统已经安装了wget,如果没有安装,执行 yum install wget 安装。</p>
<pre><code class="hljs swift">wget -<span class="hljs-built_in"><span class="hljs-built_in">c https:<span class="hljs-comment">//nginx.org/download/nginx-1.12.0.tar.gz</span></span></span></code></pre>
<h2 id="解压"><span style="font-size: 14px; color: rgba(255, 0, 0, 1)">解压</span></h2>
<p>依然是直接命令:</p>
<pre><code class="hljs css"><span class="hljs-selector-tag"><span class="hljs-selector-tag">tar <span class="hljs-selector-tag"><span class="hljs-selector-tag">-zxvf <span class="hljs-selector-tag"><span class="hljs-selector-tag">nginx-1<span class="hljs-selector-class"><span class="hljs-selector-class">.12<span class="hljs-selector-class"><span class="hljs-selector-class">.0<span class="hljs-selector-class"><span class="hljs-selector-class">.tar<span class="hljs-selector-class"><span class="hljs-selector-class">.gz
<span class="hljs-selector-tag"><span class="hljs-selector-tag">cd <span class="hljs-selector-tag"><span class="hljs-selector-tag">nginx-1<span class="hljs-selector-class"><span class="hljs-selector-class">.12<span class="hljs-selector-class"><span class="hljs-selector-class">.0</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code><br><br></pre>
<p>1.使用默认配置</p>
<pre><code class="hljs">./configure</code></pre>
<h2 id="编译安装"><span style="font-size: 14px; color: rgba(255, 0, 0, 1)">编译安装</span></h2>
<pre><code class="hljs go"><span class="hljs-built_in"><span class="hljs-built_in">make
<span class="hljs-built_in"><span class="hljs-built_in">make install</span></span></span></span></code></pre>
<p><span style="color: rgba(255, 0, 0, 1)">查询nginx进程:</span></p>
<pre><code class="hljs perl">ps aux|<span class="hljs-keyword"><span class="hljs-keyword">grep nginx</span></span></code></pre>
<pre></pre>
<h2 id="启动停止nginx"><span style="font-size: 15px; color: rgba(255, 0, 0, 1)">启动、停止nginx</span></h2>
<pre><code class="hljs bash"><span class="hljs-built_in"><span class="hljs-built_in">cd /usr/<span class="hljs-built_in"><span class="hljs-built_in">local/nginx/sbin/
./nginx
./nginx <span class="hljs-_">-s stop
./nginx <span class="hljs-_">-s quit
./nginx <span class="hljs-_">-s reload</span></span></span></span></span></span></span></code></pre>
<pre><br><br></pre>
</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre>tomcat这个下载下来就可以使用<br><br>只要修改配置文件就可以<br><br></pre>
<h5 id="四-实时查看运行日志" data-source-line="59">&nbsp;实时查看运行日志:</h5>
<p data-source-line="60">切换到:<code>cd usr/local/tomcat5/logs</code>,执行</p>
<div class="cnblogs_code">
<pre>tail -f catalina.out</pre>
</div>
<p data-source-line="64">这样运行时就可以实时查看运行日志了<br><code>Ctrl+c</code><span class="Apple-converted-space">&nbsp;是退出<code>tail</code>命令。</span></p>

















</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre><span style="font-size: 14pt"><strong><span style="color: rgba(255, 0, 0, 1)">docker安装<br></span></strong><span style="font-size: 14px; color: rgba(0, 0, 0, 1)">参考:<span style="color: rgba(0, 0, 0, 1)">https://www.cnblogs.com/yufeng218/p/8370670.html<br><br>阿里云的安装配置https://developer.aliyun.com/article/110806<br></span></span><span style="color: rgba(255, 0, 0, 1)"><span style="font-size: 14px; color: rgba(0, 0, 0, 1)"><br>1.检测当前版本的内核<br></span></span><span style="font-size: 14px"><span style="color: rgba(255, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)"> uname -r<br><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512172634812-302338551.png" alt=""><br><br><span style="font-size: 14pt"><span style="font-size: 14px"><span style="color: rgba(255, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)">2.使用root权限更新yum包</span></span></span></span></span></span></span></span></pre>
<pre><em><em><span style="font-size: 14pt"><span style="font-size: 14px"><span style="color: rgba(255, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)"> sudo yum update<br><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512172657170-1792203357.png" alt=""><br> <br>3.看看系统中是否安装过docker,如果没有就跳过这一步,安装过就卸载后安装,我没有安装过,直接跳过<br></span></span></span></span><em>sudo yum remove dockerdocker-common docker-selinux docker-engine<br><br>4.安装需要的软件包,&nbsp;yum-util 提供yum-config-manager功能,<span class="pln"><span class="com">另外两个是devicemapper驱动依赖的</span></span><br></em></em></em></pre>
<pre> sudo yum install -y yum-utils device-mapper-persistent-data lvm2</pre>
&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512173547660-723465805.png" alt="">
<pre><span style="font-size: 14pt"><span style="font-size: 14px"><span style="color: rgba(255, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)">5.设置下载的yum源<br></span></span></span></span>sudo yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo</pre>
<pre><em><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512173231138-1289733826.png" alt=""></em></pre>
<p>&nbsp; 6.查看所有仓库中的docker版本</p>
<p>&nbsp; &nbsp;yum list docker-ce --showduplicates | sort -r</p>
<p><em>&nbsp; &nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512173355867-1309554308.png" alt=""></em></p>
<p>&nbsp;</p>
<p>&nbsp; &nbsp;7.安装docker</p>
<p>&nbsp; &nbsp; 这里docker-ce后什么都不写,默认是最新版本的。可以根据自己的需求,加上版本号</p>
<p>&nbsp; &nbsp; sudo yum install docker-ce</p>
<p>&nbsp; &nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512173753861-1268757547.png" alt=""></p>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512174410019-733072777.png" alt=""></p>
<p>&nbsp; &nbsp;执行过程中,有几步是需要输入 是否y/n 的,我这里全部输入了 y&nbsp; 不知道什么意思就直接全部y了。</p>
<p>&nbsp; &nbsp;好了,安装成功。</p>
<pre><code class="bash hljs" data-spm-anchor-id="a2c6h.12873639.0.i1.1aba47efLYMYXw"><span class="hljs-comment" data-spm-anchor-id="a2c6h.12873639.0.i2.1aba47efLYMYXw"><br> Step 4: 开启Docker服务<br></span></code><em id="__mceDel"><code class="bash hljs" data-spm-anchor-id="a2c6h.12873639.0.i1.1aba47efLYMYXw">sudo service docker start</code></em></pre>
<p><code class="bash hljs" data-spm-anchor-id="a2c6h.12873639.0.i1.1aba47efLYMYXw">&nbsp;</code></p>
<p>&nbsp; 8.可以查看一下了,版本号</p>
<p>&nbsp; &nbsp;docker -v</p>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512174630411-644355994.png" alt=""></p>
<p>&nbsp;</p>
<p>&nbsp;&nbsp;docker version :显示 Docker 版本信息。</p>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512174704432-724711160.png" alt=""></p>
<p>&nbsp; 这里docker version 最后一个写实的有问题,没有连接到这个东西,问是否守护进程开启了。</p>
<p>&nbsp;</p>
<p>&nbsp; 9.启动并加入开机启动</p>
<p>&nbsp;&nbsp;<em id="__mceDel">sudo systemctl start docker</em></p>
<p><em>&nbsp; 执行完成这一句,启动docker,然后再试试docker version&nbsp; 好了</em></p>
<p><em>&nbsp; &nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512175101055-2081484090.png" alt=""></em></p>
<p>&nbsp; &nbsp;把docker 加入到开机启动服务里边</p>
<pre><em>sudo systemctl enable docker<br><br><br>好了docker 安装好了。开始使用docker玩了。<br><br></em></pre>
<div class="cnblogs_code">
<pre><span style="font-size: 16px"><strong><span style="color: rgba(255, 0, 0, 1)">docker配置阿里云的镜像<br><br></span></strong><span style="color: rgba(255, 0, 0, 1); font-size: 14px"><span style="color: rgba(0, 0, 0, 1)">1.登陆阿里云<br>https://cr.console.aliyun.com/cn-hangzhou/instances/mirrors这是我的镜像的地址。<br><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512181430844-820127161.png" alt=""></span></span></span></pre>
<p>&nbsp;&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512181500740-2061092156.png" alt=""></p>
<p>&nbsp; 这里就是镜像的地址了,</p>
<p><img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512181533587-804900740.png" alt=""></p>
<p>&nbsp;我们可以更具我们的系统,选择不同的操作方式。阿里云还是写的很详细的。</p>
<p>&nbsp; 我的/etc/docker/ 下是没有daemon.json 文件的。</p>
<p>&nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512181719141-1876490552.png" alt=""></p>
<p>&nbsp; 原因位置,所以就没有管他,直接执行阿里给出的命令就行了,大概就是创建一个文件,然后把加速地址按照给出的json的格式加入,然后保存,最后重启</p>
<p>&nbsp;&nbsp;sudo systemctl daemon-reload</p>
<p>&nbsp; sudo systemctl restart docker</p>
<p>&nbsp; &nbsp;然后可以查看docker的信息</p>
<p>&nbsp; &nbsp;命令: docker info</p>
<p>&nbsp; &nbsp;<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190512182134756-584696690.png" alt=""></p>
<p><em id="__mceDel">&nbsp; &nbsp;这样就加入了。可以测试了</em></p>
<p><em id="__mceDel">&nbsp; &nbsp;</em></p>
</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<pre>docker测试,这里测试一个docker网上的测试镜像<br>运行镜像:如果没有会从docker官网上拉取(我们这里已经把地址换成阿里云了)</pre>
<pre><span>docker run hello-world</span></pre>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)"># docker run hello-world
Unable to find image 'hello-world:latest' locally
latest: Pulling from library/hello-world
1b930d010525: Pull complete
Digest: sha256:5f179596a7335398b805f036f7e8561b6f0e32cd30a32f5e19d17a3cda6cc33d
Status: Downloaded newer image for hello-world:latest

Hello from Docker!
This message shows that your installation appears to be working correctly.

To generate this message, Docker took the following steps:
1. The Docker client contacted the Docker daemon.
2. The Docker daemon pulled the "hello-world" image from the Docker Hub.
    (amd64)
3. The Docker daemon created a new container from that image which runs the
    executable that produces the output you are currently reading.
4. The Docker daemon streamed that output to the Docker client, which sent it
    to your terminal.

To try something more ambitious, you can run an Ubuntu container with:
$ docker run -it ubuntu bash

Share images, automate workflows, and more with a free Docker ID:
https://hub.docker.com/

For more examples and ideas, visit:
https://docs.docker.com/get-started/

# </span></pre>
</div>
<p>&nbsp;</p>
</div>
<p>&nbsp;</p>
<pre><em id="__mceDel">&nbsp;</em></pre>
<pre><em id="__mceDel">&nbsp;</em></pre>
<pre><span style="font-size: 14pt"><span style="font-size: 14px"><span style="color: rgba(255, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)"><br><br>按照参考博客写的就可以了。自己这里执行一遍,把过程记录下来,为了方便自己以后查询。</span></span></span></span></pre>
<p>&nbsp;</p>
<pre><span style="font-size: 14pt"><span style="font-size: 14px"><span style="color: rgba(255, 0, 0, 1)"><span style="color: rgba(0, 0, 0, 1)"><br><br></span><br></span><strong><span style="color: rgba(255, 0, 0, 1)"><br></span></strong></span></span></pre>
<p>&nbsp;</p>
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<div class="cnblogs_code">
<div class="cnblogs_code">
<pre>ps:想要安装rz和sz<br><br>https://blog.csdn.net/singebogo/article/details/72761120<br>出现了一个问题是了一下这个博客里边的两个命令<br>1.yum -y install fontconfig-devel<br>2.yum -y install libXpm-devel<br><br> 没有安装wget,没有gcc下载的这个系统真的是很干净啊。<br> 先安装wget----&gt;<span class="hljs-attribute">yum&nbsp;-y install wget</span><br> 在安装gcc   ----&gt;yum install gcc&nbsp;</pre>
<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190507200500352-593744140.png" alt="">
<pre><br>然后在编译就行了。<br><br>rz和sz 安装任然错误中,</pre>
<img src="https://img2018.cnblogs.com/blog/1197493/201905/1197493-20190507201016960-1232450257.png" alt="">
<p>&nbsp;</p>
<p>&nbsp;</p>
</div>
</div>
<style>p.p1 { margin: 0; font: 12px "Helvetica Neue" }</style>
<div class="cnblogs_code">
<p class="p1">&nbsp;</p>
<p class="p1">rz上传文件的一个软件</p>
<p class="p1">&nbsp;</p>
<p class="p1">yum install lrzsz</p>
<p class="p1">&nbsp;</p>
<p class="p1">安装好后就可以使用上传命令rz和下载命令sz 了</p>
</div>
<p>&nbsp;</p>
<div class="cnblogs_code">
<div class="cnblogs_code">
<pre><span style="font-size: 15px"><strong><span style="color: rgba(0, 0, 0, 1)">rabbitmq的安装

</span></strong></span><span style="color: rgba(128, 0, 128, 1)">1</span><span style="color: rgba(0, 0, 0, 1)">.安装erlang
yum install erlang

「<br> <span style="color: rgba(255, 0, 255, 1)"> 如报错No package erlang available,需要安装EPEL库
  </span></span><span style="color: rgba(255, 0, 255, 1)">1.安装wget
  yum -y install wget
  2.安装EPEL库
  下载
  wget http://</span><span style="color: rgba(0, 128, 0, 1)"><span style="color: rgba(255, 0, 255, 1)">dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm</span><br></span>」
<span style="color: rgba(0, 0, 0, 1)">
安装
rpm </span>-ivh epel-release-<span style="color: rgba(128, 0, 128, 1)">6</span>-<span style="color: rgba(128, 0, 128, 1)">8</span><span style="color: rgba(0, 0, 0, 1)">.noarch.rpm

</span><span style="color: rgba(128, 0, 128, 1)">2</span><span style="color: rgba(0, 0, 0, 1)">.安装RabbitMQ rpm包
下载
wget http:</span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">www.rabbitmq.com/releases/rabbitmq-server/v3.5.0/rabbitmq-server-3.5.0-1.noarch.rpm</span>
<span style="color: rgba(0, 0, 0, 1)">
安装
rpm </span>-ivh rabbitmq-server-<span style="color: rgba(128, 0, 128, 1)">3.5</span>.<span style="color: rgba(128, 0, 128, 1)">0</span>-<span style="color: rgba(128, 0, 128, 1)">1</span><span style="color: rgba(0, 0, 0, 1)">.noarch.rpm

</span><span style="color: rgba(128, 0, 128, 1)">3</span><span style="color: rgba(0, 0, 0, 1)">.启动rabbitmq,并验证启动情况
rabbitmq</span>-server --detached &amp;ps aux |<span style="color: rgba(0, 0, 0, 1)">grep rabbitmq

</span><span style="color: rgba(128, 0, 128, 1)">4</span><span style="color: rgba(0, 0, 0, 1)">.以服务的方式启动
service rabbitmq</span>-server start<br><br><br>5.<em id="__mceDel" style="font-family: &quot;Helvetica Neue&quot;">问题</em></pre>
<p class="p1">&nbsp; &nbsp; &nbsp;启动RabbitMQ后,没法访问Web管理页面</p>
<p class="p1">&nbsp; &nbsp; &nbsp;解决</p>
<p class="p1">&nbsp; &nbsp; RabbitMQ安装后默认是不启动管理模块的,所以需要配置将管理模块启动<span class="Apple-converted-space">&nbsp;</span></p>
<p class="p1">&nbsp; &nbsp; 启动管理模块命令如下</p>
<p class="p1">&nbsp; &nbsp; rabbitmq-plugins enable rabbitmq_management</p>
<p class="p1">&nbsp;</p>
<p class="p1">&nbsp;</p>
<p class="p1">&nbsp;</p>
<p class="p1">&nbsp;</p>
<p class="p1">&nbsp;</p>
<div class="cnblogs_code">
<pre><span style="font-size: 16px; font-family: 幼圆"><strong><span style="color: rgba(255, 0, 0, 1)">安装高一点版本点rabbitmq<br><br>erl和rabbitmq版本需要对比<br>https://www.rabbitmq.com/which-erlang.html<br></span></strong></span><br>1<span style="color: rgba(0, 0, 0, 1)">.安装erlang
yum install erlang

</span>2.安装RabbitMQ rpm包「需要安装版本高一点,否则这里找不到rabbitmq-<span style="color: rgba(0, 0, 0, 1)">top」不知道怎么安装
下载
wget https:</span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">www.rabbitmq.com/releases/rabbitmq-server/v3.6.14/rabbitmq-server-3.6.14-1.el7.noarch.rpm</span>
<span style="color: rgba(0, 0, 0, 1)">
安装
rpm </span>-ivh rabbitmq-server-3.6.14-1<span style="color: rgba(0, 0, 0, 1)">.el7.noarch.rpm

问题

# rpm -ivh --relocate /=/www/server/rabbitmq rabbitmq-server-3.6.14-1<span style="color: rgba(0, 0, 0, 1)">.el7.noarch.rpm
警告:rabbitmq</span>-server-3.6.14-1.el7.noarch.rpm: 头V4 RSA/<span style="color: rgba(0, 0, 0, 1)">SHA512 Signature, 密钥 ID 6026dfca: NOKEY
错误:依赖检测失败:
      socat 被 rabbitmq</span>-server-3.6.14-1<span style="color: rgba(0, 0, 0, 1)">.el7.noarch 需要
# yum install socat



</span>3<span style="color: rgba(0, 0, 0, 1)">.启动rabbitmq,并验证启动情况
rabbitmq</span>-server --detached &amp;ps aux |<span style="color: rgba(0, 0, 0, 1)">grep rabbitmq

</span>4.以服务的方式启动       /bin/systemctl start rabbitmq-server.service       /bin/systemctl restart rabbitmq-<span style="color: rgba(0, 0, 0, 1)">server.service
service rabbitmq</span>-<span style="color: rgba(0, 0, 0, 1)">server start


</span>5<span style="color: rgba(0, 0, 0, 1)">.启用维护插件
rabbitmq</span>-<span style="color: rgba(0, 0, 0, 1)">plugins enable rabbitmq_management

</span>6<span style="color: rgba(0, 0, 0, 1)">.重启RabbitMQ
service rabbitmq</span>-<span style="color: rgba(0, 0, 0, 1)">server restart

</span>7<span style="color: rgba(0, 0, 0, 1)">.访问UI界面
http:</span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">your ip:15672 用户名密码:guest<br><br><br><br><span style="font-family: 隶书; font-size: 16px"><strong><span style="color: rgba(255, 0, 0, 1)">ps:如果安装的完成启动报错</span></strong></span><br><img src="https://img2020.cnblogs.com/blog/1197493/202007/1197493-20200710134935094-2117281853.png" alt="" loading="lazy"></span></pre>
<div class="cnblogs_code">
<pre># ./rabbitmq-<span style="color: rgba(0, 0, 0, 1)">server
{</span><span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">init terminating in do_boot</span><span style="color: rgba(128, 0, 0, 1)">"</span>,{undef,[{rabbit_misc,quit,[<span style="color: rgba(128, 0, 128, 1)">0</span>],[]},{rabbit_prelaunch,start,<span style="color: rgba(128, 0, 128, 1)">0</span>,[]},{init,start_em,<span style="color: rgba(128, 0, 128, 1)">1</span>,[]},{init,do_boot,<span style="color: rgba(128, 0, 128, 1)">3</span><span style="color: rgba(0, 0, 0, 1)">,[]}]}}
init terminating </span><span style="color: rgba(0, 0, 255, 1)">in</span> do_boot ({undef,[{rabbit_misc,quit,[<span style="color: rgba(128, 0, 128, 1)">0</span>],[]},{rabbit_prelaunch,start,<span style="color: rgba(128, 0, 128, 1)">0</span>,[]},{init,start_em,<span style="color: rgba(128, 0, 128, 1)">1</span>,[]},{init,do_boot,<span style="color: rgba(128, 0, 128, 1)">3</span><span style="color: rgba(0, 0, 0, 1)">,[]}]})

Crash dump </span><span style="color: rgba(0, 0, 255, 1)">is</span><span style="color: rgba(0, 0, 0, 1)"> being written to: erl_crash.dump...done
# .</span>/rabbitmq-<span style="color: rgba(0, 0, 0, 1)">server
{</span><span style="color: rgba(128, 0, 0, 1)">"</span><span style="color: rgba(128, 0, 0, 1)">init terminating in do_boot</span><span style="color: rgba(128, 0, 0, 1)">"</span>,{undef,[{rabbit_misc,quit,[<span style="color: rgba(128, 0, 128, 1)">0</span>],[]},{rabbit_prelaunch,start,<span style="color: rgba(128, 0, 128, 1)">0</span>,[]},{init,start_em,<span style="color: rgba(128, 0, 128, 1)">1</span>,[]},{init,do_boot,<span style="color: rgba(128, 0, 128, 1)">3</span><span style="color: rgba(0, 0, 0, 1)">,[]}]}}
init terminating </span><span style="color: rgba(0, 0, 255, 1)">in</span> do_boot ({undef,[{rabbit_misc,quit,[<span style="color: rgba(128, 0, 128, 1)">0</span>],[]},{rabbit_prelaunch,start,<span style="color: rgba(128, 0, 128, 1)">0</span>,[]},{init,start_em,<span style="color: rgba(128, 0, 128, 1)">1</span>,[]},{init,do_boot,<span style="color: rgba(128, 0, 128, 1)">3</span><span style="color: rgba(0, 0, 0, 1)">,[]}]})

Crash dump </span><span style="color: rgba(0, 0, 255, 1)">is</span><span style="color: rgba(0, 0, 0, 1)"> being written to: erl_crash.dump...done
# chmod </span>-R rabbitmq:rabbitmq /<span style="color: rgba(0, 0, 255, 1)">var</span>/log/rabbitmq/</pre>
</div>
<p>这个问题我这里的解决办法就是erl和rbbitmq的版本对应不行,需要去查找他们对应的版本然后重新安装就可以了</p>
<pre><strong>erl和rabbitmq版本需要对比<br>https://www.rabbitmq.com/which-erlang.html</strong></pre>
<pre><span style="color: rgba(0, 128, 0, 1)"><br><br><br><span style="color: rgba(0, 0, 0, 1)">8,登录不上去问题:<br><img src="https://img2020.cnblogs.com/blog/1197493/202006/1197493-20200630222515343-1609538822.png" alt="" loading="lazy"></span></span></pre>
<p>&nbsp;</p>
<pre></pre>
<p>&nbsp;这里问题是因为高版本点rabbitmq禁用guest/guest权限通过localhost外访问,解决办法好到rabbitmq/ebin/rabbit.app</p>
<p>通过rpm安装找不到安装目录可以通过&nbsp; &nbsp;<span style="color: rgba(255, 0, 0, 1)">find -name rabbit.app</span>&nbsp; 查找,然后修改一个参数</p>
<p><img src="https://img2020.cnblogs.com/blog/1197493/202006/1197493-20200630223003900-461468696.png" alt="" loading="lazy"></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<pre><span style="color: rgba(0, 128, 0, 1)"><img src="https://img2020.cnblogs.com/blog/1197493/202006/1197493-20200630223042051-431597136.png" alt="" loading="lazy"></span></pre>
<p>&nbsp;</p>
<pre></pre>
<p>&nbsp;</p>
<pre><span style="color: rgba(0, 128, 0, 1)"><span style="color: rgba(0, 0, 0, 1)">修改配置文件后需要重启服务才可以登录<br>server rabbitmq-server restart<br></span>或者<br></span></pre>
<pre>/bin/systemctl restart rabbitmq-<span>server.service</span></pre>
<pre><span style="color: rgba(0, 128, 0, 1)">然后通过http://ip:15672登录就可以了</span></pre>
</div>
<p><em id="__mceDel">&nbsp;</em></p>
<div class="cnblogs_code">
<div class="cnblogs_code">
<p class="p1">如果还是连接不上,那么查看防火墙的端口是否打开,没有就添加端口,<span style="color: rgba(255, 0, 255, 1)">然后重启,一定要重启,不重启,不生效的</span></p>
<p class="p1">&nbsp;</p>
<p class="p1"><span style="color: rgba(0, 0, 0, 1)">查看已开放的端口</span></p>
<p class="p1"><span style="color: rgba(0, 0, 0, 1)"> firewall-cmd --list-ports</span></p>
<p class="p1">&nbsp;</p>
<p class="p1">配置防火墙开放端口</p>
<p class="p1">firewall-cmd --permanent --zone=public --add-port=15672/tcp</p>
<p class="p1">firewall-cmd --permanent --zone=public --add-port=5672/tcp</p>
<p class="p1">重新加载firewall</p>
<p class="p1">firewall-cmd --reload</p>
<p class="p1">&nbsp;</p>
</div>
</div>
</div>
</div>
<style>p.p1 { margin: 0; font: 12px "Helvetica Neue" }</style>
<div class="cnblogs_code">
<p class="p1"><strong><span style="font-size: 14px">rabbitmq操作命令</span></strong></p>
<p class="p1">查看所有用户</p>
<p class="p1">rabbitmqctl list_users</p>
<p class="p1">添加一个用户</p>
<p class="p1">rabbitmqctl add_user admin admin</p>
<p class="p1">配置权限</p>
<p class="p1">rabbitmqctl set_permissions -p "/" admin ".*" ".*" ".*"</p>
<p class="p1">查看用户权限</p>
<p class="p1">rabbitmqctl list_user_permissions admin</p>
<p class="p1">设置tag</p>
<p class="p1">rabbitmqctl set_user_tags admin administrator</p>
<p class="p1">删除用户(安全起见,删除默认用户)</p>
<p class="p1">rabbitmqctl delete_user guest</p>
</div>
<p>&nbsp;</p>
<style>p.p1 { margin: 0; font: 12px "Helvetica Neue" }
span.s1 { font: 12px ".PingFang SC" }</style>
<style>p.p1 { margin: 0; font: 12px "Helvetica Neue" }</style><br><br>
来源:https://www.cnblogs.com/renjianjun/p/10824730.html
頁: [1]
查看完整版本: CentOS 7 64位