![]() ![]() SELECT table_schema, table_name FROM information_schema. SELECT table_schema,table_name FROM information_schema.tables WHERE table_schema != 'mysql' AND table_schema != 'information_schema' SELECT table_schema, table_name, column_name FROM information_lumns WHERE table_schema != 'mysql' AND table_schema != 'information_schema' SELECT schema_name FROM information_schema.schemata - for MySQL >= v5.0 SELECT host, user FROM er WHERE Super_priv = 'Y' # priv These are the most commonly used MySQL commands and statements that will help you work with MySQL. SELECT grantee, privilege_type, is_grantable FROM information_er_privileges WHERE privilege_type = 'SUPER' MYSQL Cheatsheet a quick and easy way to memorize MYSQL code. This command allows us to connect with MySQL Server with a username and passwords using below syntax. ![]() SELECT table_schema, table_name, column_name, privilege_type FROM information_lumn_privileges - list privs on columns MySQL Cheat Sheet includes the following contents: - Data Types - Creating and Modifying Databases and Tables - Syntax of SELECT queries - Joins - String. ![]() SELECT grantee, table_schema, privilege_type FROM information_schema.schema_privileges - list privs on databases (schemas) Some SL languages, like SQL Server, use for assignment, while others like MySQL and Postgres use. SELECT host, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv FROM er - priv, list user privs SELECT grantee, privilege_type, is_grantable FROM information_er_privileges - list user privs John the Ripper will crack MySQL password hashes. SELECT host, user, password FROM er - priv ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |