Changes

From SME Server
Jump to navigationJump to search
279 bytes added ,  01:32, 6 April 2008
→‎Administration: Remove a database and user
Line 88: Line 88:     
In the above line you will have to fill in the user and the host and/or domain from which you will allow the user access to the SME Server MySQL server (don't forget the single quotes). More information can be found in the MySQL Server Manual at the MySQL website linked here.
 
In the above line you will have to fill in the user and the host and/or domain from which you will allow the user access to the SME Server MySQL server (don't forget the single quotes). More information can be found in the MySQL Server Manual at the MySQL website linked here.
 +
 +
 +
==== Remove a database and user ====
 +
Using roundcube as an example database and user,
 +
 +
mysql
 +
 +
show databases;  #list databases
 +
drop database roundcube;
 +
 +
use mysql;
 +
select user,host from user;  #list users
 +
DELETE FROM user WHERE User = 'roundcube';
 +
FLUSH PRIVILEGES;
 +
    
{{Tip box|
 
{{Tip box|

Navigation menu