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

2 votes129 views5 answers
Tablespace ORACLE
SQL
0 vote119 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote141 views1 answer
Postgresql linux password
SQL
1 vote127 views3 answers
Union in sql
SQL
0 vote131 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
2 votes121 views2 answers
How to create an empty table from an existing table
SQL
0 vote125 views1 answer
Sql get count without group by
SQL
0 vote260 views2 answers
Mysql insert rows to another database
SQL
0 vote131 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote149 views1 answer
How convert into in in sql query
SQL