[教學] AppServ 2.4.6迅速安裝法(已經解決帳號問題)
發表於 : 2006-08-27 05:00
AppServ 2.4.6安裝法
---------------------------------
架設環境:
# AppServ 2.4.6 Apache 2.0.58
# MySQL 5.0.22
# PHP 4.4.2
# phpMyAdmin-2.8.2
----------------------------------
教學法:
1.安裝 AppServ 2.4.6
2.以root帳號登入,並建立新帳號 aaa (localhost/%),選擇不要密碼
3.去更改config.ini.php中的
第31行 $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin';
第71-74行 $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
4.到DOS模式下
切換到c:\AppServ\www\mysql\bin
輸入mysql –u aaa –p
密碼輸入(不用密碼直接按Enter鍵)
MySQL的文字操作環境後就會出現
mysql>
並且輸入
mysql> SET PASSWORD FOR 'aaa'@'localhost' = OLD_PASSWORD('1234');
mysql> SET PASSWORD FOR 'aaa'@'%' = OLD_PASSWORD('1234');
更改密碼完畢
5.再開啟網頁,就可以用新帳號及密碼登入了
---------------------------------
問題:
順便請教各位一個問題~~
登入phpMyAdmin以後...為何會出現..."不知名語言: zh-tw."???
而這樣的狀況會造成在phpMyAdmin那邊的Language欄位中,不管選擇哪一種語言,都會跳回"中文-Chinese traditional".
目前已經試過用站上現有的教學法來更改成為utf8,結果會造成帳號無法登入的現象
(http://phpbb-tw.net/phpbb/viewtopic.php ... 0&start=30)
以下提供自己的 C:\Appserv\Mysql\my.ini 檔案給各位大大參考
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
[mysql]
default-character-set=latin1
我把上面的latin1改成utf8
再來
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/AppServ/MySQL"
#Path to the database root
datadir="C:/AppServ/MySQL/data/"
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
我把上面的latin1改成utf8
更改完以後重新開機的結果就是,原本已經可以使用的新帳號,變成無法登入!!
煩請各位大大們幫忙指導一下~~
謝謝~~~
---------------------------------
架設環境:
# AppServ 2.4.6 Apache 2.0.58
# MySQL 5.0.22
# PHP 4.4.2
# phpMyAdmin-2.8.2
----------------------------------
教學法:
1.安裝 AppServ 2.4.6
2.以root帳號登入,並建立新帳號 aaa (localhost/%),選擇不要密碼
3.去更改config.ini.php中的
第31行 $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin';
第71-74行 $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
4.到DOS模式下
切換到c:\AppServ\www\mysql\bin
輸入mysql –u aaa –p
密碼輸入(不用密碼直接按Enter鍵)
MySQL的文字操作環境後就會出現
mysql>
並且輸入
mysql> SET PASSWORD FOR 'aaa'@'localhost' = OLD_PASSWORD('1234');
mysql> SET PASSWORD FOR 'aaa'@'%' = OLD_PASSWORD('1234');
更改密碼完畢
5.再開啟網頁,就可以用新帳號及密碼登入了
---------------------------------
問題:
順便請教各位一個問題~~
登入phpMyAdmin以後...為何會出現..."不知名語言: zh-tw."???
而這樣的狀況會造成在phpMyAdmin那邊的Language欄位中,不管選擇哪一種語言,都會跳回"中文-Chinese traditional".
目前已經試過用站上現有的教學法來更改成為utf8,結果會造成帳號無法登入的現象
(http://phpbb-tw.net/phpbb/viewtopic.php ... 0&start=30)
以下提供自己的 C:\Appserv\Mysql\my.ini 檔案給各位大大參考
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
[mysql]
default-character-set=latin1
我把上面的latin1改成utf8
再來
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/AppServ/MySQL"
#Path to the database root
datadir="C:/AppServ/MySQL/data/"
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
我把上面的latin1改成utf8
更改完以後重新開機的結果就是,原本已經可以使用的新帳號,變成無法登入!!
煩請各位大大們幫忙指導一下~~
謝謝~~~
