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

62 votes474 views8 answers
Mysql add column
SQL
3 votes143 views1 answer
V$session not found in oracle
SQL
0 vote176 views1 answer
Parsing float to int in mysql
SQL
5 votes190 views1 answer
Oracle get foreign keys on table
SQL
0 vote194 views1 answer
Oracle query to find schema you are working on
SQL
2 votes177 views2 answers
Change varchar length mysql
SQL
0 vote191 views1 answer
List all indexes postgres
SQL
7 votes228 views1 answer
Alter sequence set current value oracle
SQL
0 vote212 views1 answer
Local pg_sql to heroku pg_sql
SQL
1 vote184 views3 answers
Mysql disable foreign keys check
SQL