Liunx部署mysql数据库
1.安装Mysql
1.1.下载mysql
wget mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
yum install mysql-server
1.2.权限设置
chmod -R 777 /var/lib/mysql
1.3.初始化mysql
mysqld --initialize
1.4.启动/关闭/运行状态服务
systemctl start/stop/status mysqld
2.修改密码
第一不先停掉服务,打开my.cnf将mysql无需密码登录
vi /etc/my.cnf //在[mysqld]下加 skip-grant-tables
无密码进入
mysql===>mysql -u root
清空root 密码
UPDATE user SET authentication_string="" WHERE user=“root”;
flush privileges;// //刷新MySQL的系统权限相关表
exit;//退出
将my.cof还原,正常登录;
登录 不输密码
mysql -u root -p
修改密码
alter user 'root'@'localhost' identified with mysql_native_password by '新密码';
设置允许远程连接
GRANT ALL ON *.* TO 'root'@'%'
出现问题:ERROR 1410 (42000): You are not allowed to create a user with GRANT
原因:当前user表中没有root - %记录; 可以更新root - localhost 为 root - %'
update user set host = '%' where user = 'root';
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;