AO Logo
 
  
  
  
MySQL Users
AO
AO Industries, Inc.
Application Infrastructure ProviderApplication Infrastructure Provider
Sign UpWhat's NewClient AreaContact UsSite Map
 
your location:   home page ··· aoserv platform ··· software components ··· aoserv client ··· tables ··· table definitions ··· mysql users

TABLE NAME

mysql_users

DESCRIPTION

The mysql_users table stores all of the user info that is common for every MySQL server a user has a MySQL user account on. The server specifics are stored in the mysql_server_users table.

COLUMNS

columntypenulluniquereferencesreferenced_bysince_versiondescription
usernamemysql_usernamefalsetrueusernames.usernamemysql_server_users.username1.80.0the username of the MySQL user
select_privbooleanfalsefalse1.0a100the SELECT privilege to all databases
insert_privbooleanfalsefalse1.0a100the INSERT privilege to all databases
update_privbooleanfalsefalse1.0a100the UPDATE privilege to all databases
delete_privbooleanfalsefalse1.0a100the DELETE privilege to all databases
create_privbooleanfalsefalse1.0a100the CREATE privilege to all databases
drop_privbooleanfalsefalse1.0a100the DROP privilege to all databases
reload_privbooleanfalsefalse1.0a100the RELOAD privilege to all databases
shutdown_privbooleanfalsefalse1.0a100the SHUTDOWN privilege to all databases
process_privbooleanfalsefalse1.0a100the PROCESS privilege to all databases
file_privbooleanfalsefalse1.0a100the FILE privilege to all databases
grant_privbooleanfalsefalse1.0a100the GRANT privilege to all databases
references_privbooleanfalsefalse1.0a100the REFERENCES privilege to all databases
index_privbooleanfalsefalse1.0a100the INDEX privilege to all databases
alter_privbooleanfalsefalse1.0a100the ALTER privilete to all databases
show_db_privbooleanfalsefalse1.0a111
super_privbooleanfalsefalse1.0a111
create_tmp_table_privbooleanfalsefalse1.0a111
lock_tables_privbooleanfalsefalse1.0a111
execute_privbooleanfalsefalse1.0a111
repl_slave_privbooleanfalsefalse1.0a111
repl_client_privbooleanfalsefalse1.0a111
create_view_privbooleanfalsefalse1.4
show_view_privbooleanfalsefalse1.4
create_routine_privbooleanfalsefalse1.4
alter_routine_privbooleanfalsefalse1.4
create_user_privbooleanfalsefalse1.4
event_privbooleanfalsefalse1.54the Event_priv
trigger_privbooleanfalsefalse1.54the Trigger_priv
disable_logfkeytruefalsedisable_log.pkey1.0a100indicates that this account is disabled