logging into mysql linux root uiser code example

Example 1: how to connect to the database as root user in linux

mysql -u root -p

Example 2: how to connect to the database as root user in linux

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';