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 vote142 views1 answer
Selecting duplicates
SQL
4 votes139 views1 answer
Update table from another table oracle
SQL
0 vote102 views1 answer
Sql select rows with simlar names
SQL
0 vote131 views1 answer
Sql get date from timestamp
SQL
0 vote137 views1 answer
Search column name sql
SQL
0 vote157 views1 answer
Full outer join in mariadb mysql
SQL
0 vote150 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
2 votes185 views3 answers
3 days back in sql server
SQL
0 vote141 views1 answer
Database traccar
SQL
2 votes141 views1 answer
Sqlite show table indexes
SQL