Windows安装MySQL进入Mysql官方https://www.mysql.com/后点击下拉到最底下找到社区版下载选择长期稳定版初学者选择msi之后都是下一步点击excute配置环境变量打开高级系统设置点击系统变量PATH将地址C:\Program Files\MySQL\MySQL Server 8.4\bin加入验证安装打开powershell输入mysql --versionmysql有默认的管理员账户root输入mysql -uroot -pxxxxxxshow databases;菜单栏右键点击计算机服务点击服务和应用程序或者点击services.msc找到mysql84服务。使用图形化界面navcat操作数据库Linux安装mysql下载安装工具wgetdnf install wegt -y复制下载地址下载wget https://cdn.mysql.com//Downloads/MySQL-8.4/mysql-8.4.8-1.el9.x86_64.rpm-bundle.tar解压tar -xvf mysql-8.4.8-1.el9.x86_64.rpm-bundle.tarrpm -ivh mysql-community-server-8.4.8-1.el9.x86_64.rpmrpm -ivh mysql-community-common-8.4.8-1.el9.x86_64.rpm接下来缺啥下啥查看mysql的状态systemctl status mysqld开启systemctl start mysqld按q键退出查看mysql的端口号(3306)netstat -ntlp查看临时密码grep temporary password /var/log/mysqld.log登录mysqlmysql -uroot -p’xxxxxxxx’登录之后修改密码(特殊字符、大小写)ALTER USER rootlocalhost IDENTIFIED BY Abc123456;刷新FLUSH PRIVILEGES;退出exit查看地址ip addr查看防火墙systemctl status firewalld.service关闭防火墙systemctl stop firewalld.service远程授权访问CREATE USER root% IDENTIFIED BY Abc123456;GRANT ALL PRIVILEGES ON *.* TO root% WITH GRANT OPTION;设置开机自动启动数据库systemctl enable mysqld设置开机不启动数据库systemctl disable mysqld数据库的基本使用点击新建查询