From owner-freebsd-ports Wed Oct 1 02:55:20 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id CAA03231 for ports-outgoing; Wed, 1 Oct 1997 02:55:20 -0700 (PDT) Received: from DonaldBurr.dyn.ml.org (dburr@ppp11217.la.inreach.net [206.18.113.217]) by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id CAA03204; Wed, 1 Oct 1997 02:55:10 -0700 (PDT) Received: (from dburr@localhost) by DonaldBurr.dyn.ml.org (8.8.5/8.8.5) id CAA01167; Wed, 1 Oct 1997 02:54:40 -0700 (PDT) Message-ID: X-Mailer: XFMail 1.1 [p0] on FreeBSD Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit MIME-Version: 1.0 Date: Wed, 01 Oct 1997 02:45:39 -0700 (PDT) Organization: Starfleet Command From: Donald Burr To: FreeBSD Ports , FreeBSD Questions Subject: how to use mysql port/package Sender: owner-freebsd-ports@freebsd.org X-Loop: FreeBSD.org Precedence: bulk -----BEGIN PGP SIGNED MESSAGE----- I'd like to get the mysql package or port working, but have had no success so far. I have tried both the package and the port (both in FreeBSD-current). Basically, I am always getting "access denied" when accessing any database, as any user (even root). The MySQL faq (installed in /usr/local/share/doc/mysql) was less than helpful. In fact, it provided NO information to help me even get started fixing this problem. I had to go to the mysql tarball for that: the file INSTALL-BINARY in said tarball mentions a "mysql_install_db" script that is to be run if you wish to reset all of the databases and permissions to the default (which specify that root has access to everything). It says to remove all of the /var/db/mysql/mysql/*.{ISD,ISM} files then run the mysql_install_db script. I tried this several times, but it does not help. I still get "access denied" messages, such as: # try to access the "test" database [root@DonaldBurr:120 ~]# mysql test ERROR: Access denied # get root's access permissions on the test database [root@DonaldBurr:121 ~]# mysqlaccess root test mysqlaccess Version 1.2-3, 16 Jun 1997 By RUG-AIV, by Yves Carlier (Yves.Carlier@rug.ac.be) This software come with ABSOLUTELY NO WARRANTY. Sorry, An error occurred when trying to connect to the database with the grant-tables: * Maybe YOU do not have READ-access to this database? * If you used the -U option, you may have supplied an invalid username? for the superuser? * If you used the -U option, it may be possible you have to supply a superuser-password to, with the -P option? * If you used the -P option, you may have supplied an invalid password? # get root's access permissions on all databases [root@DonaldBurr:122 ~]# mysqlaccess root \* <> If anyone can shed some light on this, I would very much appreciate a (Private) e-mail from you. I will be happy to summarize to the group the responses that I receive. Many thanks in advance for your assistance. Donald Burr - Ask me for my PGP key | PGP: Your WWW HomePage: http://DonaldBurr.base.org/ ICQ #1347455 | right to Address: P.O. Box 91212, Santa Barbara, CA 93190-1212 | 'Net privacy. Phone: (805) 957-9666 FAX: (800) 492-5954 | USE IT. -----BEGIN PGP SIGNATURE----- Version: 2.6.2 iQCVAwUBNDId3vjpixuAwagxAQEX3gQAm50albwNZg5+J2BurdmdCFo+bKO8pZeT 5+jkjMyqRS7TRbjtAdmT3C8itjNv0vKem211LZn7ug9ZrQimPpO1Lxy1eJogbvbE /OaQYLHMfcRlDFFWgLaTUEnBJmJ3NRvbNIom5p6zK+RzZGsZcYbq/lQitVpRzdXY y4SE4I7RRFw= =5Kr6 -----END PGP SIGNATURE-----