打赏

打赏 jQuery火箭图标返回顶部代码</h1> <hr> <div id="cnblogs_post_body" class="blogpost-body"> <h2>MySQl介绍</h2> 官方站点：<a href="http://www.mysql.com/" target="_blank">http://www.mysql.com/</a> MySQL是一个开放源码的小型关联式数据库管理系统。目前MySQL被广泛地应用在Internet上的中小型网站中。由于其体积小、速度快、总体拥有成本低，尤其是开放源码这一特点，许多中小型网站为了降低网站总体拥有成本而选择了MySQL作为网站数据库。 MySQl数据库分类 1）社区版 2）商业版 3）cluster集群 <h2>一.安装简介</h2> <h4>1）创建mysql用户的账号</h4> 首先以root身份登录到Linux系统中，然后执行如下命令创建mysql组及用户账号： <div class="cnblogs_code"> <pre>1 [root@king ~]# groupadd mysql 2 [root@king ~]# useradd -s /sbin/nologin -g mysql -M mysql</pre> </div> <table id="1" style="border: 0 solid rgba(34, 220, 57, 1); background-color: rgba(210, 218, 218, 1); height: 111px; 1086px" border="0" cellspacing="1"> <tbody> <tr><th>useradd命令的参数简要说明</th></tr> <tr> <td>　　　　-s/sbin/nologin表示禁止该用户登录，只需要角色存在即可，加强安全。</td> </tr> <tr> <td>　　　　-g mysql指定mysql用户属于mysql组。</td> </tr> <tr> <td>　　　　-M表示不创建用户家目录，因为没有需要。</td> </tr> <tr> <td>　　　　groupadd和useradd这两条命令也可以用useradd-s/sbin/nologin-M mysql替代。</td> </tr> </tbody> </table> 然后检查刚刚创建的mysql用户和组，如下： <div class="cnblogs_code"> <pre>1 [root@king ~]# tail -1 /etc/passwd 2 mysql：x：501：501：：/home/mysql：/sbin/nologin 3 [root@king ~]# id mysql 4 uid=501（mysql）gid=501（mysql）组=501（mysql）</pre> </div> 现在建立一个存放所有安装软件的固定目录，如下： <div class="cnblogs_code"> <pre>1 [root@king ~]# mkdir -p /home/king/tools 2 [root@king ~]# cd /home/king/tools/</pre> </div> <h2>二.获取MySQL软件包</h2> 1.MySQL软件包的下载地址为： <a title="mysql下载教程" target="_blank">https://dev.mysql.com/</a> ，<a href="https://www.cnblogs.com/liang-io/p/9492371.html" target="_blank">官网下载示例点我</a>， 2.现在以rz命令从本地安装来演示部署过程，执行时如提示无rz命令，可先执行yum install lrzsz-y安装，如下： <div class="cnblogs_code"> <pre>1 [root@king tools]# cd /home/oldboy/tools/ 2 [root@king tools]# rz 3 rz waiting to receive.开始zmodem传输。按Ctrl+C取消正在传输mysql-5.5.32-linux2.6-x86_64.tar.gz... 4 100% 182346 KB 5525 KB/s 00：00：11 0 错误 5 [root@king tools]# ls -sh mysql-5.5.32-linux2.6-x86_64.tar.gz 6 179M mysql-5.5.32-linux2.6-x86_64.tar.gz</pre> </div> <div class="msg-text normal-text"> <div class="origin-content">三　采用二进制方式安装MySQL （1）解压并移动MySQL二进制软件包到指定的安装路径，命令如下：</div> <div class="origin-content"> <div class="cnblogs_code"> <pre>1 [root@king tools]# tar xf mysql-5.7.32-linux2.6-x86_64.tar.gz 2 #<==解压 3 [root@king tools]# mkdir -p /application/ #<==创建安装目录，如果有就不用创建了 4 [root@king tools]# mv mysql-5.7.32-linux2.6-x86_64 /application/mysql-5.7.32 5 #<==移动并改名目录</pre> </div> （2）创建软链接，生成去掉版本号的访问路径并查看，命令如下：</div> <div class="origin-content"> <div class="cnblogs_code"> <pre>1 [root@king tools]# ln -s /application/mysql-5.7.32/ /application/mysql</pre> </div> </div> <div class="origin-content"> <h2>三.初始化MySQL数据库文件</h2> 初始化命令如下：</div> <div class="origin-content"> <div class="cnblogs_code"> <pre> 1 [root@king mysql]# mkdir -p /application/mysql/data 2 #<==建立MySQL数据文件目录 3 [root@king mysql]# chown -R mysql.mysql /application/mysql/ 4 #<==授权mysql用户管理MySQL的安装目录 5 [root@king mysql]# /application/mysql/scripts/mysql_install_db --basedir= 6 /application/mysql --datadir=/application/mysql/data --user=mysql 7 #<==初始化MySQL数据库文件，会有很多信息提示，如果没有ERROR级别 8 的错误，会有两个OK的字样，表示初始化成功，否则就要解决初始化的问题 9 WARNING： The host 'www' could not be looked up with resolveip. 10 This probably means that your libc libraries are not 100 % compatible 11 with this binary MySQL version. The MySQL daemon，mysqld，should work 12 normally with the exception that host name resolving will not work. 13 This means that you should use IP addresses instead of hostnames 14 when specifying MySQL privileges ！ 15 Installing MySQL system tables... 16 OK 17 Filling help tables... 18 OK 19 To start mysqld at boot time you have to copy 20 support-files/mysql.server to the right place for your system 21 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ！ 22 To do so，start the server，then issue the following commands： 23 /application/mysql/bin/mysqladmin -u root password 'new-password' 24 /application/mysql/bin/mysqladmin -u root -h www password 'new-password' 25 Alternatively you can run： 26 /application/mysql/bin/mysql_secure_installation 27 which will also give you the option of removing the test 28 databases and anonymous user created by default. This is 29 strongly recommended for production servers. 30 See the manual for more instructions. 31 You can start the MySQL daemon with： 32 cd /application/mysql；/application/mysql/bin/mysqld_safe & 33 You can test the MySQL daemon with mysql-test-run.pl 34 cd /application/mysql/mysql-test；perl mysql-test-run.pl 35 Please report any problems with the /application/mysql/scripts/mysqlbug script！</pre> </div> </div> <div class="origin-content"> <h2>四.初始化故障排错集锦</h2> 错误示例1：WARNING：The host'mysql'could not be looked up with resolveip. 需修改主机名的解析，使其和uname-n一样，修改后的结果如下：</div> <div class="origin-content"> <div class="cnblogs_code"> <pre>1 [root@king mysql]# grep `uname -n` /etc/hosts 2 127.0.0.1 www localhost.localdomain localhost</pre> </div> 错误示例2：ERROR：1004 Can't create file'/tmp/#sql300e_1_0.frm'（errno：13）</div> <div class="origin-content">原因是/tmp目录的权限有问题。 解决办法为处理/tmp目录，如下：</div> <div class="origin-content"> <div class="cnblogs_code"> <pre>1 [root@king mysql]# ls -ld /tmp 2 drwxrwxrwt. 4 root root 4096 Aug 17 11：44 /tmp 3 [root@king mysql]# chmod -R 4777 /tmp/</pre> </div> </div> <div class="origin-content"> <h2>五.配置并启动MySQL</h2> <h4>1）设置MySQL启动脚本，如下：</h4> <div class="cnblogs_code"> <pre>1 [root@king mysql]# cp support-files/mysql.server /etc/init.d/mysqld 2 #<==拷贝MySQL启动脚本到MySQL的命令路径 3 [root@king mysql]# chmod +x /etc/init.d/mysqld 4 #<==使脚本可执行</pre> </div> <h4>2）MySQL二进制默认安装路径是/usr/local/mysql，启动脚本里是/usr/local/mysql的路径都需要替换，如下：</h4> <div class="cnblogs_code"> <pre>1 [root@king mysql]# sed -i 's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe /etc/init.d/mysqld</pre> </div> <h4>3）启动MySQL数据库，如下：</h4> <div class="cnblogs_code"> <pre>1 [root@king mysql]# sed -i 's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe /etc/init.d/mysqld</pre> </div> <h4>4）检查MySQL数据库是否启动，如下：</h4> <div class="cnblogs_code"> <pre>1 [root@king mysql]# netstat -lntup|grep mysql 2 tcp 0 0 0.0.0.0：3306 0.0.0.0：* LISTEN 9446/mysqld</pre> </div> <h4>5)设置MySQL开机自起动，如下：</h4> <div class="cnblogs_code"> <pre>1 [root@king mysql]# chkconfig --add mysqld 2 [root@king mysql]# chkconfig mysqld on 3 [root@king mysql]# chkconfig --list mysqld 4 mysqld 0：off 1：off 2：on 3：on 4：on 5：on 6：off</pre> </div> <h4>6)配置mysql命令的全局使用路径，如下：</h4> <div class="cnblogs_code"> <pre>1 [root@king mysql]# echo 'export PATH=/application/mysql/bin：$PATH' >>/etc/profile 2 #<==注意，echo后是单引号，双引号是不行滴。 3 [root@king mysql]# tail -1 /etc/profile 4 export PATH=/application/mysql/bin：$PATH 5 [root@king mysql]# source /etc/profile 6 #<==执行source使上一行添加到/etc/profile中的内容直接生效。</pre> </div> <h4>7)登陆MySQL数据库，如下</h4> <div class="cnblogs_code"> <pre>1 [root@king mysql]# mysql #<==直接敲就进入数据库了，而且身份还是root</pre> </div> <h2>六.MySQl安全配置</h2> <div class="msg-text normal-text"> <div class="origin-content"> <h4>为MySQL的root用户设置密码，命令如下：</h4> <div class="cnblogs_code"> <pre> 1 [root@king mysql]# mysqladmin -u root password 'liang123' #<==更改默认密码。 2 [root@king mysql]# mysql #<==无法直接登录了 3 ERROR 1045（28000）： Access denied for user 'root'@'localhost'（using password： NO） 4 [root@king mysql]# mysql -uroot -p #<==新的登录方式 5 Enter password： #<==输入新密码liang123 6 Welcome to the MySQL monitor. Commands end with；or g. 7 Your MySQL connection id is 4 8 Server version： 5.7.32 MySQL Community Server（GPL） 9 Copyright（c）2000，2018，Oracle and/or its affiliates. All rights reserved. 10 Oracle is a registered trademark of Oracle Corporation and/or its 11 affiliates. Other names may be trademarks of their respective 12 owners. 13 Type 'help；' or 'h' for help. Type 'c' to clear the current input statement. 14 mysql></pre> </div> </div> </div> </div> </div> </div> </li> <li class="list-group-item ul-li"> 相关阅读: <a href="SunBool-p-4834516.html" target="_blank">点击拖动，让物体旋转</a> <a href="SunBool-p-4808021.html" target="_blank">unity中让物体不能穿到另一个物体里面去</a> <a href="SunBool-p-4807108.html" target="_blank">XML一小节</a> <a href="SunBool-p-4800461.html" target="_blank">unity中摄像机的控制---调整摄像机，不让他摔倒</a> <a href="SunBool-p-4780339.html" target="_blank">Unity 制作游侠暂停</a> <a href="SunBool-p-4777809.html" target="_blank">unity使用 NGUI制作技能冷却效果的思路</a> <a href="SunBool-p-4775276.html" target="_blank">unity中设置贴图的透明</a> <a href="SunBool-p-4775135.html" target="_blank">C#中实现打开文件夹所在的位置</a> <a href="Hubz131-p-10916081.html" target="_blank">Windows下的MongoDB的安装与配置</a> <a href="Hubz131-p-10916055.html" target="_blank">Scrapy运行中常见网络相关错误</a> </li> <li class="list-group-item from-a mb-2"> 原文地址：https://www.cnblogs.com/liang-io/p/9492636.html </li> </ul> </div>  <div class="col-lg-4 col-sm-12"> <ul class="list-group" style="word-break:break-all;"> <li class="list-group-item ul-li-bg" aria-current="true"> 最新文章 </li> <li class="list-group-item ul-li"> <a href="ss815367696-p-7503857.html" target="_blank">python 操作 wave 文件的体会</a> <a href="ss815367696-p-4154330.html" target="_blank">HTML 基础</a> <a href="ss815367696-p-4057701.html" target="_blank">《数据挖掘概念与技术》——第四章数据仓库与联机分析处理</a> <a href="ss815367696-p-4052616.html" target="_blank">基础知识--UI布局设计</a> <a href="ss815367696-p-4051046.html" target="_blank">《数据挖掘概念与技术》--第三章数据预处理</a> <a href="ss815367696-p-4032232.html" target="_blank">什么是爱？——斯特凡·布罗德本特：互联网怎样使人们变得亲密</a> <a href="ss815367696-p-4029733.html" target="_blank">第二章认识数据笔记</a> <a href="ss815367696-p-3913547.html" target="_blank">Long time no see !</a> <a href="wengpengfeijava-p-6321908.html" target="_blank">Gulp-angular构建基本装备</a> <a href="wengpengfeijava-p-5919425.html" target="_blank">更新win10后英雄联盟出现锁帧，导致帧数稳定60上下不变的解决方案, xbox , 封顶</a> </li> </ul> <ul class="list-group pt-2" style="word-break:break-all;"> <li class="list-group-item ul-li-bg" aria-current="true"> 热门文章 </li> <li class="list-group-item ul-li"> <a href="wengpengfeijava-p-5824981.html" target="_blank">gulp项目工作流</a> <a href="wengpengfeijava-p-5807196.html" target="_blank">webstrom 因为关机或者死机各种原因导致功能缺失的解决方案</a> <a href="wengpengfeijava-p-5803878.html" target="_blank">神奇的webstorm</a> <a href="wengpengfeijava-p-5803706.html" target="_blank">使用正则表达式找出不包含特定字符串的条目</a> <a href="wengpengfeijava-p-5791017.html" target="_blank">给予gulp的前端构建解决方案</a> <a href="wengpengfeijava-p-5786622.html" target="_blank">private-bower</a> <a href="wengpengfeijava-p-5784926.html" target="_blank">收集正则</a> <a href="wengpengfeijava-p-5783358.html" target="_blank">360坑爹事件</a> <a href="SunBool-p-4876477.html" target="_blank">一点小小的心得吧</a> <a href="SunBool-p-4845548.html" target="_blank">Unity之UGUI初探—按钮动画</a> </li> </ul> </div> </div> </div>  <div class="text-center p-3">Copyright © 2020-2023 <a href="http://runxinzhi.com" target="_blank">润新知</a>    <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script>   </div> <script src="https://common.cnblogs.com/scripts/jquery-2.2.0.min.js"></script> <script src="https://www.cnblogs.com/js/blog-common.min.js"></script> <script src="http://common.cnblogs.com/script/encoder.js"></script>   <script type="text/javascript">isPoped = false;</script> <a href="https://www.aliyun.com/activity?userCode=smyam3bm" id="redirect_url"></a> <a href="/liang-io-p-9492636.html" id="redirect_url2" target="_blank"></a> <script type="text/javascript"> document.onclick = function() { if (!isPoped) { document.getElementById("redirect_url").click(); document.getElementById("redirect_url2").click(); isPoped = true; } } </script> </body> </html>