15
Май
0
Сброс пароля root для mysql в CentOS
Сброс , замена забытого, потерянного пароля root от MySQL server на CENTOS 6
Записки, заметки для сисадмина.
service mysqld stop
mysqld_safe —skip-grant-tables &
точнее /usr/bin/mysqld_safe --skip-grant-tables --user=root &
mysql -u root
UPDATE mysql.user SET Password=PASSWORD(‘newpascode’) WHERE User=’root';
FLUSH PRIVILEGES;
quit;
killall -9 -r mysqld
service mysqld restart
Enjoyed reading this post?
Subscribe to the RSS feed and have all new posts delivered straight to you.
Subscribe to the RSS feed and have all new posts delivered straight to you.