Introduction {#introduction.sectionedit1}

Parrot includes several SQL engines, but when they are pre-installed, the default password is not configured and the access to its root user is denied.

This page will help you in setting up a new password for the root user of Mysql/Mariadb and Postgresql

This topic is also available in our documentation portal

Reconfigure Mysql/Mariadb Password {#reconfigure-mysqlmariadb-password.sectionedit2}

1. Stop the MySQL service. 

  service mysql stop

2. Start MySQL without password and permission checks. 

 mysqld_safe --skip-grant-tables &

3. Press [ENTER] again if your output is halted.

4. Connect to MySQL. 

  mysql -u root mysql

5. Run following commands to set a new password for root user. Substitute NEW_PASSWORD with your new password. 

  UPDATE user SET password=PASSWORD('my new p4ssw0rd') WHERE user='root';
  FLUSH PRIVILEGES;

6. Restart the MySQL service. 

  service mysql restart

Reconfigure Postgresql Password {#reconfigure-postgresql-password.sectionedit3}

1. Open psql from the postgres user. 

  sudo -u postgres psql

2. Change password of the postgres user (or any other database user) 

  \password postgres

or 

  \password myuser

3. Quit pgsql 

  \q