Mysql 5.7: Difference between revisions

From VoIPmonitor.org
Jump to navigation Jump to search
(Created page with "==install mysql== 1)Go to the download page for the MySQL APT repository at [http://dev.mysql.com/downloads/repo/apt/ mysql APT repo] Select and download the release package ...")
 
No edit summary
Line 22: Line 22:
  apt-get install mysql-server
  apt-get install mysql-server
If you entered password during this step you can skip following
If you entered password during this step you can skip following
4b)change mysql authentication method from socket in case non password entered during installation
4b)change mysql authentication method from socket in case non password entered during installation
  bash> mysql
  bash> mysql
Line 27: Line 28:




https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/
SOURCEs:
[https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ quick guide for apt repo on mysql community ]
 
[https://www.percona.com/blog/2016/03/16/change-user-password-in-mysql-5-7-with-plugin-auth_socket/ How to change authentication method for mysql's user]

Revision as of 15:45, 6 October 2017

install mysql

1)Go to the download page for the MySQL APT repository at mysql APT repo Select and download the release package for your Linux distribution. example:

mkdir /usr/src/mysql-repo
cd /usr/src/mysql-repo
wget https://dev.mysql.com/get/mysql-apt-config_0.8.8-1_all.deb


2)unpack and install the downloaded package

dpkg -i mysql-apt-config_0.8.8-1_all.deb

File:Mysql57 repo deb config


3)Update packaging system with new repository added in previous step

apt-get update


4)Install new mysql server

apt-get install mysql-server

If you entered password during this step you can skip following

4b)change mysql authentication method from socket in case non password entered during installation

bash> mysql
mysql CLI> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ;


SOURCEs: quick guide for apt repo on mysql community

How to change authentication method for mysql's user