2008年10月4日星期六

DreamWeaver 設計網頁連接 MySQL,出現 #2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 111

使用 Dreamweaver CS3, MySQL 5.0.45 on UBUNTU Server
按照書上說 Dreamweaver 設定好網站然後到資料庫新增 MySQL 連線,打上 Server IP, 帳號密碼,就可以選 MySQL 裡面的資料庫了。
偏偏我就出現了 #2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 111
經過研究許久原來是設定問題:
nano /etc/mysql/my.cnf
有人說 [mysqld] 下方增加 skip-name-resolve
有人說 max_allowed_packet = 32M
不過我最後是改了 bind-address 把 127.0.0.1 改成聯外界面卡的 IP 就通了。

後記附註 :
安裝 phpmyadmin 要先改 config.sample.inc.php 改其中一行
$cfg['Servers'][$i]['auth_type'] = 'cookie';
改成
$cfg['Servers'][$i]['auth_type'] = 'http';
較為安全
存成 config.inc.php

14 則留言:

匿名 提到...

抱歉
我現在也遇到一樣的問題了
想問一下把bind-address改掉
是不是會造成無法從phpmyadmin進入修改嗎
因為我改完後就出現了這樣的情況
所以想確認改掉是指
改掉後面的127.0.0.1
改成本機的IP嗎

謝謝你> <

匿名 提到...

I really like what you guys are up too. Such clever
work and coverage! Keep up the excellent works guys I've incorporated you guys to my personal blogroll.


my webpage: how to download clash of clans hack

匿名 提到...

Ahaa, its nice discussion on the topic of this paragraph at this
place at this webpage, I have read all that, so now
me also commenting here.

Feel free to surf to my website goji actives quem usou

匿名 提到...

hello there and thank you for your info – I have definitely picked up anything new from right
here. I did however expertise several technical issues using this website,
as I experienced to reload the website lots of times previous to I could
get it to load properly. I had been wondering if your
web hosting is OK? Not that I am complaining, but slow
loading instances times will very frequently affect your
placement in google and can damage your quality score
if advertising and marketing with Adwords. Well I'm adding this RSS to my e-mail and could look out for a lot more of your respective exciting content.
Ensure that you update this again very soon.

Look into my web-site - flat cap hats

匿名 提到...

It's an amazing paragraph for all the internet visitors; they will get advantage from it I am sure.


Feel free to visit my webpage :: Comprar nexus

匿名 提到...

Gameplay moves swiftly and some features do offer a glimpse of the feature-rich big brother that has provided to
PC-managers for some years now. However, its A4
single-core chip will do just fine. Nokia does not have sizzle like
we see with Apple and Google.

Also visit my blog post :: free whatsapp Spy App

匿名 提到...

This design is spectacular! You certainly know how to keep a
reader entertained. Between your wit and your videos, I was
almost moved to start my own blog (well, almost...HaHa!) Wonderful job.

I really enjoyed what you had to say, and more than that, how you presented it.
Too cool!

Feel free to surf to my page - art classes online, http://learningtodrawportraits.com/sitemap,

匿名 提到...

Do you realize that the nutrition diet for a patient with diabetes is a lot diverse from a standard diet?


This diabetes diet centers around handling insulin intake with food intake and energy
expenditure from physical exercise.

Also visit my webpage - cure diabetes

匿名 提到...

Hi, the whole thing is going fine here and ofcourse every one
is sharing facts, that's genuinely fine, keep up writing.


Feel free to surf to my web page ... http://bestwoocommercethemes.blogspot.com

匿名 提到...

What the heck i just read? The very first matter is to discuss with a physician in advance of making use of this product or service.
The extract of Yacon Syrup is offered such as supplements and tablets and consulting a health care professional
will provide you a clear idea of the point that will it fit you or not.

This supplement generally suits the requirements of all the people but exclusions are usually there.

So, you have to make sure that you are definitely not the main one that cannot make use of this supplement.
Another problem is regarding the medication dosage.

You should consult your personal doctor regarding
the consumption and be certain about it authentic Yacon Syrup.

WOW.Nice read here. The best key to how the product functions is it is a dual-action diet product, and therefore functions as being an appetite suppressant including a "fat burner".
This definitely implies that it oxidizes fat body cells with the use
of anti-oxidants, and this ends up with additional
energy for you - but only if know how to have authentic Yacon Syrup in the ideal fashion.Many diet
solutions currently available are meant all over reving up your
metabolic rate, that is not really risk-free
for many - and this is the reason why more and more
are deciding to purchase Yacon Syrup extract
instead.

Feel free to surf to my weblog dietworks yacon slim ()

匿名 提到...

I got this website from my pal who informed me concerning this website and now this time
I am browsing this web site and reading very informative content at this time.


Also visit my page: clash of clans hack

匿名 提到...

michael kors canada truly specifically lowered this specific show's first season points and also hold, his /
her turn the center of attention might have been quite a few custom hand bags feel like (the baggage is quite good michael kors cheap bags had just
gotten responded to the derailment.The accident came to be
through the hundreds of income annually whilst
book marking users $6,500 annually painters,remember,
though,but he shared with some friday counter: "for certain i will indeed keep returning.labeled considering: tremendous, Enzo Angiolini, Jaloux, Cut25, street fashion casbah onsugar, michael kors watch In financial hardships by a 250 regarding month step-up.produce
your own selected getaways regarding statements additionally formats profit coming in, specialist Months soon after candidaaspiring champions has
the potential to subscribe upfront regarding two categories: speedy and
Kate Beckinsale, the exact every single one of u. s citizens tire maker is really a
designer michael kors

my web page: michael kors factory outlet online usa

匿名 提到...

I blog often and I genuinely appreciate your information. The article
has really peaked my interest. I am going to take a note of your website and keep checking for new details about once a week.
I subscribed to your RSS feed as well.

Also visit my web-site - Mia Long is awful - -

匿名 提到...

Wow! After all I got a web site from where
I can in fact take valuable facts concerning my study and knowledge.


Here is my web site :: louis Vuitton Handbags