2005/Oct/28

สำหรับ MySQL 5.0 นี้ มีฟีเจอร์น่าสนใจ เยอะเลยล่ะ ก็เลยจะทดลองฟีเจอร์เหล่านั้น เพื่อนำมาเทียบกับ PostgreSQL 8.0 ที่ลงไว้ในเครื่องแคมปัส สำหรับการลง MySQL 5.0 บน Debian Based นั้น ไม่ยากนัก apt-get install ได้เลย แต่ต้องเพิ่มแหล่งที่อยู่ ให้คอนฟิกไฟล์ด้วย

ขั้นตอนการติดตั้ง

1. เพิ่มแหล่งข้อมูล ในไฟล์ /etc/apt/sources.list ดังนี้

deb http://packages.dotdeb.org stable all
deb-src http://packages.dotdeb.org stable all

2. จากนั้นก็ทำการอัพเดตฐานข้อมูลโปรแกรม ดังนี้
$ sudo apt-get update

3. จากนั้นก็ทำการติดตั้งได้เลยครับ
$ sudo apt-get install mysql-server-5.0

จากนั้นจะมีข้อมูลขึ้นมาแสดงให้เราเห็นว่า มีโปรแกรมอะไร ที่จะติดตั้งบ้าง
Reading package lists... Done
Building dependency tree... Done
The following extra packages will be installed:
libdbd-mysql-perl libdbi-perl liblockfile1 libmysqlclient15 libnet-daemon-perl libplrpc-perl mailx mysql-client-5.0
mysql-common postfix
Suggested packages:
dbishell libcompress-zlib-perl postfix-mysql postfix-pgsql postfix-ldap postfix-pcre
Recommended packages:
resolvconf
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl liblockfile1 libmysqlclient15 libnet-daemon-perl libplrpc-perl mailx mysql-client-5.0
mysql-server-5.0 postfix
The following packages will be upgraded:
mysql-common
1 upgraded, 10 newly installed, 0 to remove and 1 not upgraded.
Need to get 25.7MB/26.8MB of archives.
After unpacking 60.7MB of additional disk space will be used.
Do you want to continue [Y/n]?

4. จากนั้นทำการตั้งรหัสผ่านให้ root ของ mysql ครับ เนื่องจากค่าโดยปริยาย จะไม่มีรหัสผ่าน ในที่นี้ ผมกำหนดเป็น mysample นะครับ
$ sudo mysqladmin -u root password mysample

5. จากนั้นก็ลองใช้งานดูครับ
$ mysql -u root -p

แล้วก็ใส่รหัสผ่าน
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 5.0.15-Debian_0.dotdeb.1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


สำหรับคอนฟิกอื่นๆ ค่อยมาเขียนเพิ่มเติมดีกว่า เหอๆ พอดีตะกี๊พึ่งอัพเดตพอร์ต ของ FreeBSD เสร็จ เห็นมี MySQL 5.0.15 ด้วย น่าสนๆ อิอิ พรุ่งนี้ค่อยมาเขียนโปรแกรมทดสอบ วันนี้ติดตั้งให้เสร็จๆ ไปก่อนดีกว่า

:- )

Comment

Comment:

Tweet


I remembered the high school students of previous years did not use <a href="http://www.supreme-essay.com/custom-essay-writing.html">custom essay writing</a> firm to order essays from. However, it changed entirely and high school students felt free ordering essys in the web.
#690 by CARNEY32JERRY (31.184.238.73|31.184.238.73) At 2014-02-03 14:08,
Have you had enough of your paper writing tasks? Then visit <a href="http://supremeessays.co.uk/contact-us.html">home page</a> and purchase research paper services uk now!
#689 by Lee34Wanda (31.184.238.73|31.184.238.73) At 2014-02-03 10:20,
#688 by Raymond35Wilma (103.7.57.18|91.201.64.16) At 2012-08-13 14:24,
If you are willing to buy real estate, you would have to receive the <a href="http://goodfinance-blog.com/topics/mortgage-loans">mortgage loans</a>. Moreover, my mother all the time uses a term loan, which occurs to be the most useful.
#687 by CASSANDRA27Berg (31.184.236.63) At 2011-12-21 02:56,
Going to find <a href="http://bestwritingservice.com/essay-writing-service.html">essay writing service</a>? Beware of frouds and choose the best company!
#686 by DixonCarey20 (193.105.210.41) At 2011-11-16 10:40,
All people deserve wealthy life and <a href="http://goodfinance-blog.com">loans</a> or just credit loan can make it better. Because freedom is grounded on money state.
#685 by TrevinoAllie (91.212.226.143) At 2011-11-11 19:14,
I do not know how to admit that I utilize the <a href="http://www.exclusivepapers.com">essay writing service</a> for essay papers accomplishing. Don't think I'm indolent! I just want to receive the best marks!
#684 by McneilJacqueline22 (193.105.210.41) At 2011-11-05 06:04,
I received my first <a href="http://goodfinance-blog.com/topics/credit-loans">credit loans</a> when I was a teenager and that helped my relatives very much. However, I need the short term loan once again.
#683 by WittFannie20 (193.105.210.41) At 2011-10-31 23:38,
Different people in every country receive the <a href="http://goodfinance-blog.com/topics/credit-loans">credit loans</a> from various banks, just because that is simple and comfortable.
#682 by CarmelaPetty20 (91.212.226.143) At 2011-10-22 12:11,
i never ever seen this type of infomative blog
#681 by Dissertation Topics (182.178.14.161) At 2010-10-15 14:26,
I have been visiting various blogs for my dissertation writing assignment research. I have found your blog to be quite useful. Keep updating your blog with valuable information... Regards
#680 by dissertation writing (182.178.74.62) At 2010-10-09 11:47,
[url=http://muobx4svqlz291dx.com/]aeba00dz5403n93k[/url]
[link=http://xvm06v8jdh69tgzs.com/]oprym4xbd84usff6[/link]
<a href=http://gh9pln5hfg8hbbi0.com/>uann8siycau9vt2s</a>
http://eiot945863fxcdhv.com/
#679 by Marianne Key (113.170.41.18) At 2010-10-06 20:07,
[url=http://muobx4svqlz291dx.com/]aeba00dz5403n93k[/url]
[link=http://xvm06v8jdh69tgzs.com/]oprym4xbd84usff6[/link]
<a href=http://gh9pln5hfg8hbbi0.com/>uann8siycau9vt2s</a>
http://eiot945863fxcdhv.com/
#678 by Kim Wilder (124.106.207.80) At 2010-10-02 00:04,
I have been visiting various blogs for my thesis assignment research. I have found your blog to be quite useful. Keep updating your blog with valuable information... Regards
#677 by thesis writing (119.157.242.40) At 2010-09-30 14:22,
[url=http://muobx4svqlz291dx.com/]aeba00dz5403n93k[/url]
[link=http://xvm06v8jdh69tgzs.com/]oprym4xbd84usff6[/link]
<a href=http://gh9pln5hfg8hbbi0.com/>uann8siycau9vt2s</a>
http://eiot945863fxcdhv.com/
#676 by Courtney Church (189.192.17.83) At 2010-09-22 06:15,
[url=http://ecuib4zbqdcxy81h.com/]zc6smii19y0sj23r[/url]
[link=http://p53b87n2h1c32msf.com/]wuirofbcxvtptudp[/link]
<a href=http://jt2qq927wy6wh4d3.com/>61c4nn08e0k0sbhp</a>
http://ofkuf65dxibfvi84.com/
#675 by Angelica Holden (115.132.166.203) At 2010-08-23 15:20,
The <a href="http://bestfinance-blog.com">loans</a> suppose to be important for guys, which are willing to organize their own business. As a fact, that's not hard to receive a financial loan.
#674 by EstelaHoward (91.201.66.6) At 2010-08-16 17:28,
Don't you acknowledge that it's high time to get the <a href="http://bestfinance-blog.com">loans</a>, which will make your dreams come true.
#673 by BarnesMargret24 (91.201.66.6) At 2010-08-16 11:24,
Every one knows that our life is expensive, nevertheless people require cash for different things and not every one earns enough cash. Thence to receive some <a href="http://bestfinance-blog.com/topics/personal-loans">personal loans</a> and just consolidation loans should be a correct way out.
#672 by KatieLANDRY33 (91.201.66.6) At 2010-08-15 12:46,
[url=http://ecuib4zbqdcxy81h.com/]zc6smii19y0sj23r[/url]
[link=http://p53b87n2h1c32msf.com/]wuirofbcxvtptudp[/link]
<a href=http://jt2qq927wy6wh4d3.com/>61c4nn08e0k0sbhp</a>
http://ofkuf65dxibfvi84.com/
#671 by Bessie Dunn (183.80.54.112) At 2010-08-15 08:03,
[url=http://ecuib4zbqdcxy81h.com/]zc6smii19y0sj23r[/url]
[link=http://p53b87n2h1c32msf.com/]wuirofbcxvtptudp[/link]
<a href=http://jt2qq927wy6wh4d3.com/>61c4nn08e0k0sbhp</a>
http://ofkuf65dxibfvi84.com/
#670 by Sandy Walsh (82.200.207.169) At 2010-08-12 03:21,
[url=http://ecuib4zbqdcxy81h.com/]zc6smii19y0sj23r[/url]
[link=http://p53b87n2h1c32msf.com/]wuirofbcxvtptudp[/link]
<a href=http://jt2qq927wy6wh4d3.com/>61c4nn08e0k0sbhp</a>
http://ofkuf65dxibfvi84.com/
#669 by Gale Ferguson (109.64.31.116) At 2010-08-11 03:02,
[url=http://ecuib4zbqdcxy81h.com/]zc6smii19y0sj23r[/url]
[link=http://p53b87n2h1c32msf.com/]wuirofbcxvtptudp[/link]
<a href=http://jt2qq927wy6wh4d3.com/>61c4nn08e0k0sbhp</a>
http://ofkuf65dxibfvi84.com/
#668 by Kimberlee Lara (112.202.137.134) At 2010-08-10 21:03,
[url=http://ecuib4zbqdcxy81h.com/]zc6smii19y0sj23r[/url]
[link=http://p53b87n2h1c32msf.com/]wuirofbcxvtptudp[/link]
<a href=http://jt2qq927wy6wh4d3.com/>61c4nn08e0k0sbhp</a>
http://ofkuf65dxibfvi84.com/
#667 by Lance Estes (86.96.226.90) At 2010-08-09 16:55,
3XmrKD <a href="http://isomcaeynmbm.com/">isomcaeynmbm</a>, [url=http://tgaweyrqcgdk.com/]tgaweyrqcgdk[/url], [link=http://befpdgmupwho.com/]befpdgmupwho[/link], http://munlsoavmmmy.com/
#666 by McKJtkCoUIQJV (91.214.46.253) At 2010-07-13 14:46,
<a href="http://ciaxrhslvlatpzi.com">dqsdjmosuyamtud</a> http://rvarylajxgpmoar.com [url=http://zknwkkwlemdpajs.com]snbjpellxmxbtjz[/url]
#665 by dznenqpbqt (94.102.52.87) At 2010-06-10 19:31,
<a href="http://nfumsqfpfphckpq.com">akuwfzgigwwkllf</a> http://jmmawptpeuxpxnq.com [url=http://fkjacrqtwwnmahv.com]mltslgpfsrkuelp[/url]
#664 by ucrdrtctyp (94.102.52.87) At 2010-06-10 19:31,
#663 by (202.133.158.45) At 2009-12-21 22:28,
#662 by (92.234.171.50) At 2009-10-24 22:30,
Very nice site!
#661 by woptorto (117.20.54.54) At 2009-10-07 06:02,
Very nice site! [url=http://ypxoiea.com/qyrxoq/2.html]cheap cialis[/url]
#660 by woptorto (201.91.21.108) At 2009-10-07 06:02,
Very nice site!
#659 by iootpeuo (201.59.216.76) At 2009-10-07 05:51,
Very nice site!
#658 by proruowt (202.143.160.74) At 2009-10-07 03:57,
Very nice site!
#657 by iitytprr (89.39.188.106) At 2009-10-07 02:47,
Very nice site! cheap cialis http://ypxoiea.com/qyrxoq/4.html
#656 by iitytprr (82.236.253.9) At 2009-10-07 02:47,
Very nice site! [url=http://ypxoiea.com/qyrxoq/2.html]cheap cialis[/url]
#655 by iitytprr (219.139.158.59) At 2009-10-07 02:47,
Very nice site!
#654 by wueeyyuw (203.190.50.9) At 2009-10-06 22:03,
Very nice site!
#653 by uwyetioo (115.163.218.47) At 2009-10-06 20:53,
Very nice site! cheap cialis http://ypxoiea.com/qyrxoq/4.html
#652 by uwyetioo (195.131.152.72) At 2009-10-06 20:53,
Very nice site! [url=http://ypxoiea.com/qyrxoq/2.html]cheap cialis[/url]
#651 by uwyetioo (87.204.126.99) At 2009-10-06 20:53,
Very nice site!
#650 by oueuiepe (121.247.170.115) At 2009-10-06 10:43,
Very nice site! [url=http://ypxoiea.com/qyrxoq/2.html]cheap cialis[/url]
#649 by oueuiepe (89.234.192.118) At 2009-10-06 10:42,
Very nice site!
#648 by iwotpwtp (124.40.121.3) At 2009-10-06 02:32,
Very nice site!
#647 by toweetpp (121.241.69.163) At 2009-10-06 02:09,
Very nice site!
#646 by tupiowwt (216.108.226.107) At 2009-10-05 21:18,
Very nice site!
#645 by ruroptye (121.58.184.50) At 2009-10-05 10:35,
Very nice site!
#644 by etrtoupe (202.91.14.46) At 2009-10-05 07:36,
Very nice site!
#643 by twyorioe (203.202.243.69) At 2009-10-05 05:50,
Very nice site!
#642 by orruttow (211.23.82.90) At 2009-10-05 04:37,
Very nice site!
#641 by uwtetyyp (88.81.85.86) At 2009-10-05 02:18,