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
Wordpress Mysql Connection to new Droplet with Ubuntu 16 Question Question
Unable to create user in SQL Question Question

Question

SQL database passowrd

Posted February 12, 2017 3k views
MySQLWordPressUbuntu 16.04

I used this tutorial to install https://www.digitalocean.com/community/tutorials/how-to-use-the-wordpress-one-click-install-on-digitalocean wordpress and i have done everything until the login and passowrds
when i try to type this command mysql -uroot -p
it keeps asking about my sql password. i don’t know what it is. i have tried to type my sudo user password and it keeps telling this ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES). also when i try go to /root/.digitaloceanpassword to get my password it keep telling me this /root/.digitaloceanpassword: Permission denied.
So is there anything I can do?

Add a comment
ka7ky
By:
ka7ky

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
Wordpress Mysql Connection to new Droplet with Ubuntu 16 Question Question
Unable to create user in SQL 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
3 answers
ka7ky February 12, 2017

No it keeps telling me Permission denied
That’s why i can’t get mysql password

Reply Report
  • jtittle1 February 12, 2017

    @ka7ky

    Are you logged in to the CLI as root? If not, you’ll need to be as that file is owned by the root user, thus users with less permissions than root, such as normal users with the ability to SSH in to the Droplet, or sudo users not prefixing commands with sudo won’t be able to access the file.

    As root, you should be able to do:

    ls -al /root/.digitalocean_password

    and confirm that it’s owned by root and then, as root, run:

    cat /root/.digitalocean_password

    As a sudo user, you should be able to run

    sudo cat /root/.digitalocean_password
    Reply Report
jtittle1 February 12, 2017

@ka7ky

If you run the command below, will that allow you to view the contents of the file?

cat /root/.digitalocean_password

I just ran the WordPress 4.7 one-click installer and when running the above, was able to get the info needed to login.

Reply Report
ka7ky February 13, 2017

Thank you SO much. I have been trying since last wednesday a lot of different tutorials but you really helped me SIR. Thank you

Reply Report

Related

Looking for something else?

Ask a new question Search for more help