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 1k 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?

Add a comment
johncorley5
By:
johncorley5
Add a comment

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
jarland September 18, 2018

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

Reply Report
  • johncorley5 September 18, 2018

    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…

    Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help