User Tools

Site Tools


change_mysql_postgresql_password

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

change_mysql_postgresql_password [2018/09/28 15:12] (current)
admin created
Line 1: Line 1:
 +**BlackWeb** 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
 +
 +
 +====== Reconfigure Mysql/​Mariadb Password ======
 +
 +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
 +
 +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
 +
  
change_mysql_postgresql_password.txt ยท Last modified: 2018/09/28 15:12 by admin

(C) BlackWeb Security 2017 - 2019