Which additional argument makes this operation safer?

You have forgotten the root user account password. You decide to reset the password and
execute the following:
Shell> /etc/init.d/mysql stop
Shell> /etc/init.d/mysql start – skip-grant tables
Which additional argument makes this operation safer?

You have forgotten the root user account password. You decide to reset the password and
execute the following:
Shell> /etc/init.d/mysql stop
Shell> /etc/init.d/mysql start – skip-grant tables
Which additional argument makes this operation safer?

A.
–skip-networking, to prohibit access from remote locations

B.
–reset-grant-tables, to start the server with only the mysql database accessible

C.
–read-only,to set all data to read-only except for super users

D.
–old-passwords, to start Mysql to use the old password format while running without the grant
tables

Explanation:



Leave a Reply 8

Your email address will not be published. Required fields are marked *


ispanico

ispanico

Read without authorization is also not so good
I think A

wolfsrudel

wolfsrudel

Indeed. 🙂

Jose Wilson

Jose Wilson

Should be A

Steve

Steve

It is A.

https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Stop mysqld and restart it with the –skip-grant-tables option. This enables anyone to connect without a password and with all privileges. Because this is insecure, you might want to use –skip-grant-tables in conjunction with –skip-networking to prevent remote clients from connecting.

Saimoni

Saimoni

Its is A –

C- is valid but reading data is also insecure. Data is big business so you dont want to risk exposing data.