CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost'; FLUSH PRIVILEGES;

mysql add user with all privileges

# First Login mysql shell.. sudo mysql -u root -p CREATE USER 'username'@'localhost' IDENTIFIED BY 'P4ssW0rd'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'; FLUSH PRIVILEGES;

mysql add user with all privileges

Similar Code Examples