5,576
edits
Changes
Jump to navigation
Jump to search
Line 347:
Line 347: − + − When you want to erase a mysql database+ − + + + + + + + + + + + + + + +
→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;