# man > Apache::Session::MySQL

---
type: CommandReference
command: Apache::Session::MySQL
mode: perldoc
section: 3pm
source: perldoc
---

## Quick Reference

- `tie %hash, 'Apache::Session::MySQL', $id, { DataSource => 'dbi:mysql:sessions', UserName => $db_user, Password => $db_pass, LockDataSource => 'dbi:mysql:sessions', LockUserName => $db_user, LockPassword => $db_pass }` — Tie a session using new database handles
- `tie %hash, 'Apache::Session::MySQL', $id, { Handle => $dbh, LockHandle => $dbh }` — Tie a session using existing database handles

## Name

Apache::Session::MySQL — An implementation of Apache::Session using MySQL storage and locking

## Synopsis

perl
use Apache::Session::MySQL;

# If you want Apache::Session to open new DB handles:

tie %hash, 'Apache::Session::MySQL', $id, {
    DataSource => 'dbi:mysql:sessions',
    UserName   => $db_user,
    Password   => $db_pass,
    LockDataSource => 'dbi:mysql:sessions',
    LockUserName   => $db_user,
    LockPassword   => $db_pass
};

# Or, if your handles are already opened:

tie %hash, 'Apache::Session::MySQL', $id, {
    Handle     => $dbh,
    LockHandle => $dbh
};
## Parameters

- `DataSource` — DBI data source for session storage (e.g., `dbi:mysql:sessions`)
- `UserName` — Database username for session storage
- `Password` — Database password for session storage
- `LockDataSource` — DBI data source for locking (typically same as `DataSource`)
- `LockUserName` — Database username for locking
- `LockPassword` — Database password for locking
- `Handle` — Already-opened DBI database handle for session storage
- `LockHandle` — Already-opened DBI database handle for locking

## See Also

- [Apache::Session](https://metacpan.org/pod/Apache::Session)
- [Apache::Session::Store::MySQL](https://metacpan.org/pod/Apache::Session::Store::MySQL)
- [Apache::Session::Lock::MySQL](https://metacpan.org/pod/Apache::Session::Lock::MySQL)
- [Apache::Session::File](https://metacpan.org/pod/Apache::Session::File)
- [Apache::Session::Flex](https://metacpan.org/pod/Apache::Session::Flex)
- [Apache::Session::DB_File](https://metacpan.org/pod/Apache::Session::DB_File)
- [Apache::Session::Postgres](https://metacpan.org/pod/Apache::Session::Postgres)