centos下mysql安装部署

上一篇 / 下一篇  2018-06-04 11:16:39 / 个人分类:mysql

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 


TAG:

 

评分:0

我来说两句

Open Toolbar