開發環境-Mysql

標籤：密碼   char   roo   result   cat   for   環境   html   .com   

1.解壓壓縮包
2.設定環境變數(mysql \h)
    MYSQL_HOME -> 修改 Path環境變數，添加 %MYSQL_HOME%\lib;
3.配置mysql服務
    mysqld --install [服務名]      mysql服務安裝
    mysqld remove mysql            服務卸載
4.mysql工具安裝(sqlYog/navicat)
5.mysql一些設定作業
    SHOW VARIABLES LIKE ‘character%‘;// 顯示mysql字元設定
    SET character_set_client=‘utf8‘;
    SET character_set_connection=‘utf8‘;
    SET character_set_database=‘utf8‘;
    SET character_set_filesystem=‘binary‘;
    SET character_set_results=‘utf8‘;
    SET character_set_server=‘utf8‘;

    SHOW VARIABLES LIKE ‘collation_%‘;// 顯示mysql字元集設定
    SET collation_connection=‘utf8_general_ci‘;
    SET collation_database=‘utf8_general_ci‘;
    SET collation_server=‘utf8_general_ci‘;

    #設定mysql區分大小寫
    set lower_case_table_names=0

    #my-default.ini
    http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
    [mysqld]
    default-character-set=utf8
    init_connect = ‘SET NAMES utf8‘
    [client]
    default-character-set=utf8

6.mysql改密碼
    set password for [email protected] = password(‘root‘);

開發環境-Mysql