Comments on: Dangers of skip-grant-tables https://shlomi-noach.github.io/blog/mysql/dangers-of-skip-grant-tables Blog by Shlomi Noach Sun, 16 Feb 2014 17:01:06 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: MySQL忘记root密码–不重启mysqd重置root密码 | DBA的罗浮宫 https://shlomi-noach.github.io/blog/mysql/dangers-of-skip-grant-tables/comment-page-1#comment-231125 Sun, 16 Feb 2014 17:01:06 +0000 https://shlomi-noach.github.io/blog/?p=102#comment-231125 […] Dangers of skip-grant-tables […]

]]> By: sylar https://shlomi-noach.github.io/blog/mysql/dangers-of-skip-grant-tables/comment-page-1#comment-231120 Sun, 16 Feb 2014 04:11:19 +0000 https://shlomi-noach.github.io/blog/?p=102#comment-231120 Nice post！
if you only use skip-grant-tables, you can execute “flush privileges” and remove the skip-grant-tables form my.cnf to bring back the privileges system(mysql 5.6)。

if skip-networking is added to my.cnf, you have to restart the mysqld server.

]]> By: Tansu CABACI https://shlomi-noach.github.io/blog/mysql/dangers-of-skip-grant-tables/comment-page-1#comment-20546 Tue, 09 Nov 2010 07:37:19 +0000 https://shlomi-noach.github.io/blog/?p=102#comment-20546 Nicely .

]]> By: VirtualMinds » Blog Archiv » Restaurar password de root en MySQL https://shlomi-noach.github.io/blog/mysql/dangers-of-skip-grant-tables/comment-page-1#comment-7325 Sun, 29 Nov 2009 19:40:36 +0000 https://shlomi-noach.github.io/blog/?p=102#comment-7325 […] vía https://shlomi-noach.github.io/blog/?p=102 un par de formas de restaurar la contraseña de MySQL. Normalmente siempre se suele usar con la […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/dangers-of-skip-grant-tables/comment-page-1#comment-9 Thu, 13 Nov 2008 17:56:52 +0000 https://shlomi-noach.github.io/blog/?p=102#comment-9 Hi Scott,
I agree that the steps described in the manual seem somewhat overwhelming. I always found the init-file to be an easy and fast setup. The general practice, however, shows that people think otherwise.

Shlomi

]]> By: Scott https://shlomi-noach.github.io/blog/mysql/dangers-of-skip-grant-tables/comment-page-1#comment-8 Thu, 13 Nov 2008 13:46:45 +0000 https://shlomi-noach.github.io/blog/?p=102#comment-8 (psst…IDENTIFIED BY, not IDENTIFY BY)

The reason the latter approach is so popular is that everybody is able to make it work. Countless folks show up on #mysql on Freenode and say they’ve tried the init file and can’t make it work; we have them try the skip-grant-tables, and a minute later they’re in. I don’t know why the first method proves so difficult – maybe it’s because the manual shows it in 6 or 8 steps that scroll off the screen, but the skip-grant-tables is only 3 steps that all fit in one screen.

]]>