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 vote232 views1 answer
Sql server datetime to string
SQL
13 votes224 views6 answers
Current date sql
SQL
1 vote232 views1 answer
List all triggers in SQL Server
SQL
2 votes228 views2 answers
Mysql show table column comments sql
SQL
20 votes258 views4 answers
Sql count if
SQL
1 vote207 views1 answer
Select random sample sql
SQL
1 vote227 views1 answer
Select count distinct multiple columns sql server
SQL
1 vote231 views2 answers
Postgres cast as decimal
SQL
2 votes226 views1 answer
Possgress drop if exists table
SQL
0 vote218 views1 answer
Insert thai language sql server
SQL