MySQL

From FIA Wiki
Revision as of 04:35, 7 June 2018 by Jason (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;