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 vote166 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote137 views1 answer
Sql menampilkan data tabel
SQL
-1 vote144 views1 answer
Mysql #1064 error
SQL
1 vote241 views1 answer
Aqua Data studio postgresql ssl
SQL
13 votes149 views2 answers
Get tables in database sql
SQL
0 vote153 views1 answer
Mysql workbench procedure
SQL
0 vote146 views1 answer
Write a query to peint the pattern P(20)
SQL
1 vote146 views1 answer
Restart identity postgresql
SQL
7 votes148 views2 answers
Html to react converter
SQL
0 vote134 views1 answer
Sql cross apply vs join
SQL