Databases Reference
In-Depth Information
Checking the database privileges
Clicking on the
Check Privileges
icon or link displays all of the privileges on a
specific database. A user's global privilege might be shown here, as it gives him
or her access to this database as well. We can also see the privileges specific to this
database. An
Edit Privileges
link takes us to another page, which is used to edit the
user's privileges.
We notice that this panel also contains the
Add a new User
link. Clicking on this
link is a convenient way of creating a user that has privileges to the database we are
currently examining. Indeed, after entering the user-creation panel from this link,
a fourth choice in the database creation or privileges granting dialog is shown and
selected by default, as shown in the following screenshot:
Dropping selected databases
To drop one or more databases, we go to
Server
view and click on the
Databases
menu tab; put check marks next to the names of the databases to be dropped; and
then click on the
Drop
link next to
With selected
. We then get a confirmation screen.
Two of the databases (
mysql
and the virtual
information_schema
) cannot be
selected; the first one to avoid making a big mistake and deleting all of our accounts,
and the second one cannot be selected as this is not a real database.
This is an operation that should not be taken lightly, and it
might be prudent to first export the whole database as a backup.
Search WWH ::
Custom Search