记录一下如何创建虚拟机且安装sql,用xshell链接

第一步就是配置虚拟机

https://blog.csdn.net/weixin_44925596/article/details/124491414?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522167363403416800222842059%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=167363403416800222842059&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~rank_v31_ecpm-3-124491414-null-null.142^v71^one_line,201^v4^add_ask&utm_term=%E6%80%8E%E4%B9%88%E7%94%A8xshell%E9%93%BE%E6%8E%A5linux%E8%99%9A%E6%8B%9F%E6%9C%BA&spm=1018.2226.3001.4187

第二步就是安装mysql

https://blog.csdn.net/m0_67392010/article/details/126034669?ops_request_misc=&request_id=&biz_id=102&utm_term=%E6%80%8E%E4%B9%88%E7%BB%99linux%E5%AE%89%E8%A3%85mysql&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-1-126034669.142^v71^one_line,201^v4^add_ask&spm=1018.2226.3001.4187

第三步 如果报错密钥不匹配

https://blog.csdn.net/weixin_53768277/article/details/124119115?ops_request_misc=&request_id=&biz_id=102&utm_term=linux%E5%AE%89%E8%A3%85mysql%E6%8A%A5%E9%94%99%E5%AF%86%E9%92%A5%E4%B8%8D%E9%80%82%E7%94%A8%E6%AD%A4%E5%8C%85&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-0-124119115.142^v71^one_line,201^v4^add_ask&spm=1018.2226.3001.4187

第四步重设密码,一般会报错是因为密码太短

https://blog.csdn.net/qq_42618394/article/details/103181778?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522167363665916800182721675%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=167363665916800182721675&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduend~default-2-103181778-null-null.142^v71^one_line,201^v4^add_ask&utm_term=You%20must%20reset%20your%20password%20using%20ALTER%20USER%20statement%20before%20executing%20this%20statement.&spm=1018.2226.3001.4187

第五步就可以使用数据库了

但还可能出现无法使用数据连接失败,是因为没有远程权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.23' IDENTIFIED BY 'Zyp02020500!';

也可以创建一个新的用户然后给予特权

同时需要关闭防火墙,不然无法连接,会出现链路错误