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
