mysql root 密碼更改
如果忘記了 MySQL 的 root 密碼,可以用以下方法重新設定:
1. 關閉 MySQL 伺服器。
/etc/rc.d/init.d/mysqld stop
2. 用以下指令啟動 MySQL,以跳過檢查權限的資料表
mysqld_safe --skip-grant-tables &
(顯示訊息 nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql 直接按Enter)
3. 現在己經可以用空密碼進入 MySQL
mysql -u root
4. 進入 MySQL 後執行以下指令更改 mysql root 密碼:
mysql> update mysql.user set password=PASSWORD(」new_password」) where User=』root';
mysql> flush privileges;
mysql> quit
5. 最後只需重新啟動 MySQL,便可以用新設定的密碼進入了。
參考自:http://www.cosa.org.tw/forum/index.php?topic=73.0
迴響
mysql root 密碼更改 | 豬窩
What's up colleagues, fastidious post and nice arguments commented
at this place, I am genuinely enjoying by these.
mysql root 密碼更改 | 豬窩
Hey there! This is kind of off topic but I need some guidance from an established blog.
Is it very hard to set up your own blog? I'm not very techincal but I can figure
things out pretty fast. I'm thinking about creating my own but I'm
not sure where to begin. Do you have any tips or suggestions?
Thank you
mysql root 密碼更改 | 豬窩
The market is a dynamic, pulsing entity. It modifications with the beat of time and it is vitally vital
for all enterprise ventures to keep up with the changing tides of the market.This makes it needed for the
ventures to need to come up with vivid and different advertising techniques.
These strategies are solely as profitable as the quantity of research and effort that goes
in their developing.The world market is unforgiving and ever
changing, having established that, it turns into
necessary for firms in different components of the world to
consider the areas that they are based in before they can even take into
consideration trying at the whole international market scene.Canada is a robust nation and one that's given to witness immense changes in its economical growth.
There are some essential components in and round Canada
that make up an enormous bulk of the world market.The
areas of Montreal, Quebec, Calgary, Toronto and Vancouver are fairly essential and they have a dense focus of budding and established businesses and
industries. It's no surprise that the Canadian economy has to all the time provide
you with contemporary ideas to promote their business ventures and small
industries.It's true that the internet has made the whole world come humbly at our fingertips.
It is a software that has been utilized by many to advertise
their enterprise and Canada has additionally tailored to web marketing methods
fairly swiftly and comfortably up to now decade.Lead era is
a vital advertising approach whereby some specific web sites
or search engines run a sign up program or lure in interested prospects to enroll in presents and in this method they accumulate information about the potential customer
and as soon as the customer has proven curiosity sufficient to enroll and inquire in regards to
the product, it is clear that the they are an interested customer and they're treated as leads.
The company tries its greatest for the successful conversions of the
leads into customers.There are many lead technology companies and websites which might be initially primarily
based in Canada. These corporations take a great stock of the background analysis and
scoping out of their residence market and the economic surroundings of Canada.This helps them to run a strategic lead generation program and many of the leads get chosen from
across the country which just reduces the abroad hassles in some cases and will increase the
sales in the residence market for some businesses.Acquiring recent qualified enterprise leads is considered to be
the basic part of the expansion of any company today. With the level of competition rising at an alarming tempo, companies must take stable steps to stay in the competitors and qualified leads are
a simple and effective technique to do that. There are several
firms that supply several various kinds of
enterprise leads. Nonetheless, it might be essential to totally look at the
lead generation company before investing within the
leads.
mysql root 密碼更改 | 豬窩
Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my
blog that automatically tweet my newest twitter updates.
I've been looking for a plug-in like this for quite some
time and was hoping maybe you would have some experience with something like this.
Please let me know if you run into anything. I truly enjoy
reading your blog and I look forward to your
new updates.
mysql root 密碼更改 | 豬窩
Just wish to say your article is as amazing.
The clearness in your post is just spectacular and
i can assume you're an expert on this subject.
Fine with your permission let me to grab your RSS feed to keep up to date with forthcoming post.
Thanks a million and please keep up the enjoyable work.