(1)将下载的mysql-5.6.40.tar上传到服务器/usr/local/下;
(2)检查并卸载已安装的mysql或自导的mariaDB:
rpm -qa |grep mariadb
rpm -qa |grep mysql
rpm -e --nodeps xxx
(3)删除所有的相关文件:
rm /etc/my.cnf
(4)解压并进行编译和安装:
tar zxvf mysql-5.6.40.tar
mv mysql-5.6.40 mysql
cd mysql
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
(5)检查系统是否已经有mysql用户,如果没有则创建:
cat /etc/passwd | grep mysql
cat /etc/group | grep mysql
创建mysql用户:
groupadd mysql
useradd -g mysql mysql
修改权限:
chown -R mysql:mysql /usr/local/mysql
安装数据库:
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
(6)添加防火墙:
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
(7)添加服务,并设置开机启动:
cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
service mysql start
netstat -anp | grep 3306
(8)设置root用户密码,并设置可远程访问:
mysql -uroot
use mysql
UPDATE user SET PASSWORD=PASSWORD('ffcsip') where USER='root';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'ffcsip' WITH GRANT OPTION;
QUIT
(9)重启服务:
service mysql restart
说明:首次登录报错拒绝,输入以下命令即可:
sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
sudo mysql -u root mysql