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 vote280 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote282 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote286 views1 answer
View acl table oracle
SQL
3 votes320 views5 answers
Duplicate table sql
SQL
0 vote294 views1 answer
On sql table data exists
SQL
0 vote325 views1 answer
Delete a temporary table mysql
SQL
0 vote312 views1 answer
No query unable to fetch row sqlite
SQL
16 votes289 views4 answers
Mysql import from sql file
SQL
-1 vote300 views1 answer
Sql oracle take only last results
SQL
0 vote320 views1 answer
Mysql get hour from datetime
SQL