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 vote252 views3 answers
Mysql keyword search
SQL
0 vote265 views2 answers
Mysql decimal remove trailing zeros
SQL
4 votes206 views1 answer
And or sql order of operations
SQL
7 votes271 views3 answers
Sql server reset auto increment
SQL
0 vote264 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote239 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote254 views1 answer
Mysql disable query caching
SQL
7 votes253 views1 answer
Minecraft forge server host
SQL
1 vote242 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
3 votes326 views1 answer
Sql select second max
SQL