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

15 votes279 views3 answers
Postgresql change column type
SQL
0 vote266 views2 answers
Identity column in sql server
SQL
0 vote270 views1 answer
Pgsql is not permitted to log in
SQL
6 votes264 views4 answers
Remove spaces sql server
SQL
1 vote266 views1 answer
Postgresql escape single quote
SQL
1 vote296 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
4 votes264 views2 answers
Bulk kill mysql processlist
SQL
1 vote259 views1 answer
Oracle create index if not exists
SQL
1 vote268 views1 answer
Show structure of table in sql
SQL
0 vote259 views1 answer
Find all tables where column name exists oracle
SQL