Ïåðååçæàåì íà äðóãîé ñåðâåð, ÷àñòü 3 (root-ïàðîëü äëÿ MySQL)

Õîðîøî, ïîä ðóêîé îêàçàëñÿ ãîäíûé ìàíóàë, êîòîðûé ÿ òóò âîëüíî ïåðåñêàçûâàþ.

1. Îñòàíàâëèâàåì mysql-ñåðâåð òàêèì çàêëèíàíèåì:
   
   /etc/init.d/mysql stop
   
   
2. Çàïóñêàåì åãî æå â ðåæèìå áåç çàïðîñà ïàðîëÿ:
   
   mysqld_safe --skip-grant-tables &
   
   
3. Ëîãèíèìñÿ ê mysql-ñåðâåðó ïîä ðóòîì (ïàðîëü íå ñïðàøèâàþò):
   
   mysql -u root
   
   
4. Óñòàíàâëèâàåì íîâûé ïàðîëü äëÿ root:
   
   mysql> use mysql;
   
   mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
   mysql> flush privileges;
   mysql> quit
   
   
5. Îñòàíàâëèâàåì ñåðâåð mysql:
   
   /etc/init.d/mysql stop
   
   
6. Çàïóñêàåì åãî æå â íîðìàëüíîì ðåæèìå:
   
   /etc/init.d/mysql start
   
   
7. Ïðîâåðÿåì, ïóñòèò ëè íàñ ñ íàøèì ïàðîëåì:
   
   mysql -u root -p
   
   Ââîäèì ïàðîëü è ðàäóåìñÿ.

mysql -u root