First login in as the root user using sudo command
sudo mysql -u root -p passwordCREATE USER 'newuser'@'%' IDENTIFIED BY 'password';GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%' WITH GRANT OPTION;orGRANT ALL PRIVILEGES ON DatabaseName.* TO 'newuser
'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
now everything is completed, logout from the sudo user with Exit or Ctrl + Z. Then try withmysql -u newuser -p password
No comments:
Post a Comment