Problem installing mysql server on 18.04

[Jim]

On 07/02/2018 03:02 PM, Colin Law wrote:
> On 1 July 2018 at 12:12, Colin Law <clanlaw at gmail.com> wrote:
> 
>> I have installed mysql-server and then run
>> sudo mysql_secure_installation
>> which prompts me to enter a root password.
>>
>> I then run
>> mysql -u root -p
>> and get prompted for the pasword but then I get
>> Access denied for user 'root'@'localhost'
>>
> 
> Has anyone any suggestions on this or how to debug it?
> mysql_secure_connection says it is setting the root password but then I
> cannot connect.
> 
> Colin
> 

Have you tried any of the suggestions in this Stackoverflow thread?

https://stackoverflow.com/questions/41645309/mysql-error-access-denied-for-user-rootlocalhost

Also this manual page talks about this problem:

https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html

A number years ago  I had and solved this problem, unfortunately I can't 
remember what I did to fix it.  I must have googled or read something 
that helped me fix it. Sorry I can't be more help.

regards,  Jim