Difference between revisions of "Mysql 5.7"
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 ...") |
|||
| (7 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. | + | 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. | + | 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. | |
| Line 22: | Line 21: | ||
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 | ||
| − | 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'; |
| + | |||
| + | SOURCEs: | ||
| + | [https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ quick guide for apt repo on mysql community ] | ||
| − | https:// | + | [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] |
Latest revision as of 13: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';