一、验证原有主机是否已安装MySQL:
这里主要是运行sudo netstat -tap | grep mysql命令查看是否有MySQL监听的端口:
MySQL监听在localhost,说明MySQL已经启动。
<div style="MARGIN-TOP: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 0px" class="linenums"><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L0"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ netstat </span><span class="pun">-</span><span class="pln">tap </span><span class="pun">|</span><span class="pln"> grep mysql</span></code></div></div>
在确认主机未安装MySQL后,运行命令sudo apt-get install mysql-server mysql-client进行在线安装:
<div style="MARGIN-TOP: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 0px" class="linenums"><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L0"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ sudo apt</span><span class="pun">-</span><span class="pln">get install mysql</span><span class="pun">-</span><span class="pln">server mysql</span><span class="pun">-</span><span class="pln">client</span></code></div></div>
在安装的过程中会提示你输入Yes,然后会弹出root密码设置界面,这里可以先设置一个root密码作为登录mysql用户使用,之后需要的时候也可以运行mysqladmin -u root -p password进行修改密码,当然那个时候得先输入原密码了。
<div style="MARGIN-TOP: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 0px" class="linenums"><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L0"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ mysqladmin </span><span class="pun">-</span><span class="pln">u root </span><span class="pun">-</span><span class="pln">p password</span></code></div></div>
Ubuntu默认开机启动MySQL服务,同时,也可以输入命令来启动和关闭MySQL:
<div style="MARGIN-TOP: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 0px" class="linenums"><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L0"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="com"># 启动MySQL</span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L1"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ sudo service mysql start </span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L2"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="com"># 关闭MySQL</span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L3"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ sudo service mysql stop</span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L4"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="com"># 重启MySQL</span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L5"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ sudo service mysql restart</span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L5"> </div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L5"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln"># 其他命令:</span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L5"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ sudo /etc/init.d/mysql start</span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L5"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ sudo /etc/init.d/mysql stop</span></code></div><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L5"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ sudo /etc/init.d/mysql restart</span></code></div></div>
然后,再次键入命令来检查是否已启动MySQL:
<div style="MARGIN-TOP: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 0px" class="linenums"><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L0"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ netstat </span><span class="pun">-</span><span class="pln">tap </span><span class="pun">|</span><span class="pln"> grep mysql</span></code></div></div>
MySQL监听在localhost,说明MySQL已经启动。
使用命令行mysql -u root -p 来登录MySQL:
<div style="MARGIN-TOP: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 0px" class="linenums"><div style="LINE-HEIGHT: 18px; LIST-STYLE-TYPE: none; PADDING-LEFT: 0px" class="L0"><code style="FONT-FAMILY: Consolas, 'Liberation Mono', Menlo, Courier, monospace; WORD-WRAP: break-word" class="language-sh"><span class="pln">$ mysql </span><span class="pun">-</span><span class="pln">u root </span><span class="pun">-</span><span class="pln">p</span></code></div></div>
P.S. 最近尝试Ubuntu安装MySQL,留作参考。关于配置问题,后面下文解析。