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 vote344 views1 answer
Sqlalchemy get schema from database
SQL
-1 vote333 views1 answer
How to switch user in mysql
SQL
1 vote347 views1 answer
Mysql drop key
SQL
3 votes328 views1 answer
How to uninstall microsoft sql server
SQL
0 vote345 views1 answer
Sql show table name in result
SQL
0 vote325 views3 answers
Sql select statements
SQL
0 vote317 views1 answer
Select top 3 sql
SQL
3 votes358 views1 answer
Query less than datetime sql
SQL
0 vote352 views1 answer
Second Step in installing SQL workbench
SQL
0 vote333 views1 answer
Add unique constraint sql server multiple columns
SQL