ubuntu系统中Mysql ERROR 1045 (28000): Access denied for us

第一种方式: skip-grant-tables:非常有用的mysql启动参数 介绍一个非常有用的mysql启动参数—— --skip-grant-tables。顾名思义,就是在启动 mysql时不启动grant-tables,授权表。有什么用呢?当然

                        <p><img alt src="image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqoAAABtCAIAAADmldQYAAAe/0lEQVR4nO1dveslR3btzJGFk02GmUjZPHZHGIyjxSyWZyOhZNuZEuNEof+CfX+KAjtpJ8LGgRyJjSSMLLT7WLTIxiBbY6NAoEAgEOI56Nfdt6ruufXR3a+6+51DwcyvXvetW7eq69Stz+Zff/v1GD747Ov33nvv3XffvS6Prm2atltBMLEpNA0Dw4qBIIiF0JD+iSVRnR4Yjh0IglgId6P/pbD1bkTXrqve2vIHXM6nZsDpfEl+rzo9MBw7EASxELZA/5JpotS2bfq/nE+rKre2fDVFjf5vvZDL+eT9uGwzfTmfNlza12tfH3O6R1sDKN/NgfRPEEvjnvSvMrfTfCa09gvS//I9ia5NaUnL002Tvyh0ehi6IaFCj0b/e8cC9L/Ud2TKIf0TxNKI0n//TY4OumwpkNeuxHdt46H/YfQep3fEG6NQwQJIH/t5ocCNtnR9sByZNdBGBa65METEDqHhDM69CTqdz20voX/vdL4obfkUBaUL27Qtft+NPJ0v6kxE2Ezr6Rp2FnXhLH/IGiWyrBmWC6pXYe67m4UsZVDKWroAdctXhSbfqs/ObxE729/F9Ur6J4jlkUT/zdTAOI6688dE6Gr8VevdDwJlLyCB/p1WQ/wXP6+yOxyNKKN/zxOWeXfbWN3LuZxP9jCyI79rez3Gt2605Mse/0aula9mjB7Chtp9w2+mUbrQznI4aMilr4dbr4C1wBOgXFA99+QEHZ4gHVSOuD4g9auUr6UQsDj46XIZpMo0kJ3tJEj/E548e/HRx5/U1oI4AhK9/+A9jRVuk8FqvC7Kn0EOvfYpNS1eJJf2fEA0mfSP4bv+riEcQWq6sWbYky+d0KH5HyO0PhpgJS/ZLsU7NHz/sJlGbJhevm2nqBEdcLZYWCsXs7sw/BAudQjeQ+Vo1AcNNctXhdE7jQ/+iyfyuxE9SP8Dnjx78ebLlj0AYj5K6R95IdA7UUW59H85t22b4v1vkP6DSfDQS0YOpRGJ5UN6kJLA4EU4FhuIdV9xBy4s3x8002G6yM4eG8nswXqFAdLVMoAFOsoFBJiqmFEfNFQq3wgUexpZdmYLSP9L4cmzF1+9+j/2AIj5qOv9jw5k1zbj5GYzTtZrjZgrZPor7flM+k8jGWXW32xW873/UL5BD6OosK0XCuiT2yn0cOuJKHm+Xu1m2h/XV+yM6D/b+0fpIjtbAqeB9/CJMu8/ReVa5ZuknCdUr8/al0b6n4snz15cr1f2AIj5KKX/krl/raWBrc/0w9QlGPRx5jLF/9HzgP7VtJEckaHAHuqCfDxaqufZWFagyLfo4dY+n5zldF2H+2Ry/DhKD/6EjQevmYbpIjvLMu3a6YfMuX+YLioXk3u6fiFeUrcBlaMxeo5SrFK+OrA9gQi/y5VA/6YqpP8BPf1f2QMgZqOY/q/u4J7vAGnxzgioOw+qPT48fBsUmJqPYUm015bB5xH9A310OVJXN1PADfZyFvhLSg7U0VJdvk0PIddAVcRPp/Ml7h1OE/96S139WBiGY4eHx0j/V/YAiHnYwrE/+8bae/GL5GeNjbvvzcxNdXpgOHZ4eEj6v7IHQMwA6X8e1Png2vJL5nPH5Ej/DFsODw+P/n/88ccvv/wf9gCIApD+D4VhVqG0SzKf/ok1wfIlJP3/+OOPP/zww/fff/8f//lf7AEQuahO/3JSek8t09puv5LeruxDEMQaGOl/5P7vvvvu22+//f3vP2cPgMhCdfofUD5gXQN4ud9aIP0XQG4TcSPDpaYyWl3H7v1mPk8Qa6Gnf4/7v/nmm6+//vrTTz9jD4BIx5Hov3S9W76cClfvEDkYNhO2ZlE6Xaquc7YGukdLaRv+0fMEsSaePHuhcv+rV6++/PLLjz/+tzdftrV1JPaBGP2LfXa8emRSwD94yJcDT7Ub4oUt7HhrW6T2vPPKqW1Lb8zr5Y/ivXyF+TVUhTVCxHt7MyNPJ/vbdk8u6YiehE7lvkauiH3jybMXI/f/4Q9f9Nz/5stWhto6EvtAAv03TcurR5xkwj5NKMeif0F3jt20eKQUfN4/Wm8G/Tt9E6eDFOYXHsuDjrvRz2yCxi8b2jHfCk510N7qHwq7QfN1I4gSPHn2YuT+P/6T1//+H/7x1atXf/XLv/6nf/6gtmrEzpDk/WvHywTNvTxaTD/TbpHDR43D01IG7WcfPurP+ifRVcIxRObxREo6aXIgw0URyumNjvpY6FDetENwJz3N3kK2i61rKw52Cl8Ja6o3FOPJo+tP3BVPnr0Yuf+jjz/52Ru/6Mf8f/bGL2qrRuwMxfQvm1ZwOJ70PL12uJz+gXwljfBpZbBdg0X/6tU+G6J/z4x3o//s0aBwmkUb51eoVotPzIX2q1ucYS30nvEqLrmfuDeePHsxcv/1en3r7Xfef/9fvvjii7fefocDAEQWZtD/2PbBzcSi6VzM+wfyhz+Dtt5x2OZ6/8qC/yT6x+nuhP7duYXlvX+sAzpnP62uRAaEXPOoxjIqbrlxCaIYb75sR+6/Xq8fffzJ85/+/PPPP//ww9+88ad/WVc3Yl+YQ/+3dvhxrh7RFvxbQw7OUsg7Df77eXTf0u4s0CGXDaTYzZ77V17RR/NR+VrlHslFovcP+xSgE5veByGIVfHW2+98+OFvfve73/3Zn/+yti7EnjCP/le8WgbAkH91RpTdPsoQ141cZBKDKkff64/liBnmO879S+37Ffrl9N+24Yq3SLfJm2IJf9C3KIxpoPK1y91UxXvH+ckd39Ae915xBnTQ8wRxT3z11f8+/+nP/+Zv/+7fP/1tbV2IPWHmvv/SNc9wvmC72OVe/9DOqZbnanaCIIgjYxb9ly982h39d3c+43cRhAvV06er90b/1a+i4f00BEHsCoX0Pwx9lhLE7uh/PwCD27kg/ZP+CYI4MjZz6G8qtk5Law8T3GsYQvYi6vXU0kcrqjO9FtKN55089XjYRn0jiEfCFugfLhnTsG3615cH7ke+mqLWHN96IWuz1s7pPyujJL3rlScpEMT9cE/6V5nb2T+V0NovSP/L9yTSlgeWp1th+aHeHA/dkLUV2uXW+pLyJf3fQPoniHshSv99WyY37Y0/Ia9diQ/PeOt/GFu96R1tg1ywcS7UJ3LK3qTAuM1O0wfLkVnDG9/cX8INYzhd33AG594EVbyKaSi2pJkIPV3DzqIunOUPBaNEXbhzMWblDATlq+w3TOwI5ND/lIq40sn4TuHGxdhdBgJ16xtBECsgif5zrniBx79oXtEgUPYCEujfuX8mOIJYe15ldzgaUUb/nifsH30T2zqvH4OD5A+n8oxvdXe6iinswNitddKpiP6pBfJonXi9guk6vS6tnsxBbvlGpSWSHrAP+k6Rnsg+RqpV6htBEGsh0fsP3tNY4TYZrB/+qoryZ5DR8Tjw2JwpubTnA6LJpH8M3/V3DeEIUtONNXuefHgcU0CT8qhFdUQh+zDmfN9fXzyQWL5tp6gRpVhUT6K9rETklm9cXJpSwD4m3Wp6IvvgZKvVN4IgVkEp/aNev3U4XYz+L+e2bVO8/w3Sv3oVEHCS4+nG5cPmWEoCgxfhGHAg1n1FO0Exa/g8TBfZ2Wv9ZfZgvVJh0puijylIGczPLd8IUukf2cccZdH0XIr+161vBEGsh7re/+hAdm0zTiY242S91mi4Qqa/0p7PpP/UhjyY9TebsXzvP5RvNMejqLBtFQoIJy3TG7v1RJQ8x+CPWyt2RvQ20/vXH4+PeWPklm9c3Dr0j/RMsY/7eK36RhDEOiil/5K5f+3Lhl+7N1zrel1y7jCY1gyfB/Svpo3kiAwF9lDXv+NRZj3PxrICRb7VHN/a25WuYvInbGzAdJGdZZnK+emiuf9QZuHVQVrOYPmuOviP7AMTBXqi7wigXn0jCGIlFNP/VQztebSF4p2RSG9tkvL48PDJvzJnWILstR3weUT/QB9djtTVzRR2g2XOgquJlRy4zwuiVB1XozkO23yoivjplHIV0zTxn+ytgnShnUfreFcW4XqloGsb7coiQ598AGGr0v8V2MdKVNMT2MdIs059IwhiLWzh2J99Y+2t70XyS/1aOH67O8zy7O+PHPoXKC+vZe3D+kYQ+wPpfx66LZ7xW+5BHac5fgT6Txi0h1jSPqxvBLFHkP4PhWFcuLRhP05zvDP6T4czrF6ew2Xsw/pGEPtFdfp3Jwmb579mY0AQBEDt4bZYt6l0N8na+RqQ1t6m73gm9ozq9D/gcj41P/nJnelfLn92I0PvSkZrC/H938znK0HNb4mMzHyBdCdRaYKm51PLxVZ/QyWzCFT7GPF7kTOhYLfpwvLXof+186WmaLS3pP/HwIPS/7DZrDU/ZudT7jpnBbrY46TPwMLnayAtv0nIypeRrmhhkgwkJpidueZMOzte1gZKZjEg+6D4vciR2MAy21UmlSpd5UX6f3TE6L9rm6fPm9eGoaKn/b+v/8Xrft2ZqpM3vDQ95Tperz0H798r64NKuJqj5smln3h7sJ3NTMs2Xun5CtMN9/qFe0f9baCxY2ry7XycuWdkH9tu6Xa+jxwTjovsvAn3h/qfqdx0aMvPlWNtX26DK8dgujXb20mQe9UWcVgk0H/TNE3zsj01zR81zfNfvWyePm+e/+pl0zz1zm172jT9HWJPlUp+OZ+a5rVmODKmF7Zt+oddYP/4mtjNadtZhlZru1f4pBujnC7gtpReWehEn5e77XTKFgCyT8RuyXa+kxwLrouM6B/Vgf4LHQ+aUhI15AM52ki//96tZRiiFLHhVV5V2luZlyUmCYkdIM37f/7r98+n5vnTvrqNEWP1EXVJq2rXoLYNUrZJ/+JAmvAVr8XqxMlr6mDyplhmQfrPypfa6vnrJGJTqti5zNbnQG5/D2SfuN22LWeEPzuO6D84gCgxIV9+mpyw0kUyGLgUl+AqrzrtbZgv0v/xUUz/l6kDer0MPw5vhSNhXid12/Qvf3U/bv1zd3sDvle0JZpZiv5z86Wm6w02mvISvM8MfbZWLPOxlLe9NTkD1Cu19MH/q6hZydMM+ux7VM5s+leu8qrS3noZIf0/BmbQ/1iDbuNTIXF3bdO81oyd1N14/yPcr0D9JsLBAGc6cGPf0CL0X5CvXGcx9oTZ+D8klppr35qc6/Uauub+m0CMP8BkTfPFaqcuJzapFaH/MN1a7S3p/yExh/7H+ta8NnZFL133/njbh+yCelXTXaRy3Sb9O569Ms8X/CA/Ivh8TSxA/0X5its5HMn34oRtg6WXm7NzBSD7oPjxx0Q730WODs01n969NSd94uZVQ6gGKvJNOdZcXw7961d51WlvZV7ic3HEMTCP/sOZJzkM5VU5+dPT53W9/0DNiUKcn9x+vva494rjkKDn7w8jv5nIy1eincG8gObx5ZSLnYnjNW+afaz4HDvfR44G5JqLFToTqboVzlujo6emyrfkgCvH9HQw/avp1mxvx2LxrtoiDouZ+/69Kaac9/TxK4IgiAkb2Ou/nXTZ3hJLYhb9l3vsrI4EsSqahoFhrUAcAoX0L4Zci8aISP8EsSqqMwTDgQNxCGzm0F+C2DO6O13ZkozqDMFw4FAN3mIHepCz8Nj0ry4Bk4vJ/EU8saVMyubkHFbI0idlaZVQSIqZOduZt3TrCu0A7ZaT7oL5Koe7jCvbPgvBSbc6QzAcOFRHnZ1iR8M96X+pM2cWwLBZKOPKHxTvnzjWdsnyZ+mTsLHK2Wa01BVEWRu3jHypditId7mrlcrrp1zGVbCxbRF46dZnCIYDh+og/S+BKP33beI45AL2u+lnbk3x/vasrfQD7BYfNd+IYaPbfhbUBx4/IhUC+3fm0FLRsS1gZz+WE24kS0k3JV/9m2N9FIe3o/rpDDdGr4ops898lB2zk27n+8hRMRXAqW1Pjhy1XYIbcWN3c8wFqCnRLa6eMurzVn51OHVaPyFp/AjN9tnUP0z0yFfEHQ1J9K9dlRF4nGLjrRZ/3ZT3P8BUCW1+9Y7u8Kki5eKQ2fp4ugUH4dzaOr2VmFEQVroGwhRtuwV0kpRuSr6cI03c4R319bhMZwdXoX1mA6Ub0SfZzneSo0CWkZhEQu2S0+YI8Ua5L4PLWb0kwGgPw9+N52F+sUIXZUAK0H/4U6r+HgbKPugVcUdDovcfvId4zuK/3dC/OFAkHh80T/7E9Hz6V9K1hhlEd1ppJeYxUuHwhvKYabeCdBPzZXQ7YPNnyb0EV7bMGv4pBUo3V5+tyVHKSxtFmOBWA/T88t0yIDHqD3gPwOfxeFcAs1+cSf+5/kx37CvijoZS+i/5vHdD//LX6Ny//AaDq2uWHfwX6WIvSvj8IXXNbvYW8/6vpt1y003PVy79u5oqgwPh6bc78v53IUcdXEGFFQ5j969n078vSLZiSnxmO4kyCJ8vaDzdvkEZ/Rd0+458RdzRQO/fUilp+N+Styz9y3TdJ6e/jGYOap0DlG7OW/m/m+lm5cuQk+SJ+r0pu728X5VPqw/ldq4kJ5v+EbGvXS5b8/6dcXrk/ceNspj3f5kYe8dXxB0NpfQP54SMuaK7uULpWMT7N6St5v071pSGdUwu/0BK5wKkayOeL/fXYC4Zp5uZr66dBHtTmVp24NUv/d92g3/XCo/SNfXJsPNd5OjZklVY70b4L+jj36Dcl4FigiF6qbn/3JZEaxMm+beuQ2RIJKZ/mOyRr4g7Gorp/6oN2djxzsBZ3X6A0mt2vhVF/ZR4p6cD5C+lz1Wa04mXw5NORz9ZnQhAuuX5AvMCmmftv5Cbr65t+n2I2tNh/XQzEHP9s+2zLFC6WJ90O99Hjp0teRWNRYdaoZnlvhDU0faEmu5poz6fP14xWfl07kT5DPEneVWS/4o+uRlXwab/XtQOr4g7Kh772B/i4bDYsG+tq2IeGh3azJLy5tZmHh8Q3pR+zns8JH4FkP6Jh8JCNNBt7YzfR8CcQXvSf32Ue+yk/3VA+iceCqSBncGY/MoBy70mxKxCUSGQ/tfB7uh/65/x2m7hvdxO2epueZR7L3oSBEFsC1ug/5ylJRunf7wcbB/y1RQ1Wr31Qi5J54/dAxvcVkIQBLFhVL/yJ9jMFqG3Bel/+Z5E2nKw8nQrLDfTaXXohmxn/RvpnyAIIgeVr/wZvcfpHe14iuC4m1Af+3l/rxHSJ3agDNjcO/6o7V5PsUNoOINzb4JO5/NtH3T/3m0jj7KLyDexJ13Ypg1WVqPNwKfzJWUmoq6eBEEQBEDdK38GgbIXkED/zkVt4r/4eZXd4WhEGf17nrB+1gZMFx1XAuQPp5iMb922RIUn05inhoVqxmg17MBElK6kJ0EQBGGh7qG//gxy6LVPqWnxIrm05x1CL6B/DN/1dw3hCFLTjdHXJbhaxj1DXUagE9b0EQXvyPE4rab7/nX1JAiCICDqXvnj0v/l3LZtive/QfoPJsFDL1mfp1DTjcuHtColgcELOX7hJRuj1Uzfv5qeBEEQhI3KV/4MDmTXTpPCzThZrzX+rpDpr7TnM+k/dZGesiDfoKN87z+Ub9DqKAoekSbmTAq86ltPJG0TQkU9CYIgCIzaV/7AVjtYCibn8uUccDC9Hj4P6B+takNXYoxxvj3g1S+xrAXP650NRb5FqzfePEmXGl5d41FsfE49b8tfPT0JgiAIAyb9Nw0DAwMDAwPDngLpn4GBgYGB4eEC6Z+BgYGBgeHhwpL0T+wEw8r8xN2K2vt3mUDfi54EQRC7Ael/fZhn/90Jcgnk4yHjQAYAsZRw+XTlwYWH6qZEz6baSLrh82sXCZKfunlogdSzs7VEO1b2HR0V89ulVID2/yHoH+TdO9nXgbsJwXs8o0kIPhkpBe/99xfPq3oWxT9kF2DT9H/kTQj3YbO0dCXjhptxgJ5rF46183lFZCezlAtD+pe4H/1fr2r7vwb9a6e8uAfAoINhwHGx/um1ySQ8bMZrw9runRznStI28SWdWqek73N8Jzc26tscwXZD6+S7aDxUqAS1vLpS3Pczy0y3FkXeA4n7PYtg2S1I16GdsFignjum/yz72DhyD7UmytslrxsluAk5kWOCMnYN+tcyBPZko3gndwnPR6AeIKgeB3S93r6NLiiZfPqPfMsBbUvKzzm2KCHe1imzb9+12i06jnslf0yI945ayJECMb3Qnp3C1NK9mSUYOLFcRl1/nK6hYaMkoibd6zn+FLUDPpUS2xPbJz1dWx9VDjK1Eh+eJmnX3Qu8KiwG0IVWk9Ut6ugaPb4L1UOcrpZqrn0iiDUjCfUKGS0pv6e2jdFkL2cUgxzGsnZGY+mpA5X7nRrtQ3o73OdKVrLhmBSdNz1DDX/VoH/p9qrxwci7Tm/KAD1AUH+9AvVc79P5ohS5NVeQlqr9ey+/7eQ6NaRnbnxEqzz67+uackCSxgpmvOBY0XDF6k+qku7Qk+RzPV1hgiA5tQYpcmC6tqY2LYi05Gef4sKhZtoc7Yb2SU/X0me1K8EQLviqsIRXg7Zb1QcOiF0uF+1dEIfqoVUfQFYWG0jQBGXXKyALfneZ39HQeF79d4H989qZsUmeJHfjcWZ536mZryz6P50cGm07izdBXAX6D3ooQbza1gY/ZUwjRVtz+ZnhHt/0bHIRQf3gjIPfq1P1zI33kpnTKugWQsODafGTqNxeBEIwnqPRiYhXOjNmhUmTk2Rr1B9Tx4Rz23TUTFt2TrBPMYAclF9ohyyVOnxVWAyeAlAfVM99PbSv0Rj8HzQ10wUJL0n/thOZUK+QUui7y/2OwucVJcRDee3MkH7Xnm7XzAgnMes7LWgfVHRtcxtcGJILPTLc4VyV/rUxFTkEo/T+tJETNRtIjo1U71/006ySSfywMP0rxdK5h9vrw05LeP8z6d8zUVlvWhue1MbflLYyreSVVlv2ysN0c+kfyIHpGoh20a8JzUqScF8dxZ6J9ikGkFPSnS2lf+eqsBi8Ai0pF9Gt16t0Av3brKl/F1Xo39BHVSqtuzOL/rH909uZ3gRdezpfBqY9nS/59aGkfUD5Hex0I/7N0L9FA37vSo03BjGQHBthYbgxt7/ciuKTkiUuMdUxd0E0qr6qngXx2coDBCYSE2Dl3r8ONLyTMOwDPzOU7jzvP56ugft5/wb3al26mJIlqOL9D41l37k5yavCYpjr/TtN2Qrev5dLq6tSjGgrklCvkKx16H/6K2Z/pKcXfzmfmvbcTxl17enc3WaPcr/Tpel/yGC7n8F/VCIy3ikR+QeSY8P+7tRPF5dMerrI+mjQaXhW/oH0zI23dLqRelqPBrAiEmHGh1YHV/jAq30Q/MoUG/XLpX8kB6aLAUskc65XxSTHoTxszzT7FAPJQflF8f5PEeQ8a74I9QH13O9aFdI/Stf6LorzHMBsPhPrFYiz8pvzHXWt94krRCKrVW47I3S4nE+n0wm1vZHv1M5XcjssG2JZAJA31Uytv/FvSD/snTXK6MkU7wxDwi6tfF6D7c5PKaT46EJW8kcVfoEiV1gdTyGkZ268qpDIW7TaKV0iWR5olC0tfhw814yD4i2MZugnycx08+kfKwXTNfSELYVvtHwaHtS5Ob2yswbsmWCfYhhy1Pwa8aiJAMBiYm8Z5kEthPhpUrLfTmSPIhn1UEvX/i6y7JNphYJ6peTPym/Wd9S1vQ8cJqzaP7+dwX5n7ndq5KuI/hWHGtrfL8hVjv1hYGBgYGBg2EUg/TMwMDAwMDxcIP0zMDAwMDA8XFiA/reIxZa/rgR/Ld3e5A+QE2DLrDciCIIgtoMt0H/WGp5t0/8l+fSxbcpXUwQrftquXzTLvgFBEMT+cE/6j+9tTVhYvSD9L9+TuJ0dsVq6afIXhU7/QzekgkIEQRDEAojSf89Vo4Pub5nVvHYl3t8eJ3YBO5tN3TecHcFOfKiP/by/dw7pg+XIrOGNTu4vwhARO4SGMzj3Juh0PrfTdpNxw46yq8k3cYN20ij3/qAzFIZdntsdiSEIgiAwkuh/tSs9LvjqDovOtXsE7edVdoejEWX073nC/hEi04+69w+OZwHyh1Mxxre6dvhH34abcmyFpoK2j9kDBwAIgiB2h0TvP3gPnW5hnXoRivJnkEOvfUpNixfJpT0fHEORSf8YvuvvGsIRFD8VLi7/xvaTYBmBTgyMHxvRpXj/9P0JgiB2j1L6R16mdQhUjP6dqzt2Rv/BJHjoJevzFGq6cfmQ/qUkfNAh6orE6J++P0EQxDFQ1/sfHcjhsN/puGPnYfFHeEhw/1fa85n0n7pIT1mQb3jz+d5/KN+g/1FUyOVCAf0agRTv/9YTuf8mBIIgCGIxlNJ/ydy/xnCQ9YIla3IuX85VB9Pr4fOA/tGqNlWOyFBgD3X9O57Lh4vp0bICRb5F/zd+PznH4ltXX8j5gSj9c8sfQRDEAVBM/9eslf9CWDBmjB5Xr6CQS97BAvbgeUT/QB9djtQ1WL+YYCB0GRDaSuHcAhLKt+k/7HtAVcRPp/Ml7v1PE/9kf4IgiP1iC8f+7Btr82CR/NKjBeB8AUEQBHEokP7nYZNn/MZ2EZjJkf4JgiAeAKT/Q2GYVSjtkpD+CYIgHgMK/f83QRAEQRCHhk//tbsjBEEQBEGsjuaDz75mYGBgYGBgeKjw/+0Fg6C9IyxgAAAAAElFTkSuQmCC"></p>

第一种方式:

skip-grant-tables:非常有用的mysql启动参数

介绍一个非常有用的mysql启动参数—— --skip-grant-tables。顾名思义,就是在启动 mysql时不启动grant-tables,授权表。有什么用呢?当然是忘记管理员密码后有用。

以命令行参数启动mysql:# /usr/bin/mysqld_safe --skip-grant-tables &

3、修改管理员密码:

use mysql;

update user set password=password('yournewpasswordhere') where user='root'; flush privileges; exit;

4、杀死mysql,重启mysql.

然后就可以直接登录

方法2:

查看mysql安装的路径

然后我们更改root用户的密码,

查看默认密码先

然后直接登录

然后再更改root默认用户名和密码

GRANT ALL PRIVILEGES on . to 'root'@'localhost' identified by '密码'; flush privileges;

  mysql>update mysql.user set password=password('新密码') where User="test" and Host="localhost";

  mysql>flush privileges;

  mysql>delete from user where User='root' and Host='localhost';

  mysql>flush privileges;

mysql>grant select,delete,update,create,drop on *.* to test@"%" identified by "1234";

mysql> UPDATE user SET Host='127.0.0.1' WHERE User='root' AND Host='localhost'; mysql> flush privileges;

把Grant_priv修改为‘Y'即可(flush privileges;(执行该语句或重启MySQL后生效)),update mysql.user set Grant_priv='Y' where user='ptmind';