首先先 Kill 掉所有 MySQL 的連線
# on Linux
/etc/init.d/mysqld stop
# on FreeBSD
/usr/local/etc/rc.d/mysql-server stop
killall -9 mysqld
然後進入 MySQL 安全模式
mysqld_safe -u root --skip-grant-tables &
然後利用文字介面修改 MySQL root 密碼
mysql
>use mysql
>UPDATE user SET password=password(’這裡輸入你的密碼’) where user=’root’;
>FLUSH PRIVILEGES;
>exit
dump database
mysqladmin -uroot -p flush-logs
mysqldump phpbb2 -B -uroot -p –opt > phpbb2_20020601.sql
–databases 或 -B 日後會自動建立該資料庫
dump table
mysqldump phpbb2 -uroot -p –opt phpbb2_users > phpbb2_users_20020601.sql
DB backup
如果另外一台電腦上沒有phpbb2這個DB記得要新增一個
mysql -uroot -p -e “CREATE DATABASE phpbb2″
then
mysql phpbb2 -uroot -p < phpbb2_20020601.sql
A.5.4.1.1. Resetting the Root Password on Windows Systems
Use the following procedure for resetting the password for any MySQL root accounts on Windows:
Log on to your system as Administrator.
Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:
Start Menu -> Control Panel -> Administrative Tools -> Services
Then find the MySQL service in the list, and stop it.
If your server is not running as a service, you may need to use the Task Manager to force it to stop.
Create a text file and place the following statements in it. Replace the password with the password that you want to use.
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
The UPDATE and FLUSH statements each must be written on a single line. The UPDATE statement resets the password for all existing root accounts, and the FLUSH statement tells the server to reload the grant tables into memory.
Save the file. For this example, the file will be named C:\mysql-init.txt.
Open a console window to get to the command prompt:
Start Menu -> Run -> cmd
Start the MySQL server with the special --init-file option:
C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt
If you installed MySQL to a location other than C:\mysql, adjust the command accordingly.
The server executes the contents of the file named by the --init-file option at startup, changing each root account password.
You can also add the --console option to the command if you want server output to appear in the console window rather than in a log file.
Users of MySQL 4.1 and higher who installed MySQL using the MySQL Installation Wizard may need to specify a --defaults-file option:
C:\> "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt.exe"
--defaults-file="C:\Program Files\MySQL\MySQL Server 4.1\my.ini"
--init-file=C:\mysql-init.txt
The appropriate --defaults-file setting can be found using the Services Manager:
Start Menu -> Control Panel -> Administrative Tools -> Services
Find the MySQL service in the list, right-click on it, and choose the Properties option. The Path to executable field contains the --defaults-file setting.
After the server has started successfully, delete C:\mysql-init.txt.
Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use.
You should now be able to connect to MySQL as root using the new password.
# on Linux
/etc/init.d/mysqld stop
# on FreeBSD
/usr/local/etc/rc.d/mysql-server stop
killall -9 mysqld
然後進入 MySQL 安全模式
mysqld_safe -u root --skip-grant-tables &
然後利用文字介面修改 MySQL root 密碼
mysql
>use mysql
>UPDATE user SET password=password(’這裡輸入你的密碼’) where user=’root’;
>FLUSH PRIVILEGES;
>exit
dump database
mysqladmin -uroot -p flush-logs
mysqldump phpbb2 -B -uroot -p –opt > phpbb2_20020601.sql
–databases 或 -B 日後會自動建立該資料庫
dump table
mysqldump phpbb2 -uroot -p –opt phpbb2_users > phpbb2_users_20020601.sql
DB backup
如果另外一台電腦上沒有phpbb2這個DB記得要新增一個
mysql -uroot -p -e “CREATE DATABASE phpbb2″
then
mysql phpbb2 -uroot -p < phpbb2_20020601.sql
A.5.4.1.1. Resetting the Root Password on Windows Systems
Use the following procedure for resetting the password for any MySQL root accounts on Windows:
Log on to your system as Administrator.
Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:
Start Menu -> Control Panel -> Administrative Tools -> Services
Then find the MySQL service in the list, and stop it.
If your server is not running as a service, you may need to use the Task Manager to force it to stop.
Create a text file and place the following statements in it. Replace the password with the password that you want to use.
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
The UPDATE and FLUSH statements each must be written on a single line. The UPDATE statement resets the password for all existing root accounts, and the FLUSH statement tells the server to reload the grant tables into memory.
Save the file. For this example, the file will be named C:\mysql-init.txt.
Open a console window to get to the command prompt:
Start Menu -> Run -> cmd
Start the MySQL server with the special --init-file option:
C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt
If you installed MySQL to a location other than C:\mysql, adjust the command accordingly.
The server executes the contents of the file named by the --init-file option at startup, changing each root account password.
You can also add the --console option to the command if you want server output to appear in the console window rather than in a log file.
Users of MySQL 4.1 and higher who installed MySQL using the MySQL Installation Wizard may need to specify a --defaults-file option:
C:\> "C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt.exe"
--defaults-file="C:\Program Files\MySQL\MySQL Server 4.1\my.ini"
--init-file=C:\mysql-init.txt
The appropriate --defaults-file setting can be found using the Services Manager:
Start Menu -> Control Panel -> Administrative Tools -> Services
Find the MySQL service in the list, right-click on it, and choose the Properties option. The Path to executable field contains the --defaults-file setting.
After the server has started successfully, delete C:\mysql-init.txt.
Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use.
You should now be able to connect to MySQL as root using the new password.
電漿的發光原理是在真空玻璃管中注入惰性氣體或水銀氣體，利用加電壓方式，使氣體產生電漿效應並放出紫外線，激發紅藍綠RGB三原色，發出的光線不經電子槍掃描或背光產生，而是每個個體在同一時間獨立發光，利用激發時間的長短來產生不同的亮度，所以顏色也特別鮮明。使用壽命約為5到6萬個小時，其亮度會隨著使用的時間衰退。
OLED具有自發光性、廣視角、高對比、低耗電、高反應速率、全彩化等優點，是近來廣泛被報導將取代目前TFT-LCD的顯示技術，OLED顯示器的種類可分單色、多彩及全彩等種類，而其中以全彩製作技術最為困難。OLED目前仍處於面板價格高、良率低的情況，目前少部分被應用於手機、相機等手持式等小型設備中，Sony也於去年發表11吋的OLED TV，具有更加輕薄與清晰的畫質， 目前開出最大的OLED面板為Samsung的21吋，預計至2010年才會開始普及。
SED的技術顯像原理與CRT映像管類似，都是利用電子撞擊螢光物質來呈現畫面，所以具有高對比、廣視角、反應快、不需濾光片與背光的特性，不同之處在於CRT是利用單一的電子槍來回掃描螢幕，所以需要一定的深度讓電子束折射；但是SED是一個發光點對應一個微型的電子槍，且不需偏折設計，有效減少以往映像管造成的體積問題，同時也比液晶顯示器來得薄。雖然到目前為止還沒有正式的商品出現，但SED仍是被看好的顯示技術之一。
VGA（Video Graphics Array）是在1987年由美國IBM公司發表的電腦顯示器連接端子，是目前最常見的顯示器連接埠，由於接頭採用類似於英文D的形狀，共有三排15個針角，因此稱為D-sub。不過因為採用類比訊號， 現在已逐漸被數位訊號的DVI取代；但仍可透過轉接方式使用。
‧RCA
S端子也稱做獨立視訊端子， S 是表示「Separate單獨」的意思。它是一種將視頻訊號分成光亮度和色度兩個單獨的訊號傳送的模擬視頻接頭，不像RCA使用將所有訊號整合成一個綜合訊號傳送。
DVI的「Digital Visual Interface」，中文翻為「數位視訊介面」。是透過數位的訊號傳送，強化顯示器的畫面品質。目前已被廣泛應用於液晶顯示器、投影機等設備上，可以傳送未壓縮的視頻資料到顯示裝置。DVI連接埠共有三種，DVI-A負責傳送類比訊號、DVI-D負責傳送數位訊號、DVI-I則可相容傳送類比及數位訊號。
HDMI的英文全稱是「High Definition Multimedia Interface」，中文為「高清晰度多媒體介面」，是一種全數位化的多媒體傳輸介面，是以DVI為基礎所開發的高頻寬傳輸規格（相容於DVI），可以傳送無壓縮的「音頻」以及「視訊」信號。目前HDMI最新規格為1.3，增加了超高資料量的無壓縮音頻串流如Dolby TrueHD與DTS-HD格式的支援。
Full HD
HD Ready是歐洲資訊通訊技術協會（EICTA）在2004年1月宣布的標準。是為了區別出顯示設備的品質，能夠處理和顯示高清晰度電視的訊號。
藍光光碟（Blu-ray Disc，簡稱為BD），是DVD光碟的次世代光碟格式之一，用以儲存高品質的影音訊號及大容量的檔案資料。藍光光碟是由新力及松下電器產業等企業組成的「藍光光碟聯盟」（Blu-rayDisc Association）推動的次世代光碟規格，並於2006年開始全面推動藍光光碟的相關產品。
HD DVD的全名為High Definition DVD，是由東芝、NEC、三洋電機等企業組成的HD DVD推廣協會（HD DVD Promotion Group）負責制定及開發。由於經過DVD論壇的認證，所以可相容播放現有DVD光碟，而且一部HD DVD影片中同時也能並存傳統DVD版本的影片。
3C 評測 (1)