# perldoc > CGI::Session::Driver::mysql

---
type: CommandReference
command: CGI::Session::Driver::mysql
mode: perldoc
section: 
source: perldoc
---

## Quick Reference

- `CGI::Session->new( 'driver:mysql', $sid )` — Use default connection
- `CGI::Session->new( 'driver:mysql', $sid, { DataSource => 'dbi:mysql:test', User => 'sherzodr', Password => 'hello' } )` — Specify credentials
- `CGI::Session->new( 'driver:mysql', $sid, { Handle => $dbh } )` — Use existing database handle
- `CGI::Session->new( 'driver:mysql', undef, { TableName => 'session', IdColName => 'my_id', DataColName => 'my_data', DataSource => 'dbi:mysql:project' } )` — Custom column names
- `CGI::Session->new( 'driver:mysql', $sid, { DataSource => 'shopping_cart' } )` — Omit `dbi:mysql:` prefix
- Use `$session->table_name('new_name')` to change table name after creation

## Name

`CGI::Session::Driver::mysql` — CGI::Session driver for MySQL database

## Synopsis

perl
$s = CGI::Session->new( 'driver:mysql', $sid);
$s = CGI::Session->new( 'driver:mysql', $sid, { DataSource => 'dbi:mysql:test',
                                                  User       => 'sherzodr',
                                                  Password   => 'hello' });
$s = CGI::Session->new( 'driver:mysql', $sid, { Handle => $dbh } );
## Options

- `DataSource` — DBI data source (e.g., `dbi:mysql:test`). Leading `dbi:mysql:` may be omitted.
- `User` — Database username
- `Password` — Database password
- `Handle` — Existing database handle (`$dbh`)
- `TableName` — Session table name (default: `sessions`)
- `IdColName` — Session ID column name (default: `id`)
- `DataColName` — Session data column name (default: `a_session`)

## Examples

Create the session table (session ID column must be primary key or unique):

sql
CREATE TABLE sessions (
    id CHAR(32) NOT NULL PRIMARY KEY,
    a_session TEXT NOT NULL
);
Use custom column names:

perl
$s = CGI::Session->new('driver:mysql', undef,
{
    TableName   => 'session',
    IdColName   => 'my_id',
    DataColName => 'my_data',
    DataSource  => 'dbi:mysql:project',
});
## See Also

- [CGI::Session](https://metacpan.org/pod/CGI::Session)
- [CGI::Session::Driver::DBI](https://metacpan.org/pod/CGI::Session::Driver::DBI)
- [CGI::Session::Driver](https://metacpan.org/pod/CGI::Session::Driver)