# 常規方式編譯安裝MySQL 此種方式適合所有MySQL5.0.xx-5.1.xx產品系列，是最常規的編譯方式。 常規方式編譯安裝MySQL就是延續早起MySQL的3部曲安裝方式，即 ``` ./configure make make install ``` ## 添加用戶 ``` useradd mysql -s /sbin/nologin ``` ## 必要軟件包 ``` yum -y install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake curl freetype libjpeg-turbo libjpeg-turbo-devel openjpeg-libs libpng gd ncurses ``` ## 生產場景的具體命令參數為: ``` ./configure \ --prefix=/usr/local/mysql \ --with-unix-socket-path=/var/lib/mysql/mysql.sock \ --localstatedir=/usr/local/mysql/data \ --enable-assembler \ --enable-thread-safe-client \ --with-mysqld-user=mysql \ --with-bid-tables \ --with-debtg \ --with-pthread \ --with-extra-charsets=complex \ --with-readline \ --with-ssl \ --with-embedded-server \ --enable-local-infile \ --with-plugins=partition,innobase \ --with-mysqld-ldflags=-all-static \ --with-client-ldflags=-all-static \ ``` 上面的編譯完成后，執行下面的命令。 ``` make && make install ``` ## 改變目錄所有者 ``` chown -R mysql.mysql /usr/local/mysql ``` ## 初始化數據庫 ``` /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data ``` ## 注冊為服務 ``` cd /usr/local/src/mysql-5.1.59/support-files cp mysql.server /etc/rc.d/init.d/mysqld #使用默認配置文件 cp my-small.cnf /etc/my.cnf #讓chkconfig管理mysqld服務 chkconfig --add mysqld #開機啟動 chkconfig mysqld on ``` ## 啟動MySQL服務 ``` service mysqld start ``` 將mysql的bin加入到path中 ``` cd ~ #把path添加到當前用戶目錄的bashrc中，如果需要全局設定，請修改`/etc/profile` vi .bashrc #加入以下內容 PATH=/usr/local/mysql/bin:$PATH source /etc/profile ``` ## 修改MySQL用戶密碼 ``` mysqladmin -uroot password 'aaaaaa' # 在bash命令行執行` ``` ## 改變編碼，防止亂碼 ``` SHOW VARIABLES LIKE 'character%' ``` * 修改mysql的my.cnf文件 ``` [client] default-character-set=utf8 [mysqld] character-set-server=utf8 pid-file=/var/lib/mysql/mysqld.pid [mysql] default-character-set=utf8 [mysqld_safe] log-error=/var/lib/mysql/mysql_error.err ```