阿里云CentOS系统配置MySQL,并用本地主机上安装的Navicat远程连接云端数据库。

本文提供了一站式的MySQL安装、重启、登录、数据库操作及常见错误解决方案,包括CentOS上的MySQL安装教程、错误1045和1054的解决办法、数据库选择与密码重置指南,以及远程连接配置步骤。

1、CentOS安装MySQL参考:

这里是https://developer.aliyun.com/article/47237引用

2、重启MySQL参考:

https://blog.youkuaiyun.com/qq_30509055/article/details/84307255?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522160527513919724835811016%2522%252C%2522scm%2522%253A%252220140713.130102334…%2522%257D&request_id=160527513919724835811016&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2alltop_click~default-1-84307255.first_rank_ecpm_v3_pc_rank_v2&utm_term=%E9%87%8D%E5%90%AFMySQL&spm=1018.2118.3001.4449

3、Mysql数据库登录、退出、创建、修改、删除参考:

https://blog.youkuaiyun.com/bobo89455100/article/details/72478962

4、重置密码遇到ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using passwor:yes)问题参考:

https://blog.youkuaiyun.com/vv19910825/article/details/82979563

5、报错ERROR 1054 (42S22): Unknown column ‘password’ in 'field list’参考:

https://blog.youkuaiyun.com/weixin_40845165/article/details/100943054

6、报错MySql ERROR 1046(3D000): No Database Selected参考:

https://blog.youkuaiyun.com/qq_43116788/article/details/84146918

7、报错You must reset your password using ALTER USER statement before executing this statement参考:

https://blog.youkuaiyun.com/muziljx/article/details/81541896

8、阿里云配置mysql远程连接参考:

https://blog.youkuaiyun.com/u012971339/article/details/54406779

9、Python数据库入门参考:

https://arcticfox.blog.youkuaiyun.com/article/details/94005900

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值