Linux安装Mysql

1、检查是否已经安装过mysql

rpm -qa | grep mysql

2.如果有删除

rpm -e --nodeps mysql-libs-版本

3.检查mysql用户组和用户，没有则创建

cat /etc/group | grep mysql
cat /etc/passwd |grep mysql
groupadd mysql
useradd -r -g mysql mysql

4.下载mysql安装包

mkdir /usr/local/mysql #创建文件
#创建data目录
mkdir /usr/local/mysql/data
cd mysql
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

5.解压

tar xzvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

6.编译安装并初始化mysql

cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
#[Note] A temporary password is generated for root@localhost: 7(h4l>Qnj8t3#为密码

7.启动mysql

/usr/local/mysql/support-files/mysql.server start
如果出现如下提示信息
Starting MySQL.Logging to '/usr/local/mysql/data/iZge8dpnu9w2d6Z.err'.
#查询服务
ps -ef|grep mysql
ps -ef|grep mysqld

kill -9 pid #停止进程

8.添加软连接，并重启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 restart
#启动成功!
MySQL server process #3257 is not running!                 [FAILED]
Starting MySQL.                                            [  OK  ]

9.等入mysql，修改密码

mysql -u root -p

首先安装后，执行任何指令都会提示：
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
将临时密码修改
>ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
刷新权限
>flush privileges;

10.开发远程连接

>use mysql;
>update user set user.Host='%' where user.User='root';
>flush privileges;