Difference between revisions of "Mysql 5.7"

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 ...")
 
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 16: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