如何通过命令修改mysql中root用户的密码(一)

2014-11-24 10:52:46 · 作者: · 浏览: 1

有时候忘了mysql中root账户的密码,或者密码是空的,导致没法进入mysql或者安全性极低,这时我们需要update掉root账户的密码。修改mysql中root账户密码的方式比较多,我是经常直接用命令修改,修改步骤如下:

  1. 进入mysql及mysql中的mysql表。

  

  2. 输入update密码语句并按enter执行

vcX4ybBueigAQEop3X/y+t4Pf736zzvj90/FLVuJr4yvxveeW3KQWs4c+UyVPwAcovtPXn9h6E+7j+1vl7ZXy/jm+LuMXqMyxpVP27k9DgDggy9/fHP/yWu9Pyn7qdI/quMt8e2TKpTxrnx6zquTAgA+8uDp2y9/fPPTf98rf3/P0m+84733envA0Nz57F/uTZs/AByiYX8qbrJXhhelrbk6fnQiBcm3byW+cXMvjh9dKc5bzD9fhFHMap5SvQCAaw+evn3w9O3++yc0sPQtAIDPw2fvHjx999Ov9Kcu3u/nAAAVD5+9e/iM/gQACOar5+8fPnv3v5Q4ODg4ODgWOOhPHBwcHBwRD0d/+ur5+9XT5eDg4OA4kMPq6xd/D/sTAABzaOlPX7/4e7H+pP8+0GKzzz0RQtnq567UVfw9vOJbs5LmnSSHrX6surVKnmRed6P55uXlkv3pSrHUJVuUceS8qQSz7Xq3upEZH6UF+lO1TSots2fSTX6sirlLloKv1p++idGflOsLTL18JqFsvt6tFqi3ouLFOZbC8kQbU51k3g2btWQluP4RG1Pq7U+7jxWTy8+lr7yd8O/3NKyCNKZ4LuWvX5cGV8d781Ti6JPmcfSpvfGNpY2Saa5Lz6f40rs+Ul3FkjdTVyoZzuWKb6xLuWV0kgcsJiyNydfNmH9DvdV8Jlk3PY4yXXNdej7SW8pqSO+ONPWnl5fD/pQG/y2uS3EtLOejkqSUqtUq8V15KpNW07Z8JN71sdS1+8eE8xrLsUzRnIO9dsuY6vit1mUssy3+hPO6blTmKqY94XpW8+k5l/Jp4KrLks9MFu1PSajHNcD+liV+8a3q+PyLQ0m7OL4nT0v84RXv1Pb4ekwpfn5uj6/kmbKvw+p6NowfpbqNuvJ8JK74E87rulFaN+l8lxmFKtZbHF/N2bIO3nyaUyrWpedsyX9CS/en4hV9sHRRua4Ms0w91efk/fC866DEb/u6mS++a52rs0h5jsL2fF7GAjdQl7HShvjePNtmV4bpy1VcT8uM3uT19c8vevNpsOLnuPuHZfBc/WmYh6tm+xeEvUjj+u7Pez4nV13GPHvysZiqXu8Uc9Tbsz7K+G3XZSzWG99bV8PU1cHK+lTXVpq0up7G8T3r1mn1z9E4eJr+VEy9eHE3UExaGa8sU9Xw9jyOMq80XilNqmuqPKvxvZN64+epuuJLi9Zcb5KfE+/6SPlsvi5vsca3jClV2UeOxhcXP4/ZvJ6u/JWULOvmnbSajL0uyy3eBCwje/vTVHn03NJj4ekO1lbXeat1ATNxPTLu/nT88vK41p+a+/xUf0CIOd3B2uo6b7UuIIhZ+hMAAJ3oTwCAiOhPAICIevsTBwcHBwfHrAf9iYODg4Mj4kF/4uDg4OCIePj608+/XX7y6Wep6feHZyXlM3zZnKoS86aork9/UZOsrWtw2+eSD1v3A72JX05ALMP+FG2/tvSkniTzgDduQ5FynqqWqXq/a6T3c9kNtOUwk9UTAG42S38qNobhS+miNL4YKme5t2cLGAWx74NSbkrCxfztyUvjpQj6dSmOUpSl3vwWY13Sxc5Q9uUd3WJcH0uGDTkAuNbTn6Tz/F7LLTkpZvLv73r8vEzLLa71ye8tjrHnnD5ehHwi6br9XEqvIY6lnPxivlyuUNI6WCL0nOtZAbCS+tPwqdafyeIWYL9dya0Yc3Te8/yPMreEKo6vFqgP86YqrUk+Xg9iSaY5jrHAavzOUMZ37fl4azTOC6Cg2J+UDaJnX7PfXhxQvLfn+Z9qu6muj5SqMXklScs6tw3ujGP/XKRl8YbSh7m+TnoWuXlSAGPFv7+nbBCW8/zlUB5fsR+mxC++1bCjWe4qjrGsg3HdqpMac3blOVX+3rqkbC0v9era8umpUZ8dQItRf9pTNoX8sZQGK8+n/elV4ldTtQe371/FkdJbxUXTQ+lT5zGlSRvy1G9xxclLthRYjK9MURwsvWVPo6He4nXLjABExf7kfaq9bmJkAMCipO+f5jB32wMAbMeS/QkAACv6EwAgIvoTACAi+hMAICL6EwAgovzfj9je37JrLmeqdZhkJfPPZfWPqT+BSb7eRvcewm8vbPI5Bcak//9TivQ0Frlya66lfxGm6nDFz2X1zyhCXzm0/rRYvcDKbmh/8uY2YX+y/6F1qj/hKvvR6p9R//p476rmsPqatFl+3YDojP2puNVW982GfbwYU7loGT/MzTVef6ta12jqZkoEV13Goobvzro+oxmbF6pYppK/pVil3uJFZRGq+eS3GOvtXDcguqn+fdgk7JWWh2d4o3SLNJc0pjh+FL+hxgazRijWJd0797nXMPOeUJY4o4ujRctvdAXpPPeaat2A6KTvn1zPmPHxllTjDDcRJb4yqZR2Mf5U+8gCEfS0jXUZg0y+PqPIzaGGEfQS8qlT9vUwilmcKH9pXJ+e5cqT71w3IDrLz/eqz570nBifHCmO9zlXpqvWVR08ete+I/RvH0rtbZ9Xw7mUT8/6jEb2LJSrdmmuajLeD8IYZ3hx4XUDQuvpT5YxlodnGGSmeV116fmPdoeqSbYPV6oNde0+1jBpHspVVDGUnat2aS69Lj1Iz3qObrEXq6QKbEHx95+u3srPpYcqqc9nNYfqY69PkYfSR9rrKs5rt8s0BClGy5NMhnWTBuezKJMq8TuL6lkfKRllHaSi8vM8z8nX02uqdQNC49+PgGWfhR3rCUyD/oQ03Z/rcYX1BCZAfwIARER/AgBERH8CAEREfwIARER/AgBERH8CAEREfwIARER/AgBERH8CAEREfwIARER/AgBERH8CAEREfwI