5,576
edits
Changes
Jump to navigation
Jump to search
Line 47:
Line 47: + + + + + + + + + + +
→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==