Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Using the LEMP Marketplace image, what's the step by step way of allowing MySQL access from remote connections? Question Question
Access to mysql Question Question

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.6k 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

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Using the LEMP Marketplace image, what's the step by step way of allowing MySQL access from remote connections? Question Question
Access to mysql Question Question

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.

×
Submit an Answer
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

Related

Looking for something else?

Ask a new question Search for more help