Your password has expired.
Description: Your password has expired. To log in you must change it using a client that supports expired passwords.
Solution
情况一:如果是本机的mysql过期。
请使用root用户命令行登录(从命令行登录不存在过期)。
登陆后直接输入:
> set password = password('123456');
再次使用客户端访问,发现可用。
情况二:如果是服务器mysql过期。
这种情况需要修改指定用户的password。
以root@% 为例:
> set password for 'root'@'%' = password('123456');
再次使用客户端访问,发现可用。
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘…’ (61)
Refer to https://swsmile.info/post/mysql-allow-remote-access/
Reference
- https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
- https://linuxize.com/post/mysql-remote-access/
FEATURED TAGS
algorithm
algorithmproblem
architecturalpattern
architecture
aws
c#
cachesystem
codis
compile
concurrentcontrol
database
dataformat
datastructure
debug
design
designpattern
distributedsystem
django
docker
domain
engineering
freebsd
git
golang
grafana
hackintosh
hadoop
hardware
hexo
http
hugo
ios
iot
java
javaee
javascript
kafka
kubernetes
linux
linuxcommand
linuxio
lock
macos
markdown
microservices
mysql
nas
network
networkprogramming
nginx
node.js
npm
oop
openwrt
operatingsystem
padavan
performance
programming
prometheus
protobuf
python
redis
router
security
shell
software testing
spring
sql
systemdesign
truenas
ubuntu
vmware
vpn
windows
wmware
wordpress
xml
zookeeper