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 vote176 views1 answer
How to check even or odd in sql
SQL
2 votes196 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote170 views1 answer
Print intervals of 15 minutes in sql query
SQL
21 votes178 views3 answers
Average sql
SQL
0 vote254 views1 answer
Play framework connection via windows sql server
SQL
0 vote197 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
2 votes172 views1 answer
Mysql how to store lat,lng
SQL
0 vote167 views1 answer
What alter does in db
SQL
0 vote186 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote184 views1 answer
Sql query to get contact form 7 fields
SQL