MySQL57 SLES12 Installation

From GWAVA Technologies Training
Revision as of 20:07, 18 August 2017 by Stephanf (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Installing MySQL 5.7 on SLES 12

For documentation see [1]

Download the rpm installer [2]

Install the client and server rpms using sudo (the exact command will depend on the version downloaded)

sudo rpm -ivh mysql-community-client-5.7.19-1.sles12.x86_64.rpm
sudo rpm -ivh mysql-community-server-5.7.19-1.sles12.x86_64.rpm

Start MySQL

sudo service mysql start

Get the temporary password

sudo grep 'temporary password' /var/log/mysql/mysqld.log

Log into MySQL using the temporary password

mysql -u root -p

Change the password. Note: MySQL's validate_password plugin is installed by default. This will require that passwords contain at least one upper case letter, one lower case letter, one digit, and one special character, and that the total password length is at least 8 characters.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

Control MySQL You can start, stop, restart or determine the status of MySQL with one of the following commands.

sudo service mysql start|stop|restart|status
Personal tools
Namespaces

Variants
Actions
Home
Exchange
GroupWise
JAVA
Linux
MTK
Retain
GW Monitoring and Reporting (Redline)
GW Disaster Recovery (Reload)
GW Forensics (Reveal)
GWAVA
Secure Messaging Gateway
GW Mailbox Management (Vertigo)
Windows
Other
User Experience
Toolbox
Languages
Toolbox