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 vote194 views1 answer
Get duplicate entry sql
SQL
1 vote224 views1 answer
Floor function in sql oracle
SQL
3 votes223 views1 answer
Get current month last date in sql server
SQL
0 vote208 views1 answer
Postgres data location
SQL
1 vote228 views1 answer
STOP message of how many rows affected sql
SQL
0 vote212 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote219 views1 answer
Oracle NLS_CHARACTERSET
SQL
3 votes202 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote198 views2 answers
Android sqlite query join
SQL
5 votes196 views1 answer
Migrate sql table another database
SQL