-- DEFAULT: Username:root , Password: – (none) mysql> SET PASSWORD FOR root@localhost=PASSWORD('mypassword'); mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'mypassword' WITH GRANT OPTION;