交流 QQ 1157222342

mysqldump -u root -p123456 test > /usr/local/20210421.dumptest代表的是要备份的数据库名

知识来源：https://www.bilibili.com/video/BV12b411K7Zu?p=13&spm_id_from=pageDriver1，查看当前数据库show databases;2，进入一个数据库use test;3，查看数据库中的表show tables;4，查看另一个数据库的表show tables from myemployees;5，查看当前在哪个数据库select database();6，创建数据表mysql>

参考链接：https://www.jianshu.com/p/bc14ff0ab1c7测试环境：linux 7.6 64位 最小化安装包CentOS-7-x86_64-Minimal-1810.iso禁用firewalld和selinux安装apache（httpd）yum -y install httpdyum -y install httpd-develyum -y install httpd-toolssystemctl enable httpd...

知识来源《PHP与MySQL程序设计》第四版yum 安装的 mysql 默认文件放在 vi /etc/my.cnf# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[mysqld]## Remove leading # and set to the amount of RAM for th..

知识来源《PHP与MySQL程序设计》第四版1，查看MySQL的配置参数mysqladmin -u root -p variables #输入密码后可以查看配置参数或mysql -u root -p123123SHOW VARIABLES;查询某一个配置项SHOW VARIABLES LIKE "table_type";可以通过status命令查看一些非常有意义的统计信息，SHOW STATUS;2，管理链接负载优化的MySQL服务器能够同事处理许多连接...

cd /usr/./bin/mysqld_safe --verbose --help./bin/mysqld_safe --verbose --helpUsage: ./bin/mysqld_safe [OPTIONS] The following options may be given as the first argument: --no-defaults Don't read the system defaults file --defaults-fi

yum 安装MySQL禁用selinux：sudo sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config重启服务器后，查看selinux 状态：sestatus临时关闭selinux 重启后失效：setenforce 0禁用firewalldsystemctl stop firewalldsystemctl disable firewalldsystemctl status firewall.

博主原文链接：https://blog.csdn.net/JavaJIAMIN/article/details/107487989?utm_medium=distribute.pc_feed.none-task-blog-cf-2.nonecase&depth_1-utm_source=distribute.pc_feed.none-task-blog-cf-2.nonecase&request_id=5f209de0f769fa6e5f5d4623