蓝桥云MySQL基础-6.3.3导入
1 minute read
蓝桥云MySQL基础实验-6.3.3导入
启动MySQL并由root用户登录,查看安全路径变量,若安全路径为空,
sudo service mysql start
mysql -uroot
MariaDB [(none)]>show variables like '%secure%';
+--------------------------+-----------------------+
| Variable_name | Value |
+--------------------------+-----------------------+
| require_secure_transport | OFF |
| secure_auth | ON |
| secure_file_priv | |
| secure_timestamp | NO |
+--------------------------+-----------------------+
3 rows in set (0.00 sec)
#经查看,/var/lib/ 下没有mysql-files目录
创建安全目录,给与可写权限
sudo mkdir /var/lib/mysql-files
sudo chmod a+w /var/lib/mysql-files
修改配置文件
sudo gedit /etc/mysql/my.cnf
#在文本编辑器里,文档最后一行添加:
secure_file_priv=/var/lib/mysql-files
重启MySQL
sudo service mysql restart
mysql -uroot
MariaDB [(none)]>show variables like '%secure%';
+--------------------------+-----------------------+
| Variable_name | Value |
+--------------------------+-----------------------+
| require_secure_transport | OFF |
| secure_auth | ON |
| secure_file_priv | /var/lib/mysql-files |
| secure_timestamp | NO |
+--------------------------+-----------------------+
3 rows in set (0.00 sec)
之后操作参照蓝桥云指令操作。
I feedback.
Let me know what you think of this article in the comment section below!
Let me know what you think of this article in the comment section below!