Windows安装MySQL
下载安装包
安装MySQL
下载完成后,将压缩包解压至某个目录下,然后使用管理员打开cmd:
然后,进入mysql的bin目录,执行:
mysqld --install
提示 “Service successfully installed.” 就表示成功啦!😀
启动MySQL
接着上面,执行:
net start mysql
打开MySQL
执行:(没有密码,直接回车)
mysql -u root -p
其他需要的操作
查询密码
select host,user,authentication_string from mysql.user;
+-----------+------------------+------------------------------------------------------------------------+
| host | user | authentication_string |
+-----------+------------------+------------------------------------------------------------------------+
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.session | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | mysql.sys | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| localhost | root | |
+-----------+------------------+------------------------------------------------------------------------+
4 rows in set (0.00 sec)
设置(或修改)root用户密码
alter user 'root'@'localhost' identified with mysql_native_password by 'root';
退出MySQL
quit;
设置环境变量
为了在其他目录下也可以执行 “mysql” 命令;所以需要配置环境变量:要么直接将bin目录添加到Path当中;或者先建一个变量,然后在Path中引入;道理都是一样的。