Ubuntu 17.10安装phpMyAdmin数据库管理工具配置详解
<p>和Windows下各种双击安装直接使用的数据库管理工具不同，Linux下的数据库管理工具显得有些稍稍复杂。由于版权和收费限制，很多好用的数据库管理工具例如Data Grip和Navicat不能直接在Linux的包管理器中安装使用。不过仍然有一些好用的DBMS，phpmyadmin就是其中之一。</p>
<p>
<span><strong>安装LAMP</strong></span></p>
<p>
LAMP是Linux、Apache、MySql（MariaDB）、PHP（Python、Perl）等软件的合称。我们现在要在Ubuntu16.04上安装，因此只需要安装其他三个软件就可以了。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_241637">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">sudo apt install mysql-server-5.7 mysql-client-5.7 php7.0 apache2</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
对于这些软件可能还需要各自进行配置，这里就不再细述了。</p>
<p>
<span><strong>配置apache</strong></span></p>
<p>
<strong>启用PHP支持</strong></p>
<p>
然后安装apache的php扩展：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterphp" id="highlighter_116121">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="php plain">sudo apt install libapache2-mod-php7.0</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<br><div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
安装完成之后需要重启apache：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterphp" id="highlighter_258377">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="php plain">sudo systemctl restart apache2</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
然后在apache的默认目录中新建一个PHP文件：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterphp" id="highlighter_841867">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="php plain">sudo nano /</code><code class="php keyword">var</code><code class="php plain">/www/html/info.php</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
文件内容如下：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterphp" id="highlighter_417431">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="php plain"><?php</code>
</div>
<div class="line number2 index1 alt1">
<code class="php plain">phpinfo();</code>
</div>
<div class="line number3 index2 alt2">
<code class="php plain">?></code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
然后在浏览器中查看一下是否成功：info。</p>
<p>
成功之后别忘了删除info.php，它包含了很多服务器的敏感信息。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterphp" id="highlighter_675443">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="php plain">sudo rm -f /</code><code class="php keyword">var</code><code class="php plain">/www/html/info.php</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<br><div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>启用SSL</strong></p>
<p>
然后启用SSL：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterphp" id="highlighter_717588">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="php plain">sudo a2enmod ssl</code>
</div>
<div class="line number2 index1 alt1">
<code class="php plain">sudo a2ensite </code><code class="php keyword">default</code><code class="php plain">-ssl</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<span><strong>配置PHP</strong></span></p>
<p>
<strong>启用PHP扩展</strong></p>
<p>
安装所需的PHP扩展，也可以全部安装，全部安装可能会降低性能：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_272135">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">sudo</code> <code class="bash plain">apt -y </code><code class="bash functions">install</code> <code class="bash plain">php7.0-mysql php7.0-curl php7.0-gd php7.0-intl php-pear php-imagick php7.0-imap php7.0-mcrypt php-memcache php7.0-pspell php7.0-recode php7.0-sqlite3 php7.0-tidy php7.0-xmlrpc php7.0-xsl php7.0-mbstring php-gettext</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<br><div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
然后重启apache：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_454851">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">sudo</code> <code class="bash plain">systemctl restart apache2</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<br><div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>安装APCu</strong></p>
<p>
APCu是一个缓存扩展，可以缓存并优化PHP中间代码，强烈建议安装。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_478041">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">sudo</code> <code class="bash plain">apt -y </code><code class="bash functions">install</code> <code class="bash plain">php-apcu</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
然后重启apache：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_777455">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">sudo</code> <code class="bash plain">systemctl restart apache2</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<br><div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<span><strong>安装phpmyadmin</strong></span></p>
<p>
上面的工作全部完成之后，就可以安装phpmyadmin了。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_876176">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">sudo</code> <code class="bash plain">apt -y </code><code class="bash functions">install</code> <code class="bash plain">phpmyadmin</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
会出现一个图形界面要求你输入各种配置选项。全部配置完成之后，在浏览器中输入http://localhost/phpmyadmin/，应该就可以进入phpmyadmin的界面了。如果有些步骤没有按照顺序来，可能无法顺利打开这个web界面，这时候可以先把前面的工作都完成，然后运行一下<code>sudo dpkg-reconfigure phpmyadmin</code>命令，重新配置一遍phpmyadmin。然后应该就能顺利打开了。</p>
<p>
<span><strong>总结</strong></span></p>
<p>
以上所述是小编给大家介绍的Ubuntu 17.10安装phpMyAdmin数据库管理工具配置详解，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对网站的支持！</p>
<p>
原文链接：https://www.cnblogs.com/tirmer/archive/2018/03/23/8628271.html</p>
頁:
[1]