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 vote399 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote355 views2 answers
Sql trigger difference between for and after
SQL
0 vote362 views1 answer
Initcap in sql
SQL
5 votes364 views1 answer
How to use rank function in sql
SQL
0 vote378 views1 answer
Typeorm raw sql
SQL
2 votes368 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
1 vote374 views1 answer
Sql in array query
SQL
8 votes315 views1 answer
Similarities between ddl and dml
SQL
1 vote368 views1 answer
Retrieve meaning
SQL
10 votes351 views2 answers
Reset mysql root password mac
SQL