next up previous contents
Next: 安裝 Moodle Up: 安裝 Moodle Previous: 安裝作業系統   Contents

安裝基本套件

  1. 安裝 httpd mysql-server 及 php
    [root@kvm5 ~]# yum install -y httpd mysql-server php php-mysql
    
  2. 查詢 MySQL 預設使用編碼。
    mysql> show variables like 'char%';
    +--------------------------+----------------------------+
    | Variable_name            | Value                      |
    +--------------------------+----------------------------+
    | character_set_client     | latin1                     |
    | character_set_connection | latin1                     |
    | character_set_database   | utf8                       |
    | character_set_filesystem | binary                     |
    | character_set_results    | latin1                     |
    | character_set_server     | utf8                       |
    | character_set_system     | utf8                       |
    | character_sets_dir       | /usr/share/mysql/charsets/ |
    +--------------------------+----------------------------+
    8 rows in set (0.01 sec)
    
  3. MySQL server, client, mysql 皆預設使用 UTF8 編碼。
    [root@kvm5 ~]# vim /etc/my.cnf
    [mysqld]
    collation-server=utf8_general_ci
    character-set-server=utf8
    
    [client]
    default-character-set=utf8
    
    [mysql]
    default-character-set=utf8
    
  4. 再次查詢 MySQL 預設使用編碼,皆已改為 utf8。
    mysql> show variables like 'char%';
    +--------------------------+----------------------------+
    | Variable_name            | Value                      |
    +--------------------------+----------------------------+
    | character_set_client     | utf8                       |
    | character_set_connection | utf8                       |
    | character_set_database   | utf8                       |
    | character_set_filesystem | binary                     |
    | character_set_results    | utf8                       |
    | character_set_server     | utf8                       |
    | character_set_system     | utf8                       |
    | character_sets_dir       | /usr/share/mysql/charsets/ |
    +--------------------------+----------------------------+
    8 rows in set (0.00 sec)
    
  5. MySQL server, client, mysql 皆預設使用 UTF8 編碼。
    [root@kvm5 ~]# vim /etc/my.cnf
    [mysqld]
    collation-server=utf8_general_ci
    character-set-server=utf8
    
    [client]
    default-character-set=utf8
    
    [mysql]
    default-character-set=utf8
    
  6. 啟動 httpd 及 mysqld
    [root@kvm5 ~]# /etc/init.d/mysqld start
    Initializing MySQL database:  Installing MySQL system tables...
    OK
    Filling help tables...
    OK
    
    To start mysqld at boot time you have to copy
    support-files/mysql.server to the right place for your system
    
    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    To do so, start the server, then issue the following commands:
    
    /usr/bin/mysqladmin -u root password 'new-password'
    /usr/bin/mysqladmin -u root -h kvm5.deyu.wang password 'new-password'
    
    Alternatively you can run:
    /usr/bin/mysql_secure_installation
    
    which will also give you the option of removing the test
    databases and anonymous user created by default.  This is
    strongly recommended for production servers.
    
    See the manual for more instructions.
    
    You can start the MySQL daemon with:
    cd /usr ; /usr/bin/mysqld_safe &
    
    You can test the MySQL daemon with mysql-test-run.pl
    cd /usr/mysql-test ; perl mysql-test-run.pl
    
    Please report any problems with the /usr/bin/mysqlbug script!
    
                                                       [  OK  ]
    Starting mysqld:                                   [  OK  ]
    
    [root@kvm5 ~]# mysqladmin -uroot password '123qwe'
    [root@kvm5 ~]# chkconfig mysqld on
    [root@kvm5 ~]# /etc/init.d/httpd start
    Starting httpd:                                    [  OK  ]
    [root@kvm5 ~]# chkconfig httpd on
    



2017-06-15