esc0rp 发表于 2024-7-12 00:51:20

phpMyAdmin 你值得持有


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这个家伙<span style="color: black;">通常</span>都是搞 PHP 的人接触的多<span style="color: black;">有些</span>，毕竟有琳琅满目的数据库管理<span style="color: black;">工具</span>。<span style="color: black;">例如</span>我之前用的比较多的是 <a style="color: black;">Navicat for MySQL</a>，这家伙在 Windows 系统上用的还挺顺手的，性能<span style="color: black;">亦</span>不错，<span style="color: black;">然则</span>自从换了 Mac 以后，界面<span style="color: black;">亦</span><span style="color: black;">欠好</span>看了，操作<span style="color: black;">亦</span>不灵活了，打开一张 1w+ 的表<span style="color: black;">亦</span>得花几秒（以上仅是自己环境下<span style="color: black;">显现</span>的用户体验，并没黑它的意思哦，应该是我的电脑问题以及服务器配置太差的缘故 TAT 说到底还是自己穷咯）换成今天的主角之后，恩，还不赖。<span style="color: black;">首要</span>呢，他是开源的，你别说，我就<span style="color: black;">爱好</span>开源的（你懂的）；其次它是用“世界上最好的语言” —— PHP 写的，<span style="color: black;">做为</span>“资深 PHP <span style="color: black;">研发</span>工程师”看着亲切的很。<span style="color: black;">做为</span>老牌的 web 端数据库管理<span style="color: black;">工具</span>，自带的数据库功能自然是够你用的（<span style="color: black;">起始</span>于2001年，<span style="color: black;">始终</span><span style="color: black;">守护</span>到<span style="color: black;">此刻</span>，经得起时间的考验，都快赶上我出生的年份了...）让<span style="color: black;">咱们</span>去观摩下<span style="color: black;">研发</span>出这款棒棒哒开源<span style="color: black;">工具</span>的<a style="color: black;"><span style="color: black;">研发</span>者们</a>
    </p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">吧!</p>

    <h2 style="color: black; text-align: left; margin-bottom: 10px;">下载</h2>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">不但</span>是这个，<span style="color: black;">非常多</span>软件和<span style="color: black;">工具</span><span style="color: black;">倘若</span>能在官网上下载的就<span style="color: black;">尽可能</span>到官网上去下载，<span style="color: black;">倘若</span>刚好你<span style="color: black;">近期</span>手头钱多建议捐一点（这位童鞋打算捐一百？有你<span style="color: black;">这般</span>的举动，世界会变得更美好）...好了，是时候放出<a style="color: black;">传送门</a>了</p>
    <h2 style="color: black; text-align: left; margin-bottom: 10px;">安装</h2>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">下载下来是一个 zip 压缩包，直接解压就好，把文件夹名<span style="color: black;">叫作</span>改的短一点（<span style="color: black;">例如</span> pma，下文中均以改名<span style="color: black;">叫作</span>为根目录）拷贝配置文件，有两种方式<span style="color: black;">爱好</span><span style="color: black;">认识</span>一切，对未知有<span style="color: black;">剧烈</span>的好奇心者：将</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;">/pma/libraries/config.default.php</div> 拷贝到<div style="color: black; text-align: left; margin-bottom: 10px;">/pma/config.inc.php
    </div>新手小白，只想先能正常跑起来者：将<div style="color: black; text-align: left; margin-bottom: 10px;">/pma/config.sample.inc.php
    </div>拷贝到<div style="color: black; text-align: left; margin-bottom: 10px;">/pma/config.inc.php
    </div>光看网上教程<span style="color: black;">无</span>认真思考图方便者：直接修改 <div style="color: black; text-align: left; margin-bottom: 10px;">/pma/config.default.php</div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 明明这个配置文件上<span style="color: black;">研发</span>人员用醒目的要死的文字写着... NO! DO NOT EDIT！修改配置文件</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">$cfg</span><span style="color: black;">[</span><span style="color: black;">DefaultLang</span><span style="color: black;">]</span> <span style="color: black;">=</span> <span style="color: black;">zh</span><span style="color: black;">;</span>

      <span style="color: black;">$cfg</span><span style="color: black;">[</span><span style="color: black;">blowfish_secret</span><span style="color: black;">]</span> <span style="color: black;">=</span> <span style="color: black;">419f9149e486203888b17fee459c2912</span><span style="color: black;">;</span>

      <span style="color: black;">$cfg</span><span style="color: black;">[</span><span style="color: black;">Servers</span><span style="color: black;">][</span><span style="color: black;">$i</span><span style="color: black;">][</span><span style="color: black;">auth_type</span><span style="color: black;">]</span> <span style="color: black;">=</span> <span style="color: black;">cookie</span><span style="color: black;">;</span>

      <span style="color: black;">$cfg</span><span style="color: black;">[</span><span style="color: black;">Servers</span><span style="color: black;">][</span><span style="color: black;">$i</span><span style="color: black;">][</span><span style="color: black;">host</span><span style="color: black;">]</span> <span style="color: black;">=</span> <span style="color: black;">localhost</span><span style="color: black;">;</span>

      <span style="color: black;">$cfg</span><span style="color: black;">[</span><span style="color: black;">Servers</span><span style="color: black;">][</span><span style="color: black;">$i</span><span style="color: black;">][</span><span style="color: black;">user</span><span style="color: black;">]</span> <span style="color: black;">=</span> <span style="color: black;">root</span><span style="color: black;">;</span>

      <span style="color: black;">$cfg</span><span style="color: black;">[</span><span style="color: black;">Servers</span><span style="color: black;">][</span><span style="color: black;">$i</span><span style="color: black;">][</span><span style="color: black;">password</span><span style="color: black;">]</span> <span style="color: black;">=</span> <span style="color: black;">123456</span><span style="color: black;">;</span>
    </div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第1</span>个参数指默认语言，看英文不习惯就用中文吧...</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第二个参数指短语<span style="color: black;">暗码</span>，即当 auth_type 为 cookie 时<span style="color: black;">做为</span>加密部分参与认证</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第三个参数指认证方式，即当你登录 phpMyAdmin 后将<span style="color: black;">暗码</span>加密<span style="color: black;">保留</span>在 cookie 中</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第四个参数指数据库主机，<span style="color: black;">例如</span>你是本地数据库，则<span style="color: black;">运用</span> localhost</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第五个参数指数据库 root 用户的账号，<span style="color: black;">通常</span>都是 root</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">第六个参数指数据库 root 用户的<span style="color: black;">暗码</span>，我随便写的啊，别忘了改成自己的...</p>
    <h2 style="color: black; text-align: left; margin-bottom: 10px;">运行</h2>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">将 /pma 移动到域名或IP<span style="color: black;">能够</span><span style="color: black;">拜访</span>到的路径下，<span style="color: black;">而后</span><span style="color: black;">拜访</span><span style="color: black;">就可</span>。有的童鞋<span style="color: black;">发掘</span>怎么提示找不到之类的错误，<span style="color: black;">此时</span>候在配置文件中追加一行配置吧：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">$cfg</span><span style="color: black;">[</span><span style="color: black;">PmaAbsoluteUri</span><span style="color: black;">]</span> <span style="color: black;">=</span> <span style="color: black;">http://pma.stephencode.me/</span><span style="color: black;">;</span>
    </div>
    <h2 style="color: black; text-align: left; margin-bottom: 10px;">
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">定制</p>
    </h2>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这时候<span style="color: black;">已然</span>成功登入数据库啦，在左侧栏中能看到你的所有数据库，<span style="color: black;">此时</span>候你一看，怎么有好些个数据库我都没见过，我不记得我创建过呀，<span style="color: black;">例如</span> information_schema, performance_schema...这些数据库都是 MySQL 自带的，<span style="color: black;">或</span>说是它<span style="color: black;">自己</span><span style="color: black;">必须</span>用到的。<span style="color: black;">倘若</span>你像我<span style="color: black;">同样</span>不<span style="color: black;">必须</span>操作这些数据库的，<span style="color: black;">那样</span>在刚才的配置文件中追加一行配置：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">$cfg</span><span style="color: black;">[</span><span style="color: black;">Servers</span><span style="color: black;">][</span><span style="color: black;">$i</span><span style="color: black;">][</span><span style="color: black;">hide_db</span><span style="color: black;">]</span> <span style="color: black;">=</span> <span style="color: black;">^(information_schema|mysql|performance_schema)$</span><span style="color: black;">;</span>
    </div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此时</span>候你觉得</p>




听听海 发表于 2024-8-29 22:49:27

祝福你、祝你幸福、早日实现等。

vip51888 发表于 2024-8-31 09:22:09

谷歌外链发布 http://www.fok120.com/

j8typz 发表于 2024-10-12 15:16:11

真情实感，其含义为认真了、走心了的意思，是如今的饭圈常用语。
页: [1]
查看完整版本: phpMyAdmin 你值得持有