湖濱散記部落格的樹心幽徑[<a href=login.php>login</a>][<a href= . >主頁</a>]<hr>
448:20181217在ubuntu 1604裝mysql server<br><table width=800 border=8><tr><td bgcolor=cyan><p>(1) <span style="background-color: #ffff00;">$ sudo apt-get install mysql-server </span><br />:</p>
<p>以下套件為自動安裝，並且已經無用：<br />&nbsp; linux-headers-4.10.0-28 linux-headers-4.10.0-28-generic<br />&nbsp; linux-image-4.10.0-28-generic linux-image-extra-4.10.0-28-generic<br />Use 'sudo apt autoremove' to remove them.<br />下列的額外套件將被安裝：<br />&nbsp; libaio1 libevent-core-2.0-5 libhtml-template-perl mysql-client-5.7<br />&nbsp; mysql-client-core-5.7 mysql-server-5.7 mysql-server-core-5.7<br />建議套件：<br />&nbsp; libipc-sharedcache-perl mailx tinyca<br />下列【新】套件將會被安裝：<br />&nbsp; libaio1 libevent-core-2.0-5 libhtml-template-perl mysql-client-5.7<br />&nbsp; mysql-client-core-5.7 mysql-server mysql-server-5.7 mysql-server-core-5.7<br />升級 0 個，新安裝 8 個，移除 0 個，有 254 個未被升級。<br />需要下載 18.4 MB 的套件檔。<br />此操作完成之後，會多佔用 161 MB 的磁碟空間。<br />是否繼續進行 [Y/n]？ [Y/n] y<br />下載:1 http://tw.archive.ubuntu.com/ubuntu xenial/main amd64 libaio1 amd64 0.3.110-2 [6,356 B]<br />下載:2 http://tw.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-client-core-5.7 amd64 5.7.24-0ubuntu0.16.04.1 [6,030 kB]<br />下載:3 http://tw.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-client-5.7 amd64 5.7.24-0ubuntu0.16.04.1 [1,720 kB]<br />下載:4 http://tw.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server-core-5.7 amd64 5.7.24-0ubuntu0.16.04.1 [7,757 kB]<br />下載:5 http://tw.archive.ubuntu.com/ubuntu xenial-updates/main amd64 libevent-core-2.0-5 amd64 2.0.21-stable-2ubuntu0.16.04.1 [70.6 kB]<br />下載:6 http://tw.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server-5.7 amd64 5.7.24-0ubuntu0.16.04.1 [2,726 kB]<br />下載:7 http://tw.archive.ubuntu.com/ubuntu xenial/main amd64 libhtml-template-perl all 2.95-2 [60.4 kB]<br />下載:8 http://tw.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server all 5.7.24-0ubuntu0.16.04.1 [10.8 kB]<br />取得 18.4 MB 用了 4秒 (4,018 kB/s)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />正在預先設定套件 ...<br />選取了原先未選的套件 libaio1:amd64。<br />（讀取資料庫 ... 目前共安裝了 259353 個檔案和目錄。）<br />準備解開 .../libaio1_0.3.110-2_amd64.deb ...<br />解開 libaio1:amd64 (0.3.110-2) 中...<br />選取了原先未選的套件 mysql-client-core-5.7。<br />準備解開 .../mysql-client-core-5.7_5.7.24-0ubuntu0.16.04.1_amd64.deb ...<br />解開 mysql-client-core-5.7 (5.7.24-0ubuntu0.16.04.1) 中...<br />選取了原先未選的套件 mysql-client-5.7。<br />準備解開 .../mysql-client-5.7_5.7.24-0ubuntu0.16.04.1_amd64.deb ...<br />解開 mysql-client-5.7 (5.7.24-0ubuntu0.16.04.1) 中...<br />選取了原先未選的套件 mysql-server-core-5.7。<br />準備解開 .../mysql-server-core-5.7_5.7.24-0ubuntu0.16.04.1_amd64.deb ...<br />解開 mysql-server-core-5.7 (5.7.24-0ubuntu0.16.04.1) 中...<br />選取了原先未選的套件 libevent-core-2.0-5:amd64。<br />準備解開 .../libevent-core-2.0-5_2.0.21-stable-2ubuntu0.16.04.1_amd64.deb ...<br />解開 libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) 中...<br />選取了原先未選的套件 mysql-server-5.7。<br />準備解開 .../mysql-server-5.7_5.7.24-0ubuntu0.16.04.1_amd64.deb ...<br />解開 mysql-server-5.7 (5.7.24-0ubuntu0.16.04.1) 中...<br />選取了原先未選的套件 libhtml-template-perl。<br />準備解開 .../libhtml-template-perl_2.95-2_all.deb ...<br />解開 libhtml-template-perl (2.95-2) 中...<br />選取了原先未選的套件 mysql-server。<br />準備解開 .../mysql-server_5.7.24-0ubuntu0.16.04.1_all.deb ...<br />解開 mysql-server (5.7.24-0ubuntu0.16.04.1) 中...<br />Processing triggers for libc-bin (2.23-0ubuntu10) ...<br />Processing triggers for man-db (2.7.5-1) ...<br />Processing triggers for ureadahead (0.100.0-19) ...<br />Processing triggers for systemd (229-4ubuntu21.10) ...<br />設定 libaio1:amd64 (0.3.110-2) ...<br />設定 mysql-client-core-5.7 (5.7.24-0ubuntu0.16.04.1) ...<br />設定 mysql-client-5.7 (5.7.24-0ubuntu0.16.04.1) ...<br />設定 mysql-server-core-5.7 (5.7.24-0ubuntu0.16.04.1) ...<br />設定 libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...<br />設定 mysql-server-5.7 (5.7.24-0ubuntu0.16.04.1) ...<br />update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode<br />Renaming removed key_buffer and myisam-recover options (if present)<br />設定 libhtml-template-perl (2.95-2) ...<br />設定 mysql-server (5.7.24-0ubuntu0.16.04.1) ...<br />Processing triggers for libc-bin (2.23-0ubuntu10) ...<br />Processing triggers for systemd (229-4ubuntu21.10) ...<br />Processing triggers for ureadahead (0.100.0-19) ...<br />treehrt@treehrt-D630MT:~$</p>
<p>(2)$<span style="background-color: #ffff00;"> sudo apt-get install mysql-client</span><br />:</p>
<p>以下套件為自動安裝，並且已經無用：<br />&nbsp; linux-headers-4.10.0-28 linux-headers-4.10.0-28-generic linux-image-4.10.0-28-generic linux-image-extra-4.10.0-28-generic<br />Use 'sudo apt autoremove' to remove them.<br />下列【新】套件將會被安裝：<br />&nbsp; mysql-client<br />升級 0 個，新安裝 1 個，移除 0 個，有 254 個未被升級。<br />需要下載 10.1 kB 的套件檔。<br />此操作完成之後，會多佔用 110 kB 的磁碟空間。<br />下載:1 http://tw.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-client all 5.7.24-0ubuntu0.16.04.1 [10.1 kB]<br />取得 10.1 kB 用了 0秒 (50.9 kB/s)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />選取了原先未選的套件 mysql-client。<br />（讀取資料庫 ... 目前共安裝了 259610 個檔案和目錄。）<br />準備解開 .../mysql-client_5.7.24-0ubuntu0.16.04.1_all.deb ...<br />解開 mysql-client (5.7.24-0ubuntu0.16.04.1) 中...<br />設定 mysql-client (5.7.24-0ubuntu0.16.04.1) ...<br />treehrt@treehrt-D630MT:~$</p>
<p>(3)</p>
<p>$ <span style="background-color: #ffff00;">sudo apt-get install libmysqlclient-dev</span><br />:</p>
<p>libmysqlclient-dev is already the newest version (5.7.24-0ubuntu0.16.04.1).<br />以下套件為自動安裝，並且已經無用：<br />&nbsp; linux-headers-4.10.0-28 linux-headers-4.10.0-28-generic linux-image-4.10.0-28-generic linux-image-extra-4.10.0-28-generic<br />Use 'sudo apt autoremove' to remove them.<br />升級 0 個，新安裝 0 個，移除 0 個，有 254 個未被升級。<br />treehrt@treehrt-D630MT:~$</p>
<p>(4)</p>
<p>$ <span style="background-color: #ffff00;">sudo /etc/init.d/mysql start</span><br />[sudo] password for treehrt: <br />[ ok ] Starting mysql (via systemctl): mysql.service.</p>
<p>$ <span style="background-color: #ffff00;">ps ax|grep mysql</span><br />&nbsp;7404 ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ssl&nbsp;&nbsp;&nbsp; 0:03 /usr/sbin/mysqld<br />&nbsp;8961 pts/20&nbsp;&nbsp; S+&nbsp;&nbsp;&nbsp;&nbsp; 0:00 grep --color=auto mysql</p>
<p>(5)</p>
<p>$<span style="background-color: #ffff00;"> mysql -p -uroot</span><br />Enter password: <br />Welcome to the MySQL monitor.&nbsp; Commands end with ; or \g.<br />Your MySQL connection id is 4<br />Server version: 5.7.24-0ubuntu0.16.04.1 (Ubuntu)<br /><br />Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.<br /><br />Oracle is a registered trademark of Oracle Corporation and/or its<br />affiliates. Other names may be trademarks of their respective<br />owners.<br /><br />Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br /><br />mysql&gt; quit<br />Bye</p>
<p>&nbsp;</p>
<p>&nbsp;</p></table><br> select id,article_id,topic,text from lt_articles_text where article_id =448; ok.
update lt_articles set num_reads=num_reads +1 where id=448; ok.