mysql 忘記root 密碼怎麼辦 – jashliao部落格

mysql 忘記root 密碼怎麼辦

資料來源: https://mp.weixin.qq.com/s?__biz=MzAxNTcyNzAyOQ==&mid=2650961559&idx=1&sn=b3944f44a7b289116615ce1b69629512&chksm=8009764db77eff5b08fd2ff88f20b8e7fb5a0001b2e8d7dec9de1a0d217e50f54c6411cbd46a&scene=126&sessionid=1584923264&key=b1b0a4eeed0bd1e15c9152098f47084e5501f23edf17a5446d33c1802277f51ca2f2c99a8f6ebc0275f610ade617fec825403417466284be8e32141b171f974bfa6f2a7b5e7621a653089b9978240f8f&ascene=1&uin=MjIwODk2NDgxNw==&devicetype=Windows+10&version=62080079&lang=zh_TW&exportkey=AiQ1fpnasGl56/X3dd/lHzM=&pass_ticket=bwk3+9R0UAMDZ8f8V5jOvH4glAaIcdgKYE8n/PE+BrBJ6AftNHVhUyxW8RQewCk8

$ mysqld_safe --user=mysql --skip-grant-tables --skip-networking & use mysql;

mysql> update user set password=password('123123') where user='root';