Mysql非exe安装步骤 待我称王封你为后i 2022-05-28 12:20 205阅读 0赞 ## 1、下载: ## [http://dev.mysql.com/downloads/mysql/][http_dev.mysql.com_downloads_mysql] 需要Oracle的帐号登录 ## 2、配置: ## 将下载的zip文件 解压到C:\\Develop\\DevelopTool\\Idea\\database\\mysql\\mysql-5.7.5-m15-winx64目录,该目录就是咱们在后面需要配置的mysql的安装目录basedir ### 2.1. 设置环境变量 ### 增加环境变量:MYSQL\_HOME=C:\\Develop\\DevelopTool\\Idea\\database\\mysql\\mysql-5.7.5-m15-winx64 修改环境变脸: 在path后面增加%MYSQL\_HOME%\\bin;(wind10下没有最后的';') ### 2.2. 配置my.ini ### 将C:\\Develop\\DevelopTool\\Idea\\database\\mysql\\mysql-5.7.5-m15-winx64\\my-default.ini <table style="width:780px;color:rgb(69,69,69);font-size:16px;background-color:rgb(255,255,255);"> <tbody> <tr> <td><p>[mysql]</p><p># 设置mysql客户端默认字符集</p><p>default-character-set=utf8</p><p>[mysqld]</p><p>#设置3306端口</p><p>port = 3306</p><p># 设置mysql的安装目录</p><p>basedir=<span style="color:rgb(51,51,51);background-color:rgb(255,255,255);">C:\Develop\DevelopTool\Idea\database\mysql\mysql-5.7.5-m15-winx64</span></p><p># 设置mysql数据库的数据的存放目录</p><p>datadir=<span style="color:rgb(51,51,51);background-color:rgb(255,255,255);">C:\Develop\DevelopTool\Idea\database\mysql\mysql-5.7.5-m15-winx64</span>\data</p><p># 允许最大连接数</p><p>max_connections=200</p><p># 服务端使用的字符集默认为8比特编码的latin1字符集</p><p>character-set-server=utf8</p><p># 创建新表时将使用的默认存储引擎</p><p>default-storage-engine=INNODB</p></td> </tr> </tbody> </table> 好了,这样一个基本的MySQL环境所需要的参数就够了。 关于my.ini里面更多更复杂的参数配置,需要对MySQL进行优化的兄弟们可以参照MySQL官网的手册来操作。 ### 2.3. 将MySQL安装成服务 ### 打 开一个cmd.exe(最好使用管理员身份运行,以免发生权限问题),将目录切换到C:\\Develop\\DevelopTool\\Idea\\database\\mysql\\mysql-5.7.5-m15-winx64\\bin(如果配置了环境变量则可以直接运行),运行: mysqld -install ,提示服务安装成功!运行services.msc一看,确实有一个名为MySQL的服务了,启动它。 或者: 启动服务 net start mysql 停止服务 net stop mysql !!注意:安装时,如果是WIN7系统,可能出现:Install/Remove of the Service Denied!今天在win7下安装 mysql 运行 mysqld -install 时,居然出现Install/Remove of the Service Denied!WINDOW 7 跟 vista 都有这问题。因为他们的权限更严格。 解决方法是: 进入 C:\\Window 找到CMD.EXE 右键选择以管理员身份进行,再进入相应目录执行命令。 同时以上只是网上的解决方法,我在wind10下使用管理员运行也是遇到了这个问题,如下 1 当: net start MySQL 时: 发生系统错误 193。 * \** 不是有效的 Win32 应用程序。 发现C:\\Develop\\DevelopTool\\Idea\\database\\mysql\\mysql-5.7.5-m15-winx64\\bin 有个mysqld的空文件,删除他即可。 2 使用命令行 net start MySQL 时: MySQL 服务正在启动 ...MySQL 服务无法启动。 服务没有报告任何错误。 请键入 NET HELPMSG 3534 以获得更多的帮助。 在services.mcs中启动会出现 ![70][] 查找网上的解决方法 : 安装好MySQL后,打开cmd命令窗口,并且进入到MySQL安装目录中的bin目录,然后输入如下命令回车即可:mysqld --initialize-insecure --user=mysql 执行完上面命令后,MySQL会自建一个data文件夹,并且建好默认数据库,登录的用户名为root,密码为空,之后就可以通过命令net start mysql启动mysql服务了。 注:MySQL升级到5.7版本是没有data文件夹的,执行mysqld --initialize-insecure --user=mysql命令会自动新建data文件夹。 因为我之前下载的mysql安装包里面是存在data文件的,所以我执行了多次都没有成功,即使删除了在执行也不行,后来我就在官网下载了最新的安装包,解压后里面是没有data文件夹的,然后执行 mysqld --initialize-insecure --user=mysql命令会自动新建data文件夹。然后在开启服务就可以啦 net start mysql ### 2.4. 配置root用户登录 ### 刚安装完成时root账号默认密码为空,此时可以将密码修改为指定的密码。如:123456 <table style="width:780px;color:rgb(69,69,69);font-size:16px;background-color:rgb(255,255,255);"> <tbody> <tr> <td><p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);">c:>mysql –uroot --默认密码是空 所以直接以root用户登陆</span></span></p><p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);"> mysql>show databases;</span></span></p><p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);"> mysql>use mysql;</span></span></p><p></p><p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);"> /**<span style="font-family:Arial, Verdana, sans-serif;font-size:14px;text-align:left;">--mysql5.7版本之前可以使用这个语句,如果在新版中执行该更行会提示<span style="font-size:24px;"><strong>ERROR 1054 (42S22): Unknown column 'password' in 'field list',</strong></span><br></span></span></span></p><p><span style="font-family:Arial, Verdana, sans-serif;font-size:14px;text-align:left;"><span style="font-size:24px;background-color:rgb(255,255,255);"><strong><span style="color:#454545;"> 此时需要使用最新的更新语句</span></strong></span></span></p><p><span style="font-family:Arial, Verdana, sans-serif;font-size:14px;text-align:left;"><span style="font-size:24px;"><span style="background-color:rgb(255,255,255);"><strong><span style="color:#454545;">原来是mysql数据库下已经没有password这个字段了,password字段改成了</span></strong></span></span></span></p><pre style="color:rgb(51,51,51);font-weight:bold;margin-bottom:10px;padding-right:0px;padding-left:0px;background-color:rgb(243,255,236);font-family:arial, 'courier new', courier, '宋体', monospace, 'Microsoft YaHei';font-size:14px;line-height:24px;white-space:pre-wrap;"><span style="color:#454545;"><span style="background-color:rgb(255,255,255);">authentication_string</span></span></pre><p style="margin-bottom:10px;font-size:14px;line-height:24px;font-family:arial, 'courier new', courier, '宋体', monospace, 'Microsoft YaHei';white-space:pre-wrap;background-color:rgb(243,255,236);"><span style="color:#454545;"><span style="background-color:rgb(255,255,255);">所以更改语句替换为<span style="margin:0px;padding:0px;font-family:'Microsoft YaHei';line-height:30px;"><strong>update mysql.user set authentication_string=password('root') where user='root' ;即可</strong></span></span></span></p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);">**/</span></span><p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);"> <strong>mysql>UPDATE user SET password=PASSWORD("123456") WHERE user='root'; </strong></span></span></p><p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);"> mysql>FLUSH PRIVILEGES;</span></span></p><p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);"> mysql>QUIT</span></span></p></td> </tr> </tbody> </table> 或者使用以下命令更新root密码 **3、修改root密码** 使用root账号登录 [?][Link 1] <table style="border-spacing:0px;border:1px solid rgb(204,204,204);margin-top:.54em;text-align:center;width:643px;clear:both;background:none;float:none;height:auto;line-height:1.1em;margin-right:0px;margin-bottom:0px;margin-left:0px;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;"> <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;text-align:left;vertical-align:baseline;width:auto;font-size:1em;min-height:auto;"> <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;min-height:auto;"> <td style="padding:.2em .46em;border-color:rgb(204,204,204);margin:0px;background:none;float:none;height:auto;line-height:1.1em;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;color:rgb(175,175,175);"> <div style="line-height:15.4px;margin:0px;padding:0px .5em 0px 1em;background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;text-align:right;vertical-align:baseline;width:auto;min-height:auto;white-space:pre;"> 1 </div></td> <td style="padding:.2em .46em;border-color:rgb(204,204,204);width:611px;margin:0px;background:none;float:none;height:auto;line-height:1.1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;"> <div style="line-height:15.4px;margin:0px;padding:0px;background:none;border:0px;float:none;height:auto;vertical-align:baseline;width:auto;min-height:auto;"> <div style="line-height:15.4px;margin:0px;padding:0px 1em;background-image:none;border:0px;float:none;height:auto;vertical-align:baseline;width:auto;min-height:auto;white-space:pre;"> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">mysql -u root -p <r8j*Qrh)jdp</code> </div> </div></td> </tr> </tbody> </table> 修改root密码 [?][Link 1] <table style="border-spacing:0px;border:1px solid rgb(204,204,204);margin-top:.54em;text-align:center;width:643px;clear:both;background:none;float:none;height:auto;line-height:1.1em;margin-right:0px;margin-bottom:0px;margin-left:0px;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;"> <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;text-align:left;vertical-align:baseline;width:auto;font-size:1em;min-height:auto;"> <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;min-height:auto;"> <td style="padding:.2em .46em;border-color:rgb(204,204,204);margin:0px;background:none;float:none;height:auto;line-height:1.1em;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;color:rgb(175,175,175);"> <div style="line-height:15.4px;margin:0px;padding:0px .5em 0px 1em;background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;text-align:right;vertical-align:baseline;width:auto;min-height:auto;white-space:pre;"> 1 </div></td> <td style="padding:.2em .46em;border-color:rgb(204,204,204);width:611px;margin:0px;background:none;float:none;height:auto;line-height:1.1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;"> <div style="line-height:15.4px;margin:0px;padding:0px;background:none;border:0px;float:none;height:auto;vertical-align:baseline;width:auto;min-height:auto;"> <div style="line-height:15.4px;margin:0px;padding:0px 1em;background-image:none;border:0px;float:none;height:auto;vertical-align:baseline;width:auto;min-height:auto;white-space:pre;"> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">ALTER USER </code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">'root'</code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">@</code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">'localhost'</code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">IDENTIFIED BY </code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">'new_password'</code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">;</code> </div> </div></td> </tr> </tbody> </table> ### 2.5. MySQL5.7 更改root密码时报错 ### 注意:如果是MySQL5.7,[更改密码时出现ERROR 1054(42S22): Unknown column 'password' in 'fie][ERROR 1054_42S22_ Unknown column _password_ in _fie],原来是mysql[数据库][Link 2]下已经没有password这个字段了,password字段改成了 authentication_string 所以更改语句替换为以下语句即可 <table style="width:780px;color:rgb(69,69,69);font-size:16px;background-color:rgb(255,255,255);"> <tbody> <tr> <td><p><span style="color:#454545;"><span style="background-color:rgb(255,255,255);">update mysql.user set authentication_string=password('root') where user='root' ;</span></span></p></td> </tr> </tbody> </table> ### 2.6. [mysql 5.7.10使用dbforget Studio 连接异常][mysql 5.7.10_dbforget Studio] ### 提示:The'INFORMATION\_SCHEMA.SESSION\_VARIABLES' feature is disabled; see thedocumentation for 'show\_compatibility\_56' 以下转自:http://blog.csdn.net/rudygao/article/details/50403107 \--从mysql5.7.6开始information\_schema.global\_status已经开始被舍弃,为了兼容性,此时需要打开show\_compatibility\_56 <table style="width:780px;color:rgb(69,69,69);font-size:16px;background-color:rgb(255,255,255);"> <tbody> <tr> <td><p><a href="http://lib.csdn.net/base/mysql" title="MySQL知识库" style="margin:0px;padding:0px;" rel="nofollow"><span style="font-weight:700;"><span style="margin:0px;padding:0px;color:rgb(223,52,52);">MySQL</span></span></a>> select * from information_schema.global_status limit 3;</p><p>ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'</p><p> </p><p> </p><p>--查看show_compatibility_56其值</p><p>mysql> show variables like '%show_compatibility_56%';</p><p>+-----------------------+-------+</p><p>| Variable_name | Value |</p><p>+-----------------------+-------+</p><p>| show_compatibility_56 | OFF |</p><p>+-----------------------+-------+</p><p>1 row in set (0.01 sec)</p><p> </p><p> </p><p>--把show_compatibility_56打开</p><p>mysql> set global show_compatibility_56=on;</p><p>Query OK, 0 rows affected (0.00 sec)</p><p> </p><p> </p><p>mysql> show variables like '%show_compatibility_56%';</p><p>+-----------------------+-------+</p><p>| Variable_name | Value |</p><p>+-----------------------+-------+</p><p>| show_compatibility_56 | ON |</p><p>+-----------------------+-------+</p><p>1 row in set (0.00 sec)</p><p> </p><p> </p><p>mysql> select * from information_schema.global_status limit 3;</p><p>+-----------------------+----------------+</p><p>| VARIABLE_NAME | VARIABLE_VALUE |</p><p>+-----------------------+----------------+</p><p>| ABORTED_CLIENTS | 0 |</p><p>| ABORTED_CONNECTS | 0 |</p><p>| BINLOG_CACHE_DISK_USE | 0 |</p><p>+-----------------------+----------------+</p><p>3 rows in set, 1 warning (0.00 sec)</p></td> </tr> </tbody> </table> **3、修改root密码** 使用root账号登录 [?][Link 1] <table style="border-spacing:0px;border:1px solid rgb(204,204,204);margin-top:.54em;text-align:center;width:643px;clear:both;background:none;float:none;height:auto;line-height:1.1em;margin-right:0px;margin-bottom:0px;margin-left:0px;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;"> <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;text-align:left;vertical-align:baseline;width:auto;font-size:1em;min-height:auto;"> <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;min-height:auto;"> <td style="padding:.2em .46em;border-color:rgb(204,204,204);margin:0px;background:none;float:none;height:auto;line-height:1.1em;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;color:rgb(175,175,175);"> <div style="line-height:15.4px;margin:0px;padding:0px .5em 0px 1em;background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;text-align:right;vertical-align:baseline;width:auto;min-height:auto;white-space:pre;"> 1 </div></td> <td style="padding:.2em .46em;border-color:rgb(204,204,204);width:611px;margin:0px;background:none;float:none;height:auto;line-height:1.1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;"> <div style="line-height:15.4px;margin:0px;padding:0px;background:none;border:0px;float:none;height:auto;vertical-align:baseline;width:auto;min-height:auto;"> <div style="line-height:15.4px;margin:0px;padding:0px 1em;background-image:none;border:0px;float:none;height:auto;vertical-align:baseline;width:auto;min-height:auto;white-space:pre;"> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">mysql -u root -p <r8j*Qrh)jdp</code> </div> </div></td> </tr> </tbody> </table> 修改root密码 [?][Link 1] <table style="border-spacing:0px;border:1px solid rgb(204,204,204);margin-top:.54em;text-align:center;width:643px;clear:both;background:none;float:none;height:auto;line-height:1.1em;margin-right:0px;margin-bottom:0px;margin-left:0px;padding:0px;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;"> <tbody style="background:none;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;text-align:left;vertical-align:baseline;width:auto;font-size:1em;min-height:auto;"> <tr style="background:none;border-top:0px;float:none;height:auto;line-height:1.1em;margin:0px;padding:0px;vertical-align:baseline;width:auto;font-size:1em;min-height:auto;"> <td style="padding:.2em .46em;border-color:rgb(204,204,204);margin:0px;background:none;float:none;height:auto;line-height:1.1em;vertical-align:baseline;width:auto;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;color:rgb(175,175,175);"> <div style="line-height:15.4px;margin:0px;padding:0px .5em 0px 1em;background-image:none;border-width:0px 3px 0px 0px;border-right-style:solid;border-right-color:rgb(108,226,108);float:none;height:auto;text-align:right;vertical-align:baseline;width:auto;min-height:auto;white-space:pre;"> 1 </div></td> <td style="padding:.2em .46em;border-color:rgb(204,204,204);width:611px;margin:0px;background:none;float:none;height:auto;line-height:1.1em;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:1em;min-height:auto;"> <div style="line-height:15.4px;margin:0px;padding:0px;background:none;border:0px;float:none;height:auto;vertical-align:baseline;width:auto;min-height:auto;"> <div style="line-height:15.4px;margin:0px;padding:0px 1em;background-image:none;border:0px;float:none;height:auto;vertical-align:baseline;width:auto;min-height:auto;white-space:pre;"> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">ALTER USER </code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">'root'</code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">@</code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">'localhost'</code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">IDENTIFIED BY </code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#0000FF;">'new_password'</code> <code style="margin:3px auto 0px;padding:0px 0px 0px 5px;background:rgb(255,255,255);border-left:3px solid rgb(108,226,108);width:640px;font-size:14px;clear:both;border-top:0px;border-right:0px;border-bottom:0px;float:none;height:auto;vertical-align:baseline;font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;min-height:auto;color:#000000;">;</code> </div> </div></td> </tr> </tbody> </table> [http_dev.mysql.com_downloads_mysql]: http://dev.mysql.com/downloads/mysql/ [70]: /images/20220528/2457de146548407c91e812276601f112.png [Link 1]: http://www.jb51.net/article/116028.htm# [ERROR 1054_42S22_ Unknown column _password_ in _fie]: http://www.07net01.com/storage_networking/2016/01/1141976.html [Link 2]: http://www.07net01.com/tags-%E6%95%B0%E6%8D%AE%E5%BA%93-0.html [mysql 5.7.10_dbforget Studio]: http://blog.csdn.net/xcmonline/article/details/50441330
还没有评论,来说两句吧...