Difference between revisions of "Mysql 5.7"

From VoIPmonitor.org
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
==install mysql==
+
==install mysql on debian/ubuntu==
  
 
1)Go to the download page for the MySQL APT repository at [http://dev.mysql.com/downloads/repo/apt/ mysql APT repo]
 
1)Go to the download page for the MySQL APT repository at [http://dev.mysql.com/downloads/repo/apt/ mysql APT repo]
Line 6: Line 6:
 
  mkdir /usr/src/mysql-repo
 
  mkdir /usr/src/mysql-repo
 
  cd /usr/src/mysql-repo
 
  cd /usr/src/mysql-repo
  wget https://dev.mysql.com/get/mysql-apt-config_0.8.8-1_all.deb
+
  wget https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb
 
 
  
 
2)unpack and install the downloaded package  
 
2)unpack and install the downloaded package  
  dpkg -i mysql-apt-config_0.8.8-1_all.deb
+
  dpkg -i mysql-apt-config_0.8.13-1_all.deb
  
[[File:Mysql57_repo_deb_config.jpeg]]
+
During installation ensure that (Mysql server & cluster Currently selected:mysql-5.7) and Tools and Connectors are enabled.
  
  
Line 25: Line 24:
 
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
  mysql CLI> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
+
  mysql CLI> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'somePASShere';
  
  

Latest revision as of 12:12, 30 July 2019

install mysql on debian/ubuntu

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.13-1_all.deb

2)unpack and install the downloaded package

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

During installation ensure that (Mysql server & cluster Currently selected:mysql-5.7) and Tools and Connectors are enabled.


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 'somePASShere';


SOURCEs: quick guide for apt repo on mysql community

How to change authentication method for mysql's user