卸载centos默认数据库mariadb
查看mariadb是否有安装:
[
root@bogon java]# rpm -qa | grep mariadb
卸载mariadb,此处为强制卸载:
jdk安装:
查找当前java环境
[
root@host183 ~]# rpm -qa | grep java
卸载openjdk
[
root@host183 ~]# yum -y remove java-1.7.0-openjdk*
安装oracle的jdk,先在/usr目录下创建java目录,将下载好的jdk*.rpm包拷贝至java目录,执行如下命令
[
root@host183 java]# rpm -ivh jdk-7u79-linux-x64.rpm
验证ruby是否安装
[
root@host183 ~]# yum -y install ruby
MySQL安装
查看mysql
[
root@bogon java]# rpm -qa | grep mysql
在线获取mysql5.6
或者在线获取mysql5.7
添加mysql的本地yum库
[
root@bogon java]# rpm -ivh mysql57-community-release-el7-8.noarch.rpm
安装mysql
[
root@bogon yum.repos.d]# yum install mysql-community-server
安装mysql57后会出现mysql无法连接的情况
关闭mysql服务
[
root@bogon ~]# systemctl stop mysqld
设置mysqld_opts到系统环境中,将mysql设置为跳过授权验证状态
[
root@bogon ~]# systemctl set-environment MYSQLD_OPTS="--user=mysql --skip-grant-tables --skip-networking"
重启mysql服务
[
root@bogon ~]# systemctl start mysqld
以mysql用户登录mysql
[
root@bogon ~]# mysql -u mysql
修改mysql中root用户密码
mysql> UPDATE mysql.user SET authentication_string=PASSWORD("Mysql123456") WHERE user='root';
一定要flush一下权限
mysql> flush privileges;
退出mysql
mysql> quit;
取消刚才设置的mysql跳过授权验证的环境变量
[
root@bogon ~]# systemctl unset-environment MYSQLD_OPTS
重启mysql服务
[
root@bogon ~]# systemctl restart mysqld
使用root登录mysql,密码使用刚刚更改的密码
[
root@bogon ~]# mysql -u root -p
登录后需要重新设置root用户密码,并且密码不能与以上设置的相同,同时要具备一定的复杂度
mysql> alter user 'root'@'localhost' identified by 'Mysql*123456';
mysql>create user tungsten identified by 'Mysql*123456' ;
mysql> grant all privileges on *.* to tungsten identified by 'Mysql*123456';