MySQL is installed on a Linux server and has the following configuration:<br /> <img src="https://nimg.ppkao.com/2018-08/tangxueping/2018080117282355979.jpg?sign=26b7e57ca2088c3a30ed6f4b9b1e735a&t=62d1173b" /><br /> What is the purpose of changing ownership of datadir to the ‘mysql’ user?（）

A、MySQL requires correct file ownership while remaining secure

B、MySQL needs to be run as the root user, but file cannot be owned by it

C、MySQL cannot be run as the root user

更多“ MySQL is installed on a Linux server and has the following configuration:<br /> <img src="https://nimg.ppkao.com/2018-08/tangxueping/2018080117282355979.jpg?sign=26b7e57ca2088c3a30ed6f4b9b1e735a&t=62d1173b" /><br /> What is the purpose of changing ownership of datadir to the ‘mysql’ user?（）”相关的问题

第1题

[单选题] You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: \＞ mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?（）

A、Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file B、An error message is issued because – install is not a valid option for mysqld C、A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf D、Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file

点击查看答案

第2题

[单选题] You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Which statement is true about this scenario?（）

A、The RPM installation script sets a default password of password for new installations B、The local root user must log in with a blank password initially: mysql –u root –p C、New security measures mean that the mysql_secure_installation script must be run first on all new installations D、The mysql_install_bd post-installation script used – random-password

点击查看答案

第3题

[单选题] You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?（）

A、All system users have access to the MySQL server via—login path local B、login-path can be used only for MySQL servers running on a local machine C、login-path allows you to provide login credentials without passing clear text passwords on the command line D、When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later

点击查看答案

第4题

[单选题] A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）

A、It deletes all binary log files, except 'mysql-in.010' B、It deletes all binary log files up to and including 'mysql-bin.010' C、It deletes all binary log files before 'mysql-bin.010' D、It deletes all binary log files after 'mysql-bin.010'

点击查看答案

第5题

[单选题] An administrator attempts to install the latest security patches for an older server. When the administrator runs the patch installer, the install fails. The administrator tries again, and the installer fails again. Which of the following is the MOST likely reason for this?（）

A、The administrator improperly configured the virtual memory settings on the server. B、The administrator is using incorrect patch switches for the install. C、The administrator is trying to install security patches for software that is not installed. D、The administrator is trying to install patches that require hard drive encryption on the server.

点击查看答案

第6题

[多选题] What are three actions performed by the mysql_secure_installation tool?（）

A、It prompts you to set the root user account password B、It checks whether file permissions are appropriate within datadir C、It asks to remove the test database, which is generated at installation time D、It can delete any anonymous accounts E、It verifies that all users are configuration with the longer password hash

点击查看答案

第7题

[多选题] A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）

A、Disabling connections from named pipes or socket files (depending on the operating system of the server) B、Enabling and using SSL for connections to the Mysql database C、Installing Mysql on the application server, and running the database and application on the same server D、Starting the server with – bind- address=0.0.0.0 specified E、Running the server with – skip-networking specified F、Limiting logins to originate from the application server or the server's subnet'

点击查看答案

第8题

[单选题] 关于mysql_db_query与mysql_query说法正确的是：（）

A、mysql_db_query与mysql_query在执行sql语句后的返回值是一样的，成功返回资源号，失败返回FALSE B、不能用mysql_query函数临时在另一个数据库上执行sql语句，而mysql_db_query可以 C、mysql_db_query不会切换回先前连接到的数据库 D、mysql_query在功能上等于mysql_select_db（）+mysql_db_query（）

点击查看答案

第9题

[] 如果想取得mysql数据库系统的运行状态，应该用什么函数？（）

A、A.mysql_ping B、B.mysql_status C、C.mysql_stat D、D.mysql_info

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服