02-mysql-安裝,mac安裝02mysql
02-mysql-安裝
----MySQL安裝版本
以及技術文檔
mysql目前常用版本 mysql-5.6.15.tar.gz
----MySQL編譯安裝
1. 安裝環境要求:mysql使用者和組且ID為27,安裝軟體make,cmake,gcc,gcc-c++,ncurses-devel ,bison。 groupadd -g 27 mysqluseradd -u 27 -g mysql -s /sbin/nologin -M mysql
2.建立安裝目錄/usr/local/mysql5.6 ,資料目錄/database,PID目錄/var/run/mysqld,日誌目錄/var/log/mysqld。 設定檔目錄/usr/local/mysql5.6/etc
3.cmake -LH 產生CMakeCache.txt, 在make是就按這個cache檔案來編譯(這樣全是預設,建議使用步驟4)。
4.制定CMakeCache.txt檔案
cmake \
-DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql5.6 \ 指定安裝路徑
-DMYSQL_DATADIR:PATH=/database \ 指定資料庫路徑
-DSYSCONFDIR:PATH=/usr/local/mysql5.6/etc \ 指定設定檔路徑
-DWITH_DEBUG:BOOL=on 開啟調試功能
5.編譯軟體make
6.安裝軟體make install
7.MySQL設定檔修改/usr/local/mysql5.6/etc/my.cnf
[mysqld]
basedir=/usr/local/mysql5.6
datadir=/database
socket=/var/run/mysqld/mysql5.6.sock
pid-file=/var/run/mysqld/mysql5.6.pid
port=3307 預設是3306
user=mysql
[mysqld_safe]
log-error=/var/log/mysqld/mysql5.6-error.log
8.給各個相關目錄賦予mysql許可權
chown -R myslq.mysql /usr/local/mysql5.6 /database /var/run/mysqld/ /var/log/mysqld
9.執行mysql_install_db 指令檔
/usr/local/mysql5.6/scripts/mysql_install_db --basedir=/usr/local/mysql5.6 --datadir=/database --user=mysql
10.複製啟動命令檔案到系統目錄
cp /usr/local/mysql5.6/support-files/mysql.server /etc/rc.d/init.d/mysql5.6或/etc/init.d/mysqld
11.設定開機啟動mysql,和啟動myslqd
chkconfig --add mysql5.6
service mysql5.6 start
12.配置環境變數將/usr/local/mysql5u6/bin 添加到profile中
export PATH=$PATH:/usr/local/mysql5u6/bin
使檔案生效
source /etc/profile
03-mysql-自動安裝指令碼
#!/bin/bash
#comment
#./mysql-5.6.sh mysql-5.6.15.tar.gz
#:set ff=unix
#:set nobomb
name1="$1"
name2=${name1/.tar.gz/}
if ! grep -qi "^mysql" /etc/group; then
groupadd -g 27 mysql
fi
if ! id mysql >/dev/null 2>&1; then
useradd -u 27 -g mysql -s /sbin/nologin -M mysql
fi
yum install -y make cmake gcc gcc-c++ ncurses-devel bison >/dev/null 2>&1
[ -d /usr/local/mysql5.6 ] && rm -rf /usr/local/mysql5.6
[ -d /database ] && rm -rf /database/* || mkdir /database
if [ -d "$name2" ]; then
[ -e "$name2/CMakeCache.txt" ] && rm -f "$name2/CMakeCache.txt"
else
tar xf "$name1"
fi
cd $name2
#man cmake
#cmake -LH 產生CMakeCache.txt, make就按這個cache檔案來編譯
#-D
cmake \
-DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql5.6 \
-DMYSQL_DATADIR:PATH=/database \
-DSYSCONFDIR:PATH=/usr/local/mysql5.6/etc \
-DWITH_DEBUG:BOOL=on
make
make install
mkdir /usr/local/mysql5.6/etc
cat <<! >/usr/local/mysql5.6/etc/my.cnf
[mysqld]
basedir=/usr/local/mysql5.6
datadir=/database
socket=/var/run/mysqld/mysql5.6.sock
pid-file=/var/run/mysqld/mysql5.6.pid
port=3307
user=mysql
[mysqld_safe]
log-error=/var/log/mysqld/mysql5.6-error.log
!
[ -d /var/run/mysqld ] && rm -rf /var/run/mysqld/* || mkdir /var/run/mysqld
[ -d /var/log/mysqld ] && rm -rf /var/log/mysqld/* || mkdir /var/log/mysqld
chown -R mysql.mysql /usr/local/mysql5.6 /database /var/run/mysqld /var/log/mysqld
/usr/local/mysql5.6/scripts/mysql_install_db --basedir=/usr/local/mysql5.6 --datadir=/database --user=mysql
cp /usr/local/mysql5.6/support-files/mysql.server /etc/rc.d/init.d/mysql5.6
sed -i '/conf=/c conf=/usr/local/mysql5.6/etc/my.cnf' /etc/rc.d/init.d/mysql5.6
chkconfig --add mysql5.6
service mysql5.6 start
怎安裝Mysql
安裝Mysql?單獨安裝還是連同其它一些?因為不知道你的伺服器是什麼類型的.
如果你的伺服器是用的IIS,那麼你還要配置一堆環境,
還不如去下載一個Appserv,這個軟體整合了MYSQL,PHP,Appache伺服器.然後就很容易安裝了.
獨立安裝在我QQ空間中的資料庫那一個日誌類別中有詳細說明.
安裝mysql出現write configuration file通不過
安裝路徑不要帶有中文!
換到另外全部是英文和數位目錄安裝應該就正常了。