linux安装mysql
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
1.查看是否安装过mysql
rpm -qa | grep mysql
如果安装过就删除 rpm -e --nodeps …
查看mysql的文件夹:
whereis mysql
find / -name mysql
如果有则全部删除 rm -rf …
2.下载安装包
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
3.解压并更名
cd /usr/local
然后用xftp上传压缩包到服务器
tar -zxvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.31-linux-glibc2.12-x86_64/ mysql
4.mkdir /usr/local/mysql/data
5.添加组和用户
groupadd mysql
useradd -r -g mysql mysql
6.授权
chown -R mysql:mysql /usr/local/mysql/
chmod -R 755 /usr/local/mysql/
7.修改文件 vi /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
socket=/usr/local/mysql/data/mysql.sock
symbolic-links=0
max_connections=400
innodb_file_per_table=1
lower_case_table_names=1
log-error=/usr/local/mysql/data/mysql.err
pid-file=/usr/local/mysql/data/mysql.pid
8.切换到bin
cd /usr/local/mysql/bin
9.初始化
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
查看日志 cat /usr/local/mysql/data/mysql.err
root@localhost: 0.&P&C7rhrHu 用户名和密码
10.ln -s /usr/local/mysql/data/mysql.sock /tmp/mysql.sock
11.添加软链接并启动mysql
ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
service mysql start
12.登录mysql
mysql -u root -p
13.通过临时密码登录之后修改密码
alter user user() identified by “123456”;
14.允许远程连接
use mysql;
update user set user.Host=’%’ where user.User=‘root’;
flush privileges;
exit; 退出
15.打开防火墙开放3306端口
systemctl start firewalld
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload