1. Home
  2. Blogs
  3. stephenwenceslao's blog
  4. MYSQL add user remote access

MYSQL add user remote access

Submitted by stephenwenceslao on Thu, 07/13/2017 - 10:26

Switch user to root:

$ su -u root -p

Run codes to add user and grant all privileges

$ CREATE USER 'user'@'localhost' IDENTIFIED BY 'pass';
$ CREATE USER 'user'@'%' IDENTIFIED BY 'pass';
$ GRANT ALL ON *.* TO 'user'@'localhost';
$ GRANT ALL ON *.* TO 'user'@'%';