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;

Similar codes

21 votes132 views3 answers
Sql average
SQL
0 vote134 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote136 views4 answers
How to connect form to database
SQL
13 votes127 views6 answers
Restart postgresql
SQL
0 vote154 views1 answer
Get created time of database psql 8
SQL
1 vote129 views1 answer
Mysql show table character set
SQL
0 vote134 views1 answer
Sql select upcoming birthdays
SQL
5 votes142 views2 answers
Oracle show procedures
SQL
1 vote151 views3 answers
Connection string mysql
SQL
0 vote122 views1 answer
How to get initials in sql
SQL