ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)<\/div>\n<\/div>\n
<\/p>\n
<\/p>\n
1 Stop MySQL server:<\/p>\n
# service mysql start<\/p>\n
<\/p>\n
2. Add –skip-grant-tables to your mysql start script<\/p>\n
# nano \/etc\/rc3.d\/S20mysql<\/p>\n
<\/p>\n
——————-<\/p>\n
<\/p>\n
case "${1:-''}" in<\/div>\n
'start')<\/div>\n
sanity_checks;<\/div>\n
# Start daemon<\/div>\n
log_daemon_msg "Starting MySQL database server" "mysqld"<\/div>\n
if mysqld_status check_alive nowarn; then<\/div>\n
log_progress_msg "already running"<\/div>\n
log_end_msg 0<\/div>\n
else<\/div>\n
# Could be removed during boot<\/div>\n
test -e \/var\/run\/mysqld || install -m 755 -o mysql -g root -d \/var\/run\/mysqld<\/div>\n
<\/div>\n
# Start MySQL!<\/div>\n
\/usr\/bin\/mysqld_safe
–skip-grant-tables<\/span> > \/dev\/null 2>&1 &<\/div>\n <\/div>\n
# 6s was reported in #352070 to be too few when using ndbcluster<\/div>\n
for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do<\/div>\n
———————<\/div>\n
<\/div>\n
<\/p>\n
3. Start your server again<\/p>\n
<\/p>\n
# service -mysql start<\/p>\n
<\/p>\n
4. Log in using mysql root user without entering a password:<\/p>\n
# mysql -u root mysql<\/p>\n
<\/p>\n
And let's do the actual reset:<\/p>\n
<\/p>\n
——-<\/p>\n
<\/p>\n
Reading table information for completion of table and column names<\/div>\n
You can turn off this feature to get a quicker startup with -A<\/div>\n
<\/div>\n
Welcome to the MySQL monitor. Commands end with ; or \\g.<\/div>\n
Your MySQL connection id is 35<\/div>\n
Server version: 5.1.49-3 (Debian)<\/div>\n
<\/div>\n
Copyright (c) 2000, 2010, Oracle and\/or its affiliates. All rights reserved.<\/div>\n
This software comes with ABSOLUTELY NO WARRANTY. This is free software,<\/div>\n
and you are welcome to modify and redistribute it under the GPL v2 license<\/div>\n
<\/div>\n
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<\/div>\n
<\/div>\n
mysql> update user set password=Password('1234') where user='root';<\/div>\n
Query OK, 1 row affected (0.00 sec)<\/div>\n
Rows matched: 1 Changed: 1 Warnings: 0<\/div>\n
<\/div>\n
mysql> flush privileges;<\/div>\n
Query OK, 0 rows affected (0.00 sec)<\/div>\n
<\/div>\n
mysql> exit<\/div>\n
Bye<\/div>\n
<\/div>\n
——————<\/div>\n
<\/div>\n
5. Stop the server one more time<\/div>\n
<\/div>\n
# service mysql stop<\/div>\n
<\/div>\n
6. Remove –skip-grant-table from your mysql startup command<\/div>\n
<\/div>\n
# nano \/etc\/rc3.d\/S20mysql<\/div>\n
<\/div>\n
<\/div>\n
7. Start your mysqlserver<\/div>\n
<\/div>\n
# service mysql start<\/div>\n
<\/div>\n
<\/div>\n
8. Enjoy your server:<\/div>\n
<\/div>\n
<\/div>\n
———————-<\/div>\n
\n
root@debian:~# mysql -u root -p<\/div>\n
Enter password:<\/div>\n
Welcome to the MySQL monitor. Commands end with ; or \\g.<\/div>\n
Your MySQL connection id is 35<\/div>\n
Server version: 5.1.49-3 (Debian)<\/div>\n
<\/div>\n
Copyright (c) 2000, 2010, Oracle and\/or its affiliates. All rights reserved.<\/div>\n
This software comes with ABSOLUTELY NO WARRANTY. This is free software,<\/div>\n
and you are welcome to modify and redistribute it under the GPL v2 license<\/div>\n
<\/div>\n
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<\/div>\n
<\/div>\n
mysql><\/div>\n
————————-<\/div>\n
<\/div>\n<\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
# mysql -u root Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) # mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 1 Stop MySQL server: # service mysql start… Continue reading → <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[253,287,295],"class_list":["post-683","post","type-post","status-publish","format-standard","hentry","category-linux","tag-mysql","tag-recover","tag-root-password"],"_links":{"self":[{"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/posts\/683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/comments?post=683"}],"version-history":[{"count":0,"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/posts\/683\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/media?parent=683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/categories?post=683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.portnumber53.com\/index.php\/wp-json\/wp\/v2\/tags?post=683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}