Question

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

Posted September 18, 2018 1.2k views
MySQLLEMPUbuntu 18.04

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?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
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…

Submit an Answer