[chbot] MYSql and PHPMyAdmin

[Darran Lee]

You have a couple of options.

1: Use the 'mysqladmin' command to set the root password

  2: Use the  'mysql_secure_installation' command which will give you 
the option to set the root password, it also removes the test database etc.

3: If you can log into mysql as root on the command line you can update 
the mysql table with a new password e.g.

(sudo to root): sudo su -

(log into mysql as root): mysql

(update the root user):  alter user 'root'@'localhost' identified by 
'your new password';

(flush the changes): flush privileges;



On 1/01/2020 1:01 PM, 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.