Creating a database as you've described is a lot of work, and as others have mentioned their might be better alternatives than a relational database. (or at least the typical structure for a ...

sudo mysql -u root -p Once at the MySQL console, create the new user with the command: create user 'dbadmin'@'%' identified by 'PASSWORD'; where PASSWORD is a strong and unique password.