Cant login via phpMyAdmin after update to 16.2 from 16.0

Marc

Did a backup.

Ran windows installer for 16.2 and update went smoothly. Tested system, all appears to work well.

Went to Backup database since it was now updated.

I have always had to do it via http://127.0.0.1/phpmyadmin/ and manually backup.

I get the login screen and it even appears to save my login and password for root just like it always has.

But when logging in I get "Cannot log in to the MySQL server".

I re-entered password and still get same error. 

Did the update change my root password? I have no way to do backups now or access the databaae manually.

Please help! I have a 2G+ database with over 22000 items with images, over 3500 customers, etc that I really want to be able to do regular backups.

Comments

7 comments

  • Comment author
    Chris Muench

    You need to look in c:/phppos/apps/phppos/htdocs/database.php for username and password. Root password is changed randomly

    You can always do a backup via store config -> backup database -> option 1

    0
  • Comment author
    Marc

    Since day one the other options just result in a blank screen for me.

     

    0
  • Comment author
    Marc

    Also, that file doesn't seem to exist?

     

    0
  • Comment author
    Marc

    found it at c:/phppos/apps/phppos/htdocs/application/config/database.php

    0
  • Comment author
    Chris Muench

    Are you table to login now?

    0
  • Comment author
    Marc

    No, the login/pass in that file does not authenticate.  I guess I need to try and reset my root password manually but am afraid it will break the POS.  I have no idea what login the system is currently using to access the database.

    0
  • Comment author
    Chris Muench

    The username is bn_phppos and password is not including the quotes in the file. They have to work as that is how the pos connects

    0

Please sign in to leave a comment.