How To Install MySQL on CentOS 7 Note

MYSQL

• wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
• md5sum mysql57-community-release-el7-11.noarch.rpm
• sudo rpm -ivh mysql57-community-release-el7-11.noarch.rpm
• sudo yum install mysql-server
• sudo systemctl start mysqld
• sudo systemctl status mysqld
• sudo grep 'temporary password' /var/log/mysqld.log
• echo 'KddRfttC3o,p'
• sudo mysql_secure_installation
• <enter new password>
• no
• y
• y
• y
• y
• y
• 
  
• mysqladmin -u root -p version
• mysql -u root -p
• create user 'deltaone'@'localhost' identified by 'D3lt@0n3';
• show databases;
• grant all privileges on *.* to 'deltaone'@'%' identified by 'D3lt@0n3' with grant option;
• mysql -u deltaone -p
• D3lt@0n3
• mysql -u delta one -p < Sola_30_Schema_MySQL.sql
• 
  
• RPM Failure
• rpm -qp --scripts SolaDDM-3.0.0.x86_64.rpm shows
• /usr/bin/getent group deltaone || usr/sbin/groupadd -r delta one
• /usr/bin/getent passed deltaone || /usr/sbin/useradd -r -d /usr/local/deltaone -s /bin/false deltaone

• mysql-workbench on CentOS7
• sudo yum install epee-release
• sudo yum install mysql-workbench

• 
  
• deltaone D3lt@0n3