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 vote354 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
2 votes397 views1 answer
Postgresql group by month and year
SQL
0 vote355 views4 answers
How to connect form to database
SQL
0 vote349 views1 answer
Drop all data from tables
SQL
0 vote340 views1 answer
Get first monday of month sql
SQL
4 votes357 views3 answers
Order by value mysql
SQL
9 votes332 views2 answers
Default number in sql
SQL
13 votes336 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote383 views1 answer
Is not numeric sql
SQL
0 vote360 views3 answers
Query string not ending with with vowels
SQL