I have a rackspace server and I'm having problems with configuration. I need to lock it down and throw away the key, because right now I can only login with root to do anything substantial. I also am set up on MySQL with my root username and password and would like to change this.
I have created a new user and given him a home directory for /var/www so I can administer my website through FTP. However, I can't run any sudo commands as that user (it returns an error, and tells me the action would be logged)
I want to create a catch-all account that starts in a typical home directory like /Users/justin but with sudo privileges to escalate to install and update software packages. I also want to fix MySQL so it has its very own login/pass (because right now it's root/rootpass)
This is on Rackspace so I can only access the server through SSH. OS is Ubuntu 11.10. Thanks for your time.