After I Install mysql on my droplet, As soon as I exit; from mysql I get ERROR 1045 Access denied

September 18, 2018 754 views
Ubuntu 18.04 LEMP MySQL

ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)

I followed the instructions in stage 2 of https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-ubuntu-18-04#step-2-%E2%80%94-installing-mysql

I have tries removing and purging and re-installing in case I made a mistake. If i did I made the same mistake again. What might it be?

1 Answer

Hey friend!

How are you passing the user/pass to MySQL at that stage? Do you have a /root/.my.cnf file with a password already defined?

Maybe that will give me an idea of how best to tackle it.

Jarland

  • Hey thanks for replying.
    The solution was simple but finding it has involved trolling through google for hours.

    Before changing the login for root from ‘auth-socket’ to 'mysql-native-password’ , all I had to type was 'mysql’ and I was in.

    After changing login method I need 'mysql –user=root –password=whatever mysql’

    It would be so simple if that had been included in any of the obviously relevant tutorials, I know I’m newish to this, but even so…

Have another answer? Share your knowledge.