Using the root MySQL password from /root/.digitalocean_password I am not able to log in using root. Using DBeaver, ssh connection and the tunnel connect is working correctly. I get the error “Access denied for user ‘root’@‘localhost’”
Is there something else I need to do?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi there @geoffAU,
What is the exact command that you are using? Note that you need to specify the -p flag so that you could get prompted for a password:
- mysql -u root -p
Another thing that you could do is add your MySQL password to your ~/.my.cnf file so that you don’t have to enter the password each time as described here.
To do so follow these steps here:
- Create the file:
- touch ~/.my.cnf
- Give it secure permissions:
- chmod 600 ~/.my.cnf
- Using your favorite text editor edit the file:
- nano ~/.my.cnf
- And add the following configuration
[client]
user=root
password=YOUR_MYSQL_PASSWORD
- Save and exit
Then you will be able to login to MySQL by just running mysql.
Regards, Bobby
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.