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