search

ByteInternet / hypernode-docker

Fast and easy Docker for Magento development
https://community.hypernode.io/hypernode-docker
35 stars 8 forks source link

need to change password database user (request) #61

Closed SolsWebdesign closed 2 years ago

SolsWebdesign commented 2 years ago

Hello, I have various containers for various magento shops and it works fine. However, the db app password is always different and for this new project I need to change the app password. I have tried the following (form https://support.hypernode.com/en/hypernode/mysql/how-to-use-mysql-on-hypernode): (command line ssh) mysql --host=your.hypernode.here --user=app --password=NewPassword but I get ERROR 1045 (28000): Access denied for user 'app'@'127.0.0.1' (using password: YES)

I have also tried to use root password with mysql -u root -p to use lines like: ALTER USER 'app'@'localhost' IDENTIFIED BY ... etc or SET PASSWORD FOR 'app'@'localhost' .. etc But none of these work. I use the command echo "create database database-name" | mysql to create my initial database. Is there a possibility to define user and password with this?

SolsWebdesign commented 2 years ago

Found a work around: enter phpmyadmin using root and password, go to user accounts and change it there. Closing this issue.