2,411
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 64:
Line 64: + Line 88:
Line 89: + + − ==== Remove a database and user ====+ − Using roundcube as an example database and user, − Get access to the SME Server shell and issue the following commands to login to the MySQL server: − mysql+ + − show databases; #list databases+ − − use mysql;+ − select user,host from user; #list users − DELETE FROM user WHERE User = 'roundcube'; − FLUSH PRIVILEGES; + + − {{Tip box|+ + − <code>mysql_setpermission</code> is a command line menu driven utility that can assist in MySQL administration.}}+ − More information about user managament can be found in the [http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html MySQL User Account Management section] of the [http://dev.mysql.com/doc/refman/4.1/en/ MySQL manual].+
Reformatted/-ordered database and user administration section
===Administration===
===Administration===
Information about user managament can be found in the [http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html MySQL User Account Management section] of the [http://dev.mysql.com/doc/refman/4.1/en/ MySQL manual], which holds a lot of useful information, a small section is listed here for convenience.
==== Create a new database ====
==== Create a new database ====
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.
====Listing available databases ====
To view a list of available databases on the system you can issue the following command while logged in in MySQL:
show databases;
==== Remove a database ====
Get access to the SME Server shell and MySQL and issue the following command:
drop database databasename;
drop database roundcube;
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:
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.}}
<noinclude>[[Category:Howto|MySQL]]</noinclude>
<noinclude>[[Category:Howto|MySQL]]</noinclude>
