GeoServer does not come built-in with support for MySQL; it must be installed through an extension. Proceed to Installing the MySQL extension for installation details.
Currently the MySQL extension is unmaintained and carries unsupported status. While still usable, do not expect the same reliability as with other extensions.
MySQL is an open source relational database with some limited spatial functionality.
Installing the MySQL extension¶
Download the MySQL extension from the GeoServer download page.
Make sure to match the version of the extension to the version of the GeoServer instance!
Extract the contents of the archive into the WEB-INF/lib directory of the GeoServer installation.
Adding a MySQL database¶
Once the extension is properly installed MySQL will show up as an option when creating a new data store.
Configuring a MySQL data store¶
|host||The mysql server host name or ip address.|
|port||The port on which the mysql server is accepting connections.|
|database||The name of the database to connect to.|
|user||The name of the user to connect to the mysql database as.|
|password||The password to use when connecting to the database. Left blank for no password.|
|Connection pool configuration parameters. See the Database Connection Pooling section for details.|