MySQL?????????????MySQL????root??????
???????????? ???????[ 2017/3/31 17:54:49 ] ????????????? MySQL
????MySQL???????????root???????????е??????????Windows ?? Linux ?μ????????÷?????
????Windows:
????1.??????????????????
????2.??cmd-----net start ??mysql????????????????net stop mysql.
????3.???mysql?????d:usrlocalmysql4in???
????4.????????????mysql.
????d:usrlocalmysqlinmysqld-nt --skip-grant-tables
????5.???′?cmd??????d:usrlocalmysql4in?£?
????d:usrlocalmysqlinmysqladmin -u root flush-privileges password "newpassword"
????d:usrlocalmysqlinmysqladmin -u root -p shutdown ??????????????????
????6.??cmd??net start mysql
????7.?????
????Linux:
????MySQL root?????????????
?????????????MySQL root?????????????·????????????
????1.KILL???????MySQL?????
????killall -TERM MySQLd
????2.?????????????MySQL???????????????????
????safe_MySQLd --skip-grant-tables &
????3.??????????????root?????? MySQL??
????MySQL -u root
????4.???root?????????
????MySQL> update MySQL.user set password=PASSWORD('??????') where User='root';
????MySQL> flush privileges;
????MySQL> quit
???????????MySQL????????????????????
????MySQLroot?????????????
?????п??????????? safe_MySQLd ????(????????????? ubuntu???????? apt-get?????MySQL) ?? ???淽????????
????1.??MySQLd??
????sudo /etc/init.d/MySQL stop
????(????????????????????????MySQLd?????п?????)
????2.?????????????MySQL???????????????????
????MySQLd --skip-grant-tables &
????3.??????????????root?????? MySQL??
????MySQL -u root
????4.???root?????????
????MySQL> update MySQL.user set password=PASSWORD('newpassword') where User='root';
????MySQL> flush privileges;
????MySQL> quit
???????????MySQL
????/etc/init.d/MySQL restart
????????????????? newpassword ??????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11