FreeBSD Security Advisory: FreeBSD-SA-00:05.mysql322-server

FreeBSD Security Officer security-officer at
Mon Feb 28 21:26:55 PST 2000


FreeBSD-SA-00:05                                           Security Advisory
                                                                FreeBSD, Inc.

Topic:          MySQL allows bypassing of password authentication

Category:       ports
Module:         mysql322-server
Announced:      2000-02-28
Affects:        Ports collection before the correction date.
Corrected:      2000-02-15
FreeBSD only:   NO

I.   Background

MySQL is a popular SQL database client/server distributed as part of the
FreeBSD ports collection.

II.  Problem Description

The MySQL database server (versions prior to 3.22.32) has a flaw in the
password authentication mechanism which allows anyone who can connect to
the server to access databases without requiring a password, given a valid
username on the database - in other words, the normal password
authentication mechanism can be completely bypassed.

MySQL is not installed by default, nor is it "part of FreeBSD" as such: it
is part of the FreeBSD ports collection, which contains over 3100
third-party applications in a ready-to-install format.

FreeBSD makes no claim about the security of these third-party
applications, although an effort is underway to provide a security audit
of the most security-critical ports.

III. Impact

The successful attacker will have all of the access rights of that
database user and may be able to read, add or modify records.

If you have not chosen to install the mysql322-server port/package, then
your system is not vulnerable.

IV.  Workaround

Use appropriate access-control lists to limit which hosts can initiate
connections to MySQL databases - see:

for more information. If unrestricted remote access to the database is not
required, consider using ipfw(8) or ipf(8), or your network perimeter
firewall, to prevent remote access to the database from untrusted machines
(MySQL uses TCP port 3306 for network communication). Note that users who
have access to machines which are allowed to initiate database connections
(e.g. local users) can still exploit the security hole.

V.   Solution

One of the following:

1) Upgrade your entire ports collection and rebuild the mysql322-server

2) Reinstall a new package obtained from:

3) download a new port skeleton for the mysql322-server port from:

and use it to rebuild the port.

4) Use the portcheckout utility to automate option (3) above. The
portcheckout port is available in /usr/ports/devel/portcheckout or the
package can be obtained from:

Version: 2.6.2


This is the moderated mailing list freebsd-announce.
The list contains announcements of new FreeBSD capabilities,
important events and project milestones.
See also the FreeBSD Web pages at

To Unsubscribe: send mail to majordomo at
with "unsubscribe freebsd-announce" in the body of the message

More information about the freebsd-announce mailing list