Chao at 16:31, 7 May 2020

2020-05-07T16:31:05Z

New page

=== For remote access MYSQL8 ===
* CREATE USER 'root'@'%' IDENTIFIED BY '123';
* GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
* flush privileges;
=== Set remote login for Adminer ===
* ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

=== For remote access MYSQL5 ===
* nano /etc/mysql/my.cnf
* comment bind-address = 127.0.0.1
* Check netstat -an|grep 3306

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD' with grant option;
* . for all databases
* USERNAME can change to root
* IP can use %, or specific IP address
* PASSWORD need to be changed
* example
{| class="wikitable sortable"
|-
! Header text !! Header text !! Header text
|-
| Example || Example || Example
|-
| Example || GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'new-password' with grant option; || Example
|-
| Example || GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; || Example
|}

flush privileges;

[[category: MYSQL]]

MYSQL SETUP - Revision history

Chao at 16:31, 7 May 2020