MYSQL SETUP

From ElectroDragon Wiki

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