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

0 vote338 views1 answer
Mysql disable query caching
SQL
0 vote330 views1 answer
Mysql order by where condition sub query
SQL
58 votes643 views6 answers
Create new user in postgres
SQL
3 votes316 views2 answers
Oracle sql truncate table
SQL
1 vote330 views1 answer
Oracle check table space
SQL
0 vote346 views1 answer
Call function sql oracle with output put line
SQL
0 vote343 views1 answer
To_date sql
SQL
1 vote365 views1 answer
Mysql print variable
SQL
1 vote336 views1 answer
Set autoincrement to 0
SQL
2 votes333 views1 answer
Sql update alias
SQL