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 vote235 views1 answer
Pgadmin check database
SQL
0 vote188 views1 answer
Postgresql create table with boolean column
SQL
0 vote210 views1 answer
Nvl2 syntax
SQL
0 vote203 views1 answer
Oarcale list objects
SQL
1 vote184 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote194 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote150 views1 answer
Sql table to store status
SQL
8 votes207 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote208 views1 answer
How to get data from 2 database
SQL
0 vote212 views2 answers
Homebrew nysql launch
SQL