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:
C.
Read without authorization is also not so good
I think A
Indeed. 🙂
Should be A
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.
Its is A –
C- is valid but reading data is also insecure. Data is big business so you dont want to risk exposing data.
A
A