Difference between revisions of "MySQL57 SLES12 Installation"
From GWAVA Technologies Training
(Created page with "Installing MySQL 5.7 on SLES 12 For documentation see [https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/] Download the rpm installer [https://dev.mysql.com/downloads...") |
|||
| Line 3: | Line 3: | ||
For documentation see [https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/] | For documentation see [https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/] | ||
| + | ===Download=== | ||
Download the rpm installer [https://dev.mysql.com/downloads/mysql/] | Download the rpm installer [https://dev.mysql.com/downloads/mysql/] | ||
| + | ===Install=== | ||
Install the client and server rpms using sudo (the exact command will depend on the version downloaded) | 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-client-5.7.19-1.sles12.x86_64.rpm | ||
sudo rpm -ivh mysql-community-server-5.7.19-1.sles12.x86_64.rpm | sudo rpm -ivh mysql-community-server-5.7.19-1.sles12.x86_64.rpm | ||
| − | Start MySQL | + | ===Start MySQL=== |
sudo service mysql start | sudo service mysql start | ||
| − | Get the temporary password | + | ===Get the temporary password=== |
sudo grep 'temporary password' /var/log/mysql/mysqld.log | sudo grep 'temporary password' /var/log/mysql/mysqld.log | ||
| Line 22: | Line 24: | ||
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; | ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; | ||
| − | Control MySQL | + | ===Control MySQL=== |
You can start, stop, restart or determine the status of MySQL with one of the following commands. | You can start, stop, restart or determine the status of MySQL with one of the following commands. | ||
sudo service mysql start|stop|restart|status | sudo service mysql start|stop|restart|status | ||
Latest revision as of 20:10, 18 August 2017
Installing MySQL 5.7 on SLES 12
For documentation see [1]
Contents |
[edit] Download
Download the rpm installer [2]
[edit] Install
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
[edit] Start MySQL
sudo service mysql start
[edit] 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!';
[edit] 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
