mysql 安装配置过程

 rpm -qa|grep mariadb 


rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
rpm -e --nodeps mariadb-server-5.5.56-2.el7.x86_64
rpm -e --nodeps mariadb-5.5.56-2.el7.x86_64


tar -xvf mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar

#阿里云的服务器还需要添加这句
yum install -y libaio
 
 
rpm -ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm
service mysqld start
chkconfig mysqld on



启动mysql
      查看mysql是否启动
	service mysqld status
	
	# 启动mysql
	service mysqld start
	
	# 停止mysql
	service mysqld stop
	
	# 重启mysql
	service mysqld restart

开机后启动服务器
chkconfig mysqld on




1、关闭firewall：

#停止firewall
 #禁止firewall开机启动

systemctl stop firewalld.service 

systemctl disable firewalld.service





查看临时密码

  登陆mysql，输入上面的临时密码


  grep password /var/log/mysqld.log
  mysql -p


  重置密码：

  set password = password("324erf$#E");

  use mysql;

  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '324erf$#E' WITH GRANT OPTION;
 
  flush privileges;  

 

  #hive
#activity monitor
create database hive DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
create database amon DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

 
 





vi /etc/my.cnf

大小写不敏感

lower_case_table_names = 1

service mysqld stop
service mysqld start