下载安装文件
#wget http://dev.mysql.com/get/archives/mysql-5.6/mysql-5.6.23.tar.gz
#wget http://www.cmake.org/files/v3.1/cmake-3.1.1.tar.gz
安装cmake
#tar zxf cmake-3.1.1.tar.gz
#./configure
#make && make install
安装mysql
#tar zxf mysql-5.6.23.tar.gz
#cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
#make && make install
配置mysql
#cat /etc/passwd --查看用户列表
#cat /etc/group --查看用户组列表
#groupadd mysql --创建组
#useradd -g mysql mysql --创建用户
#chown -R mysql:mysql /usr/local/mysql --修改权限
#/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --创建库
#mv /etc/my.cnf /etc/my.cnf.bak --备份默认my.cnf
启动mysql
#cp support-files/mysql.server /etc/init.d/mysql
#chmod a+wrx /etc/init.d/mysql
#chkconfig mysql on
#service mysql start
Starting MySQL. SUCCESS!
配置user
#vi /etc/profile
PATH=/usr/local/mysql/bin:$PATH
export PATH
#source /etc/profile --立即生效
#mysql -uroot --首次登录
mysql> SET PASSWORD = PASSWORD('123456'); --修改密码
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; --配置远程访问
最新评论