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

1 vote210 views2 answers
Oracle list partitioned tables
SQL
0 vote204 views1 answer
Mysql group by derived column
SQL
2 votes230 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes207 views1 answer
Show index table
SQL
0 vote207 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote213 views1 answer
Sql server information_schema temp tables
SQL
2 votes233 views3 answers
Sql interview query questions
SQL
8 votes215 views3 answers
Postgres connection string
SQL
0 vote207 views1 answer
2020 new year
SQL
0 vote230 views1 answer
Alter table engine mysql
SQL