Just installed mysql on Ubuntu -
sudo apt-get install mysql-server sudo apt-get install mysql-client
As part of the installation process, I provided a password for the root user.
I can now log in with
mysql -u root -p
But I'd love some other user besides
root to own the mysql administration. I'm coming over from the world of Postgres and have never used MySQL before, so I'm wondering how I could change this user.
This is based off a recommendation from the Wordpress installation guide:
It is a safer practice to choose a so-called "mortal" account as your mysql admin, so that you are not entering the command "mysql" as the root user on your system. (Any time you can avoid doing work as root you decrease your chance of being exploited.)