groupadd mysql
useradd -g mysql -s /bin/false -M mysql |
安装cmake,及相关包:
yum install -y \
cmake.x86_64 \ gcc \ gcc-c++ \ ncurses-devel.x86_64 \ bison.x86_64 \ libaio.x86_64 |
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/data/mysqldata \ -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DMYSQL_TCP_PORT=3306 \ -DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DMYSQL_USER=mysql \ -DWITH_DEBUG=0 |
Make && make install
|
make clean
rm -f CMakeCache.txt |
cp support-files/my-medium.cnf /etc/my.cnf
cp support-files/mysql.server /usr/local/mysql/bin/ chmod 755 /usr/local/mysql/bin/mysql.server chown -R mysql.root /usr/local/mysql cd /usr/local/mysql mkdir /data/mysqldata scripts/mysql_install_db --user=mysql cp –rpf /usr/local/mysql/data/* /data/mysqldata |
echo " export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile |
mysql.server start
mysql.server stop |
netstat -anp | grep LISTEN
|
[client]
default-character-set=utf8 [mysqld]
default-character-set=utf8 log-bin=mysql-bin
expire_logs_days = 5 |
mysql
查看mysql状态,字符集最好都是utf8 mysql> status;
--------------
mysql Ver 14.14 Distrib 5.5.21, for Linux (x86_64) using EditLine wrapper
Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.21-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /usr/local/mysql/mysql.sock
Uptime: 26 min 45 sec
|