MySQL Access Control and Security
- The number of languages that have interfaces to bind to the C API of MySQL among these is ______________.
Perl, PHP, Python
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
The client library provides the means through which the MySQL bindings for other languages can be built on top of the C API. This type of interface exists for Perl, PHP, Python and others.
- The context in which the privilege ‘CREATE TABLESPACE’ applies is ______________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
The column name associated with the privilege ‘CREATE TABLESPACE’ is ‘Create_tablespace_priv’. The context in which this privilege is being used is the server administration.
- A password applies globally to an account.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
In the MySQL privilege system, a password applies globally to an account. A password cannot be explicitly associated with a specific object such as a database, table, or routine.
- The mysql client writes a record of executed statements to a history file on Unix.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
On Unix the mysql client writes a record of the executed statements to a history file. By default this file is named as ‘.mysql_history’. It is created in the home directory.
- MySQL uses security based on ACL which stands for ______________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
MySQL uses security based on Access Control Lists (ACLs) for all connections, queries and other operations that users can attempt to perform. There is support for SSL encrypted connections.