5,576
edits
Changes
From SME Server
Jump to navigationJump to search→Delete a database
exit
exit
===Delete a database===
===Remove a database===
Get access to the SME Server shell and MySQL and issue the following command:
drop database database-name;
drop database databasename;
Replace databasename with the name of the database.
===Remove a user===
Get access to the SME Server shell and MySQL and issue the following command:
USE mysql;
DELETE FROM user WHERE user = 'username';
FLUSH PRIVILEGES;
Replace username with the username you wish to delete.
{{Tip box|mysql_setpermission is a command line menu driven utility that can assist in MySQL administration.}}
===Other useful MySQL commands:===
===Other useful MySQL commands:===
show databases;
show databases;
