MySQL Tutorial

1:

Which table in the mysql database is checked to see whether a user may connect?

  1. tables_priv

  2. db

  3. columns_priv

  4. user

2:

Which table is checked first to see whether a user may execute any particular query?

  1. user

  2. host

  3. db

  4. tables_priv

3:

If MySQL finds multiple rows in the user table with the same username, which row is used for authentication?

  1. The row with the most specific host value.

  2. The row with the most general host value.

  3. Any row that has the right password.

  4. None of the above.

4:

Which of the following privileges should you probably not grant to users?

  1. FILE

  2. PROCESS

  3. WITH GRANT OPTION

  4. All of the above

5:

Which user should mysqld run as?

  1. A low-privilege user

  2. Root

  3. Either a) or b)

  4. Neither a) nor b)

Related

Категории