问题
修改检索目录为/myload
将/etc/passwd文件导入db3库的user表里,并添加行号字段。
将db3库user表所有记录导出, 存到/myload/user.txt 文件里。
步骤一:修改检索目录为/myload
1)修改配置文件,重启服务
]# mkdir /myload
]# chown mysql /myload
]# vim /etc/my.cnf
[mysqld]
secure_file_priv="/myload”
:wq
]# systemctl restart mysqld
mysql> show variables like “secure_file_priv”; //查看
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /myload/ |
+------------------+-----------------------+
Mysql>
2)新建db3库、user表
[root@dbsvr1 ~]# mysql -u root –p123456
mysql> CREATE DATABASE db3;
create table db3.user(
name char(50),
password char(1),
uid int,
gid int,
comment char(150),