I have Mysql under Ubuntu.
I'm using the root user to connect to MySql and also to create my database, tables, etc.
# mysql -u root -p<password>
I guess this is not recommended for security reasons.
What is the normal way and what users do you recommend to administrate Mysql, to create database, access, creating, view, backups and so on?
Thanks in advance.