I manage a droplet on DigitalOcean running Ubuntu 12.04 LTS (GNU Linux 3.2.0-24-virtual i686) and need to run some MySQL Events which requires root privileges that I don’t have on my user. In first place, I didn’t create the droplet and don’t know if the “root” account even exists. But even so, I am trying to change the root password.
I tried to follow some steps mentioned in many different places in the community, as here and here and in this tutorial too, but no results. The problem is: in every try, some command are not present on my ubuntu distro.
For example, the command returns:
root@droplet:~# sudo mysqld --skip-grant-tables &  5097 root@droplet:~# sudo: mysqld: command not found
root@droplet:~# sudo mysqladmin password 123newpass sudo: mysqladmin: command not found
root@droplet:~# sudo mysqld_safe --skip-grant-tables &  5948 root@droplet:~# sudo: mysql_safe: command not found
Just to inform, the command
"mysql" works fine. And to stop/start my MySQL and Apache I use the following command:
root@droplet:~# /opt/lampp/lampp start
How can I fix it? What should I do to give root privileges?
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!
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.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $200 of credit to try our products over 60 days!