Всем привет!
Иногда бывает необходимость сбросить пароль суперпользователя (root) MySQL. Обычно по причине забывчивости системных администраторов.
Итак, чтобы сбросить пароль root в MySQL необходимо выполнить несколько шагов.
Останавливаем mysql:
# service mysql stop
Запускаем mysql следующей командой:
# /usr/bin/mysqld_safe --skip-grant-tables --user=root &
Запускаем клиента mysql:
# mysql -u root
Выполняем sql запрос:
UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root'; где new_password – новый пароль.
Применяем изменения:
FLUSH PRIVILEGES;
Выходим из mysql клиента выполнив в нем команду exit.
Перегружаем mysql сервер:
# service mysql restart
Вот и все, пароль успешно сброшен.
(Первоначальный автор: Hub-lex)
Joomla! Debug Console
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
session.token ⇒ d4cc5a697dd7f03881a8e4d8e2033a9f
3.81 MB (3,998,992 Bytes)
12 Queries Logged
DELETE
FROM `j25_session`
WHERE `time` < '1753317407'SELECT `session_id`
FROM `j25_session`
WHERE `session_id` = 'cb58ca6ea3c852497601b48b485f540f'
LIMIT 0, 1INSERT INTO `j25_session`
(`session_id`, `client_id`, `time`)
VALUES
('cb58ca6ea3c852497601b48b485f540f', 0, '1753320107')SELECT b.id
FROM j25_usergroups AS a
LEFT JOIN j25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `j25_viewlevels`SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM j25_menu AS m
LEFT JOIN j25_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSHOW FULL COLUMNS
FROM `j25_easyblog_configs`SELECT *
FROM j25_easyblog_configs
WHERE `name` = 'config'SHOW FULL COLUMNS
FROM `j25_easyblog_post`SELECT a.`id`
FROM j25_easyblog_post as a
WHERE a.`permalink` = 'sbros:parolya-root-v-mysql'SELECT a.`id`
FROM j25_easyblog_post as a
WHERE a.`permalink` = 'sbros-parolya-root-v-mysql'SELECT *
FROM j25_easyblog_post
WHERE `id` = '497'
11 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT a.`id`
FROM j25_easyblog_post as a1 × SELECT *
FROM j25_easyblog_post1 × SELECT *
FROM j25_easyblog_configs1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM j25_menu AS m
LEFT JOIN j25_extensions AS e
ON m.component_id = e.extension_id1 × SELECT b.id
FROM j25_usergroups AS a
LEFT JOIN j25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `j25_viewlevels1 × SELECT `session_id`
FROM `j25_session`
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `j25_easyblog_post1 × SHOW FULL COLUMNS
FROM `j25_easyblog_configs1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
VALUES ('cb58ca6ea3c852497601b48b485f540f', 0, '1753320107'1 × DELETE
FROM `j25_session`