linux系统配置mysql_LINUX系统安装配置Mysql

1. 安装mysql

(1) 解压缩文件，修改名字为mysql

usr/local/mysqll

(2) 创建data目录

/usr/local/mysql/data

(3) 创建用户组以及用户

groupadd mysql

useradd mysql -g mysql

(4) 对mysql目录授权

chown -R mysql.mysql /usr/local/mysql

(5) 初始化安装,记住初始化密码

/usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql --datadir=/usr/local/mysql/data

(6) 复制启动脚本到资源目录

cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld

(7) 增加mysqld服务控制脚本执行权限

chmod +x /etc/rc.d/init.d/mysqld

(8) mysqld服务加入系统服务

chkconfig --add mysqld

chkconfig --list mysqld

(9) 启动mysql服务

service mysqld start

(10) 启动失败，找不到mysql命令

ln -s /usr/local/mysql/bin/mysql /usr/bin

(11) 登录mysql

mysql -u root -p

(12) 登录失败，ERROR 2002

ln -s /var/lib/mysqld/mysql.sock /tmp/mysql.sock

(13) 修改密码

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘密码’;

flush privileges;

(14) 开启3306端口

firewall-cmd –permanent –zone=public –add-port=3306/tcp

firewall-cmd --reload

(15) 测试连接报错,host‘ip’is not allowed

GRANT ALL PRIVILEGES ON *.* TO ‘用户名’@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;

flush privileges;