groupadd mysql
useradd -g mysql mysql
yum install cmake
解压mysql的源码包目录例如为/opt/mysql
在/opt/mysql目录中运行:
cmake -DCMAKE_INSTALL_PREFIX=/mysql \
-DMYSQL_DATADIR=/mysqldata \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_unicode_ci \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_DEBUG=0
结束后运行make && make install
cp /mysql/support-files/my-medium.cnf /my.cnf
在my.cnf
[mysqld]中加入:
datadir=/mysqldata
default-storage-engine=MyISAM
cp /mysql/support-files/mysql.server /etc/init.d/mysql
chmod 755 /etc/init.d/mysql
chkconfig mysql on --添加开机自动
安装测试数据库
./mysql/scripts/mysql_install_db
附:
-DCMAKE_INSTALL_PREFIX:指定安装目录
mysql添加用户
在user表中insert,开启远程连接,将host的值改为%
授权
GRANT ALL privileges ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'password';
GRANT SELECT,INSERT ,CREATE,UPDATE privileges ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'password';