MySQL 8.0 安装[含Docker安装] - Win10

谁践踏了优雅 2023-05-28 05:15 22阅读 0赞

1.应用场景

<table> 
 <tbody> 
 <tr> 
 <td>搭建开发环境，安装MySQL.</td> 
 </tr> 
 </tbody> 
</table>

2.学习/操作

<table> 
 <tbody> 
 <tr> 
 <td> 环境: Windows 10 64位 mysql 8.0 备注: mysql 8.0即以上版本与 以下版本不太安装方式有些不一样. &nbsp; <h3>Host本机</h3> 1.下载 <a href="https://dev.mysql.com/downloads/mysql/" rel="nofollow">https://dev.mysql.com/downloads/mysql/</a> &nbsp; 目录结构 <img alt="" height="44" src="https://img-blog.csdnimg.cn/20200327172647953.png" width="246"> 2.安装 [解压即为安装] 直接解压到某一个工作开发目录下. <img alt="" height="123" src="https://img-blog.csdnimg.cn/20200327172618511.png" width="504"> &nbsp; &nbsp; 3. 配置目录 [数据目录] cmd 管理员权限进入 D:\wamp\mysql-8.0.19-winx64\bin 目录, 输入 mysqld --initialize-insecure 回车 生成data目录 <img alt="" height="242" src="https://img-blog.csdnimg.cn/20200327174550267.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpYW1fbg==,size_16,color_FFFFFF,t_70" width="501"> &nbsp; 4. 将mysql安装为Windows上的一个服务 输入mysqld -install &nbsp; <img alt="" height="224" src="https://img-blog.csdnimg.cn/20200327172527328.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpYW1fbg==,size_16,color_FFFFFF,t_70" width="500"> &nbsp; 计算机-&gt;管理-&gt;服务-&gt; 找到mysql <img alt="" height="87" src="https://img-blog.csdnimg.cn/20200327175330872.png" width="570"> &nbsp; 5.启动服务 [mysql, 不分区大小写] <h3>net start mysql</h3> <img alt="" height="117" src="https://img-blog.csdnimg.cn/20200327175439609.png" width="407"> 也可以设置为: 开机启动服务 &nbsp; 6.登录mysql 输入: mysql -uroot -p 回车 此时密码默认为空 直接回车即可. <img alt="" height="237" src="https://img-blog.csdnimg.cn/20200327180500157.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpYW1fbg==,size_16,color_FFFFFF,t_70" width="594"> &nbsp; 7.修改root账户密码 输入: ALTER USER 'root'@'localhost' IDENTIFIED BY 'Nxf=2020'; <img alt="" height="96" src="https://img-blog.csdnimg.cn/20200327181520358.png" width="558"> &nbsp; 退出mysql,[输入exit回车即可] 重新登录 输入密码: Nxf=2020 回车即可. <img alt="" height="238" src="https://img-blog.csdnimg.cn/20200327181744118.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpYW1fbg==,size_16,color_FFFFFF,t_70" width="511"> &nbsp; 8.配置系统环境变量 在系统环境变量path中添加 D:\wamp\mysql-8.0.19-winx64\bin 即可. &nbsp; <img alt="" height="48" src="https://img-blog.csdnimg.cn/20200327182123248.png" width="295"> 备注: 要让path生效. //新开一个cmd窗口,输入path回车即可,后关掉. <img alt="" height="65" src="https://img-blog.csdnimg.cn/20200327182352849.png" width="792"> &nbsp; 9. 测试mysql命令 [在任意目录是否可以使用mysql命令] <img alt="" height="103" src="https://img-blog.csdnimg.cn/20200327182527462.png" width="371"> 正常进入. &nbsp; &nbsp; 10. 可视化管理工具连接数据库-测试 详细见: <a href="https://blog.csdn.net/william_n/article/details/80288057" rel="nofollow">https://blog.csdn.net/william_n/article/details/80288057</a> <img alt="" height="420" src="https://img-blog.csdnimg.cn/20200330105619135.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpYW1fbg==,size_16,color_FFFFFF,t_70" width="700"> <img alt="" height="272" src="https://img-blog.csdnimg.cn/20200330105737787.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpYW1fbg==,size_16,color_FFFFFF,t_70" width="545"> 正常连接. Okay. &nbsp; 11. 项目中使用PDO测试连接数据库 code: 
 <blockquote> 
 &nbsp; 
 &lt;?php 
 class Model extends PDO { &nbsp;&nbsp;&nbsp; public function __construct() &nbsp;&nbsp;&nbsp; { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $dbms = 'mysql';&nbsp;&nbsp;&nbsp; //数据库类型 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $host = 'localhost';&nbsp; //数据库主机名 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $dbName = 'test';&nbsp;&nbsp;&nbsp;&nbsp; //使用的数据库 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $username = 'root';&nbsp;&nbsp; //数据库连接用户名 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $passwd = 'Nxf=2020'; //对应的密码 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $dsn = "$dbms:host=$host;dbname=$dbName"; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parent::__construct($dsn, $username, $passwd); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }catch(PDOException $exception){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var_dump($exception-&gt;getMessage()); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp; } } 
 $model = new Model; $sql = "SELECT * FROM test"; foreach ($model-&gt;query($sql) as $row) { &nbsp;&nbsp; &nbsp;print $row['id'] . "\t"; &nbsp;&nbsp; &nbsp;print $row['title'] . "\t"; &nbsp;&nbsp; &nbsp;print $row['author'] . "\n"; } 
 </blockquote> 更多PDO操作： <a href="https://www.runoob.com/php/pdo-query.html" rel="nofollow">https://www.runoob.com/php/pdo-query.html</a> &nbsp; 数据表： <img alt="" height="125" src="https://img-blog.csdnimg.cn/20200402161257724.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dpbGxpYW1fbg==,size_16,color_FFFFFF,t_70" width="406"> &nbsp; 输出结果: <img alt="" height="90" src="https://img-blog.csdnimg.cn/20200402161157423.png" width="246"> &nbsp; 可知，交互正常。 &nbsp; 12.root用户创建新用户，并且授权 -- 创建用户 -- create user 'william'@'localhost' identified BY '123456'; -- 授权 -- grant all on *.* to 'william'@'localhost' with grant option; 详情：<a href="https://blog.csdn.net/qq_39820860/article/details/82718211" rel="nofollow">https://blog.csdn.net/qq_39820860/article/details/82718211</a>&nbsp;//mysql中如何用root用户创建普通用户并给其授权 &nbsp; <h3>Docker 镜像容器</h3> <a href="https://blog.csdn.net/william_n/article/details/112728377" rel="nofollow">https://blog.csdn.net/william_n/article/details/112728377</a>&nbsp;//&nbsp;MySQL 8.0 - Docker安装 - Win10 - 学习/实践 &nbsp; &nbsp; &nbsp; &nbsp; 后续补充 ... </td> 
 </tr> 
 </tbody> 
</table>

3.问题/补充

<table> 
 <tbody> 
 <tr> 
 <td> 1.执行mysqld -install 提示vcruntime140_1.dll 缺失 解决方案: 下载vcruntime140_1.dll , 然后放到 <code>C:\Windows\System32</code> 重试即可. &nbsp; 2.为Windows安装/移除mysql服务 mysqld -install mysqld -remove MySQL &nbsp; 3.项目中使用PDO测试连接数据库 出现报错: <a href="https://stackoverflow.com/questions/2852748/pdoexception-could-not-find-driver" rel="nofollow">PDOException “could not find driver”</a> 解决办法: 打开php的PDO扩展即可. [<a href="https://stackoverflow.com/questions/2852748/pdoexception-could-not-find-driver" rel="nofollow">https://stackoverflow.com/questions/2852748/pdoexception-could-not-find-driver</a>] &nbsp; 3.PHP使用mysql出现报错. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client [duplicate] 如下截图: <img alt="" height="115" src="https://img-blog.csdnimg.cn/20200330132324299.png" width="609"> 原因: this is usually attributed to the authentication plugin that your mysql database is using. //这通常归因于mysql数据库使用的身份验证插件。 &nbsp; 解决办法: By default and for some reason, mysql 8 default plugin is auth_socket. Applications will most times expect to log in to your database using a password. 
 <blockquote> 
 If you have not yet already changed your mysql default authentication plugin, you can do so by: 1. Log in as root to mysql 2. Run this sql command: 
 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; &nbsp; 
 </blockquote> Replace 'password' with your root password. In case your application does not log in to your database with the root user, replace the 'root' user in the above command with the user that your application uses. &nbsp; 详细参见: <a href="https://stackoverflow.com/questions/52364415/php-with-mysql-8-0-error-the-server-requested-authentication-method-unknown-to" rel="nofollow">https://stackoverflow.com/questions/52364415/php-with-mysql-8-0-error-the-server-requested-authentication-method-unknown-to</a> &nbsp; 过程： <img alt="" height="93" src="https://img-blog.csdnimg.cn/20200402141812179.png" width="682"> &nbsp; 解决结果: //刷新浏览器 <img alt="" height="149" src="https://img-blog.csdnimg.cn/20200402141740814.png" width="444"> 由于没有出现报错， 初步判断， 正常连接数据库. &nbsp; &nbsp; 后续补充 ... </td> 
 </tr> 
 </tbody> 
</table>

4.参考

<table> 
 <tbody> 
 <tr> 
 <td> <a href="https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html" rel="nofollow">https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html&nbsp; //</a>Installing手动 MySQL on Microsoft Windows <a href="https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html" rel="nofollow">https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html //</a>手动初始化data目录 <a href="https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-ubuntu-18-04#step-2-%E2%80%94-installing-mysql" rel="nofollow">https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-ubuntu-18-04#step-2-%E2%80%94-installing-mysql</a> <a href="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-6117966252207595&amp;output=html&amp;h=90&amp;w=970&amp;bih=945&amp;biw=1905&amp;adx=383&amp;ady=346&amp;ga_vid=727066675.1585293661&amp;ga_sid=1585293661&amp;ga_hid=1683393347&amp;slotname=7191217828&amp;adk=1184655777&amp;url=https://www.mysqlzh.com/&amp;ref=https://www.baidu.com/link%3Furl%3DIdwqCCFhhzQVPSR4RV881pLcjRxAqrIiPb3wQrPf2OOFb47Ri65GZxJHrnEmzP4G%26wd%3D%26eqid%3Db2d054b7000111dc000000065e7da959&amp;frm=20&amp;guci=2.2.0.0.2.2.0.0&amp;eid=21060548&amp;u_his=1&amp;brdim=1912,-8,1912,-8,1920,0,1936,1056,1922,945&amp;prev_fmts=970x90_0ads_al&amp;format=fpkc_al_lp&amp;kw_type=radlink&amp;hl=zh-CN&amp;rt=ChBefaldAAb_oQoqGdEkBRp_EgEgGghIl0ULoilklCgBUhMI4v-zjI-66AIVDC4qCh3G2QqmeAGCAQ0KCU15c3FsIDUuNxIAggESCg5NeXNxbOacjeWKoeWZqBIAggEQCgxPcmFjbGUgbXlzcWwSAIIBFQoRTXlzcWzkuIvovb3lronoo4USAIIBEAoMUHl0aG9u5Lit5paHEgCCAQ0KCU15c3FsIHNxbBIAiAED&amp;ad_type=text" rel="nofollow">Mysql下载安装</a> <a href="https://blog.csdn.net/m0_37788308/article/details/79965378" rel="nofollow">https://blog.csdn.net/m0_37788308/article/details/79965378&nbsp; //</a>win10下MYSQL的下载、安装以及配置超详解教程 <a href="https://www.dll-files.com/download/9040ed0fdf4ce7558cbffb73d4c17761/vcruntime140_1.dll.html?c=SmVhNVJmSm9ySzBiNGVnSUNzN096UT09" rel="nofollow">https://www.dll-files.com/download/9040ed0fdf4ce7558cbffb73d4c17761/vcruntime140_1.dll.html?c=SmVhNVJmSm9ySzBiNGVnSUNzN096UT09&nbsp; //</a>Downloading vcruntime140_1.dll <a href="https://stackoverflow.com/questions/58828982/vcruntime140-1-dll-missing-after-building-solution-with-c" rel="nofollow">https://stackoverflow.com/questions/58828982/vcruntime140-1-dll-missing-after-building-solution-with-c&nbsp; //</a>Vcruntime140_1.dll missing solution <a href="https://www.microsoft.com/zh-CN/download/details.aspx?id=40784" rel="nofollow">https://www.microsoft.com/zh-CN/download/details.aspx?id=40784&nbsp; //</a>Visual C++ Redistributable Packages <a href="https://blog.csdn.net/william_n/article/details/80288057" rel="nofollow">https://blog.csdn.net/william_n/article/details/80288057&nbsp; //</a>DBMS - 可视化管理工具 <a href="https://www.runoob.com/php/pdo-query.html" rel="nofollow">https://www.runoob.com/php/pdo-query.html </a>//PDO操作 <a href="https://blog.csdn.net/qq_39820860/article/details/82718211" rel="nofollow">https://blog.csdn.net/qq_39820860/article/details/82718211</a>&nbsp;//mysql中如何用root用户创建普通用户并给其授权 <a href="https://xueyuanjun.com/post/21911" rel="nofollow">https://xueyuanjun.com/post/21911</a>&nbsp;//MySQL 数据库安装和服务端启动原理&nbsp; 20200819 </td> 
 </tr> 
 </tbody> 
</table>

后续补充

...