一、linux下安装mysql

参考：https://blog.csdn.net/qq_37598011/article/details/93489404

mysql安装步骤

进入官网：https://dev.mysql.com/downloads/mysql/5.6.html#downloads
下载安装包

创建相关目录

cd /user/local/javaTool
mkdir mysql

上传文件到mysql目录下，解压

tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz mysql-5.7.30

创建mysql组和用户

groupadd mysql
useradd -r -g mysql mysql

创建相应文件夹并授权

cd /user/local/javaTool/mysql
mkdir data
mkdir log
chown mysql:mysql -R /user/local/javaTool/mysql
chown -R 755 /user/local/javaTool/mysql

配置参数

vim /etc/my.cnf


[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/javaTool/mysql/mysql-5.7.30
datadir=/usr/local/javaTool/mysql/data
socket=/tmp/mysql.sock
log-error=/usr/local/javaTool/mysql/log/mysql.err
pid-file=/usr/local/javaTool/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0

初始化mysql

cd /usr/local/javaTool/mysql/mysql-5.7.30/bin
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/javaTool/mysql/mysql-5.7.30/ --datadir=
    /usr/local/javaTool/mysql/data/ --user=mysql --initialize

查看初始密码，复制出来

cat /usr/local/javaTool/mysql/log/mysql.err

启动mysql

service mysqld start  -- 启动
ps -ef | grep mysql 检查是否启动成功

修改密码

cd /usr/local/javaTool/mysql/mysql-5.7.30/bin
./mysql -u root -p
输入密码
SET PASSWORD = PASSWORD('root');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;
quit;

重启mysql服务

service restart mysql

远程连接mysql的错误

错误代码 1130 ERROR 1130 Host …. is not allowed to connection to this mysql server
在远程主机登录mysql

• mysql -u root -p
• 输入密码
• use mysql；
• select ‘host’ from user where user = ‘root’;
• update user set host = ‘%’ where user = ‘root’;
• flush privileges;
• select ‘host’ from user where user = ‘root’;
• quit
• service mysql restart