By Draecko
After a fresh Drupal droplet, what is the password of the MySQL admin? I tried mysql_ secure_ installation, but no passwords match (not the one for the shell, not the drupal password, not empty) so what is it? Or how can I reset it?
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!
On the Drupal One-Click application the root MySql password can be found in the file /root/.my.cnf This should allow you to log in with the root user without having to enter a password with mysql -u root
There seems to be no password needed mysql when you are logged in as root.
However, there is a mysql user “drupal” with a password that you can find in the Drupal default installation at /var/www/html/drupal/sites/default/settings.php around line 222 on Drupal 7.34
With trial & error this worked: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-generic
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 SMBs
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.