Create mysql user

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;

Create mysql user

CREATE USER 'newuser'@'%' IDENTIFIED BY 'user_password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%';
SHOW GRANTS FOR 'newuser'@'%';
FLUSH PRIVILEGES;

Similar codes

1 vote191 views1 answer
Round one decimal place mysql
SQL
0 vote160 views1 answer
Get first name and last name from full name string in SQL
SQL
-1 vote177 views3 answers
How to restart mysql in linux
SQL
0 vote214 views1 answer
Sql pivot table
SQL
0 vote168 views1 answer
Create a view in sqlite
SQL
0 vote161 views1 answer
Mysql remove tabs from string
SQL
0 vote180 views2 answers
Athena drop partition
SQL
19 votes168 views2 answers
Mysql tinyint max value
SQL
2 votes168 views2 answers
Postgres trigger insert into another table
SQL
3 votes160 views2 answers
Oracle grants
SQL