Date: Sat, 29 Oct 2005 13:32:56 -0400 From: John DeStefano <john.destefano@gmail.com> To: freebsd-questions@freebsd.org Subject: reusing existing mysql permissions/dbs/tables after update Message-ID: <f2160e0d0510291032g7d729ba5l160806805e48c39e@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
mysql was among the many ports I just upgraded, and (of course) I can now no longer connect using mysql or mysqladmin. I've tried just about every method I've found including starting the daemon with the --skip-grant-tables option to reset the password (which has worked in the past), and most every other suggestion listed in section 5.7.8 of the MySQL reference manual. It seems like running the mysql_install_db script might do the trick... but if I understand correctly, running this script will re-initialize the grant tables... correct? Is there another way of regaining access to mysql, without losing the current relationships between dBs/tables and their users? Or, how can I get to the current grant information (in human-readable format), so that I can restore it later? Thank you, ~John # uname -a FreeBSD zurg.thedestefanos.com 5.4-STABLE FreeBSD 5.4-STABLE #0: Mon Oct 24 22:27:33 EDT 2005 =20 root@zurg.thedestefanos.com:/usr/obj/usr/src/sys/MYKERNEL i386 # pkg_info | grep mysql mysql-client-5.0.15 Multithreaded SQL database (client) mysql-server-5.0.15 Multithreaded SQL database (server) php5-mysql-5.0.5_1 The mysql shared extension for php
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?f2160e0d0510291032g7d729ba5l160806805e48c39e>