Date: Wed, 01 Oct 1997 02:45:39 -0700 (PDT) From: Donald Burr <dburr@POBoxes.com> To: FreeBSD Ports <freebsd-ports@freebsd.org>, FreeBSD Questions <freebsd-questions@freebsd.org> Subject: how to use mysql port/package Message-ID: <XFMail.971001025439.dburr@POBoxes.com>
next in thread | raw e-mail | index | archive | help
-----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 \*
<<same text as above>>
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 <dburr@POBoxes.com> - 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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?XFMail.971001025439.dburr>