MySQL

From FIA Wiki
Jump to: navigation, search

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('password'); SET PASSWORD FOR 'root'@'hostname' = PASSWORD('password');



CREATE USER 'user'@'host' IDENTIFIED BY 'password';

grant all privileges on *.* to 'user'@'host' with grant option;

flush privileges;

give root grant permissions from remote server grant all privileges on *.* to 'root'@'hostname' with grant option;