Mqsql
Matthew Seaman
m.seaman at infracaninophile.co.uk
Sat Dec 6 12:01:36 GMT 2003
--E13BgyNx05feLLmH
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On Fri, Dec 05, 2003 at 10:09:08PM +0000, Paul Civati wrote:
> Frans Diergaarde <frans at blackadder.fastfury.org> wrote:
> =20
> > I have, stupid me, deleted root at localhost in the mysql server
> > so i have no access as root anymore.
> >=20
> > What can i do??
>=20
> If you have a non-localhost root ACL in there, then you may be able
> to connect via mysql -h host.name and it'll connect via TCP instead
> of local domain socket.
You should be able to recover using much the same procedure as for a
forgotten root password:
http://www.mysql.com/doc/en/Resetting_permissions.html
Use the second variant via the 'mysql' client rather than
'mysqladmin', but replace the UPDATE command in instruction 3 with:
mysql> GRANT ALL PRIVILEGES ON *.* TO root at localhost
-> IDENTIFIED BY 'somepass' WITH GRANT OPTION ;
mysql> FLUSH PRIVILEGES ;
You can also hunt through the mysql source tarball for the
mysql_install_db script which shows how to set up the default
privilege settings.
Cheers,
Matthew=09
--=20
Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks
Savill Way
PGP: http://www.infracaninophile.co.uk/pgpkey Marlow
Tel: +44 1628 476614 Bucks., SL7 1TH UK
--E13BgyNx05feLLmH
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (FreeBSD)
iD8DBQE/0cUgdtESqEQa7a0RAu7PAKCAAZB/g2ROkBfGGedNEGFPFqFDdwCeNuv9
pnBYKhQFNfk9gjINtxeLWkA=
=5R73
-----END PGP SIGNATURE-----
--E13BgyNx05feLLmH--
More information about the Ukfreebsd
mailing list