Setting Up MySQL Server on Ubuntu
March 12th, 2010
Pretty easy first:
sudo apt-get install mysql-server
This will install the MySQL server, set a password you can remember for the root user, though not required it’s highly recommended.
mysql -u root --password=<password>
This will connect you to the database replace <password> with whatever the password you assigned to the root user.
CREATE USER logan IDENTIFIED BY PASSWORD ‘1r4gtim3′
CREATE USER <username> IDENTIFIED BY PASSWORD '<password>';