Linux上安装mysql数据库

官网下载

1.必须移动到指定目录（没移我就报错了）

 mv mysql-5.6.43-linux-glibc2.5-x86_64.tar.gz /usr/local/

2.解压

tar -zxvf mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz 

3.重命名

mv mysql-5.6.43-linux-glibc2.12-x86_64 mysql

4.虚拟机是mini版的缺一些依赖

yum -y install numactl perl perl-devel libaio-devel

5.添加系统mysql组和mysql用户

groupadd mysql
useradd -r -g mysql mysql

6.修改当前目录拥有者为mysql用户

chown -R mysql:mysql ./

-----------------------------下面进入/usr/local/mysql/里面安装----------------------

7.安装数据库

./scripts/mysql_install_db --user=mysql

8.mysql服务添加到开机启动项中

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

9.启动mysql服务

service mysql start

10.查看状态

service mysql status

11.设置root账号密码

./bin/mysqladmin -u root -h lyb-31 password '123456'

12.登录mysql

./bin/mysql -uroot -h lyb-31 -p123456

13.远程连接

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;

测试连接账号密码root root

参考这里