[chbot] MYSql and PHPMyAdmin

[Steve West]

Hi

Hope this helps..

https://stackoverflow.com/questions/10895163/how-to-find-out-the-mysql-root-password

Steve


On 2020-01-01 13:01, Marshland Engineering wrote:
> I know there are a lot of linux chaps on this group and hopefully 
> someone can
> help. I had a raspberry Pi 2 running a local SQL database for in house
> operation. It crashed some 2 years ago and now I have some time to get 
> it back
> up and running again.
> 
> The problem is with passwords. I did a 'normal' install with no issues 
> and I
> can login to PHPMyAdmin with the password I created and user 
> PHPMyAdmin. This,
> however does not give me root access. It appears that the install 
> program
> installed the system with user name 'root' and no password. Because 
> there is
> no root password, I cannot login and change it. As such I cannot create 
> new
> databases or do any further changes.
> 
> I've been round in circles for around 2 days now with many conflicting
> options, non successful, so if someone is happy to do a phone support 
> call,
> I'll send the beers asap.
> 
> Cheers Wallace 03 3237449
> 
> 
> _______________________________________________
> Chchrobotics mailing list Chchrobotics at lists.ourshack.com
> https://lists.ourshack.com/mailman/listinfo/chchrobotics
> Mail Archives: http://lists.ourshack.com/pipermail/chchrobotics/
> Meetings usually 3rd Monday each month. See http://kiwibots.org for
> venue, directions and dates.
> When replying, please edit your Subject line to reflect new subjects.