psa.db_users

Overview
The db_users table contains the database users for the databases on the server.

Column Descriptions
id – primary key that is automatically incremented
login – username for the database user
account_id – links to id in accounts table
db_id – links to id in data_bases table

Table Structure

CREATE TABLE `db_users` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `login` varchar(16) character set ascii collate ascii_bin NOT NULL default '',
 `account_id` int(10) unsigned NOT NULL default '0',
 `db_id` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `db_id` (`db_id`,`login`),
 KEY `account_id` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=latin1

Related documentation