在安装MySQL之前,我们需要安装一下MySQL的依赖。
MySQL repo安装
MySQL安装后会生成一个初始密码,此时我们查看并将其记录下来,用来第一次登陆MySQL
登陆后依次执行下面的命令,进行初始设置
MySQL安装成功后要做好相应的权限控制,如果需要远程访问,不要对MySQL配置任意IP段的访问,否则会带来一定的安全隐患
grant all privileges on *.* to 'root'@'172.17.0.4' identified by '416798';
grant all privileges on *.* to 'root'@'172.17.0.*' identified by '416798';
grant all privileges on test.* to 'root'@'172.17.0.*' identified by '416798';
grant all privileges on test.temp to 'root'@'172.17.0.*' identified by '416798';
drop user 'root'@'172.17.0.4';