MySQL Access Control and Security


  1. The number of languages that have interfaces to bind to the C API of MySQL among these is ______________.
    Perl, PHP, Python











  1. 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.


  1. The context in which the privilege ‘CREATE TABLESPACE’ applies is ______________.











  1. 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.



  1. A password applies globally to an account.











  1. 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.


  1. The mysql client writes a record of executed statements to a history file on Unix.











  1. 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.



  1. MySQL uses security based on ACL which stands for ______________.











  1. 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.