To login as MySQL root user, simply type 'mysql' at the SME Server shell, this will log you in with root privileges.
To login as MySQL root user, simply type 'mysql' at the SME Server shell, this will log you in with root privileges.
−
===Create a Database and a User===
+
===Create a Database and its User===
Create a new MySQL database (In this example the database name is databasename. Change '''databasename''', '''username''' and '''password''' with your own choices as required)
Create a new MySQL database (In this example the database name is databasename. Change '''databasename''', '''username''' and '''password''' with your own choices as required)