5,576
edits
Changes
From SME Server
Jump to navigationJump to search→MySQL
===Login as MySQL root user===
===Login as MySQL root user===
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 new MySQL database (In this example the database name is databasename. Change '''databasename''', '''username''' and '''password''' with your own choices as required)
Login as root and issue the following command:
mysql
create database '''databasename''';
grant all privileges on '''databasename'''.* to '''username''' identified by ''''password'''';
flush privileges;
exit
==PHP Related Commands==
==PHP Related Commands==
