1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。
访问量(1038242) 积分(1523) 等级(核心会员) 排名(6)
SELECT * FROM T1 INTO OUTFILE '/tmp/T1.csv'; ERROR 1227 (42000): Access denied; you need (at least one of) the FILE privilege(s) for this operation 使用如下方法绕过: mysql -h 主机 -u 用户 -p密码 -P端口 -D库 -Bse "select * from T1;" > /tmp/T1.csv
2024-05-11 13:41 451 0
mysql 5.7.33升级至mysql 5.7.44后无法启动 /var/log/mysql/mysqld.log日志报错： [ERROR] unknown variable 'myisam_repair_threads=1' [ERROR] Aborting 根本原因: https://docs.oracle.com/cd/E17952_01/mysql-5.7-relnotes-en/news-5-7-38.html mysql 5.7.38后已经废弃了myisam_repair_threads这个参数，在/etc/mysql.cnf文件中注释掉该...
2024-04-12 15:11 495 0
1.windows下mysql 8数据库启动报错： Windows服务无法启动 服务没有报告任何错误 解决方案如下： 2.解决方案，发现C:/xxxxx/mysql-xxx/data文件夹内容为空，判定为未进行初始化。 1.清空data目录 2.sc delete mysql 3.mysqld --initialize --console 4.mysqld --install 5.net start mysql 6.mysql -uroot -p<temp_password> 7.进...
2023-09-13 13:46 720 0
1.mysql导出数据抛出错误: mysql> select * INTO OUTFILE '/tmp/t2.txt' from testdb.t2; ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 查看官方文档，secure_file_priv参数用于限制LOAD DATA, SELECT …OUTFILE, LOAD_FILE()传到哪个指定目录。 secure_fil...
2022-12-03 20:46 1139 0
1.Centos 7.9自带python2.7 版本，升级为3.6版本 which yum => 找到yum路径 vi /usr/bin/yum 修改成： #!/usr/bin/python 修改为系统的python path #!/usr/bin/python2.7 系统自带yum是2.7的测试yum install wget 2.同样修改/usr/libexec/urlgrabber-ext-down为 #!/usr/bin/python2.7 [root@db01 ~]# vi /usr/libexec/urlgrabber-ext-d...
2021-12-15 08:21 999 0
Which two are considered good security practices when using passwords? (Choose two.) 使用密码时，哪两种被认为是良好的安全性做法？（选择两个。） A. Use one-way encryption for storage of passwords. 使用单向加密来存储密码。 B. Store passwords external to the database. 将密码存储在数据库外部 C. Choose short passwords to sa...
2021-12-14 22:00 1208 0
What are three methods to reduce MySQL server exposure to remote connections? A. Setting —skip-networking when remote connections are not required B. Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications C. Setting specific GRANT privilege to limit remote au
2021-12-14 21:58 1333 0
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files? (Choose two.) A. Execute the PURGE BINARY LOGS NOT USED command. B. Edit the .index file to remove the files y
2021-12-14 21:55 1147 0
Consider the CHECK TABLE command. In which two situations should this command be used? (Choose two.) A. to find out why a query takes a long time to execute on a given table B. to make sure a table has no structural problems C. to improve performance by updating index distributing statistics on Inno
2021-12-14 21:53 1081 0
Which statement is true about using Microsoft Windows Cluster as a platform for MySQL? A. It relies on the shared disk architecture being visible to both servers. B. It is provided by means of IP-level disk replication. C. It implements High Availability by using the NET Connector’s load balancing c
2021-12-14 21:49 1236 0
You have a server that has very limited memory but has a very large table. You will use mysqldump to backup this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows? A. —tab B. —single-transaction C. —quick D. —skip-buffer Answer: C 如果由于大型结果集的内存不
2021-12-14 21:46 1117 0
An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user’s shell setting. Which statement is true? A. The mysql user needs a login and its home directory must be the base directory of
2021-12-14 21:43 1098 0
On a master server that is using statement-based replication, a table of log data has become very large. You decide to delete 100.000 rows. Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.) A. Change the replication mode to mi
2021-12-14 21:42 1127 0
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice: What would you run to fix the issue? A. the mysql_upgrade script B. the mysql client with the —ignore-password-hashing option C. the mysql_secure_installation script to update server securit
2021-12-14 21:36 1166 0
Which two methods accurately monitor the size of your total database size over time? A. monitoring the Innodb_rows_inserted status variable B. monitoring the innodb_redo_log_size variable C. monitoring the information_schemA.TABLES table D. monitoring datadir size in the operating system E. monitori
2021-12-14 21:31 989 0
CNDBA社区
