Starting MySQL /usr/local/bin/safe_mysqld --user=mysql & /opt/local/bin/mysql5 /opt/local/lib/mysql5/bin/mysql BLOB & TEXT Types: ------------------ Large BLOB 4 GB Medium BLOB 16 MB BLOB 64 KB Tiny BLOB 255 B INTEGER Types: -------------- BIGINT Signed: -9223372036854775808 to 9223372036854775807. Unsigned: 0 to 18446744073709551615. INT Signed: -2147483648 to 2147483647. Unsigned: 0 to 4294967295. MEDIUMINT Signed: -8388608 to 8388607. Unsigned: 0 to 16777215. SMALLINT Signed: -32768 to 32767. Unsigned: 0 to 65535. Use signed or unsigned BIGINT for storing UNIX timestamps. mysql -u root -p show databases; use my_database; show tables; mysqldump --user [user name] --password=[password] [database name] > [dump file] mysqldump --user root --password=RuneLock69 wh_everythingceltic_com > wh_everythingceltic_com.sql mysql db_name < script.sql > output.tab mysql --user=root --password=FireBrand69 chat < chat.sql > chat.tab -e, --execute=name mysql --user=root --password=FireBrand69 -e "help contents" mysql --user=root --password=FireBrand69 -e "help Administration" mysql --user=root --password=FireBrand69 -e "help CREATE USER" mysql --user=root --password=FireBrand69 -e "help DESCRIBE" mysql --user=root --password=FireBrand69 -e "help GRANT" mysql --user=root --password=FireBrand69 -e "help GRANT TYPES" mysql --user=root --password=FireBrand69 -e "help RESTORE" mysql --user=root --password=FireBrand69 -e "help REVOKE" mysql --user=root --password=FireBrand69 -e "help SET PASSWORD" mysql --user=root --password=FireBrand69 -e "help Column Types" mysql --user=root --password=FireBrand69 -e "help Data Definition" mysql --user=root --password=FireBrand69 -e "help CREATE DATABASE" mysql --user=root --password=FireBrand69 -e "help Data Manipulation" mysql --user=root --password=FireBrand69 -e "help CHANGE MASTER TO" mysql --user=root --password=FireBrand69 -e "help LOAD DATA" mysql --user=root --password=FireBrand69 -e "help SHOW" mysql --user=root --password=FireBrand69 -e "help Functions" mysql --user=root --password=FireBrand69 -e "help FUNCTION" mysql --user=root --password=FireBrand69 -e "help Bit Functions" mysql --user=root --password=FireBrand69 -e "help Comparison operators" mysql --user=root --password=FireBrand69 -e "help Encryption Functions" mysql --user=root --password=FireBrand69 -e "help Information Functions" mysql --user=root --password=FireBrand69 -e "help Logical operators" mysql --user=root --password=FireBrand69 -e "help Miscellaneous Functions" mysql --user=root --password=FireBrand69 -e "help Geographic features" mysql --user=root --password=FireBrand69 -e "help Transactions" mysql --user=root --password=FireBrand69 -e "help ISOLATION" mysql --user=root --password=FireBrand69 -e "help LOCK" mysql --user=root --password=FireBrand69 -e "help SAVEPOINT" mysql --user=root --password=FireBrand69 -e "help START TRANSACTION" CREATE DATABASE IF NOT EXISTS db_name DROP DATABASE db_name CREATE USER user IDENTIFIED BY PASSWORD 'password' {{CRUD Create Read Update Delete = INSERT SELECT UPDATE DELETE}} REVOKE ALL ON *.* TO user IDENTIFIED BY PASSWORD 'password' GRANT ALL ON db_name.* TO user IDENTIFIED BY PASSWORD 'password'; REVOKE CREATE TEMPORARY TABLES; REVOKE PROCESS; REVOKE REPLICATION CLIENT; REVOKE REPLICATION SLAVE; REVOKE SHOW DATABASES; REVOKE SHUTDOWN; REVOKE SUPER; REVOKE GRANT OPTION; /opt/local/lib/mysql5/bin/mysql --user=SpiritPixie --password=SpiritLock -e "SHOW DATABASES" mysql --user=root --password=FireBrand69 -e "SELECT VERSION(), CURRENT_DATE" mysql --user=root --password=FireBrand69 -e "SELECT DATABASE()" mysql --user=root --password=FireBrand69 -e "SHOW TABLES" mysql --user=root --password=FireBrand69 -e "_____" mysql --user=root --password=FireBrand69 -e "_____" mysql --user=root --password=FireBrand69 -e "_____" mysql --user=root --password=FireBrand69 -e "_____" mysql --user=root --password=FireBrand69 -e "_____" mysql --user=root --password=FireBrand69 -e "_____" mysql --user=root --password=FireBrand69 -e "_____" mysql --user=root --password=FireBrand69 -e "_____" mysql --user=root --password=FireBrand69 -e "_____" `mysql --user=root --password=FireBrand69 -e "SHOW DATABASES"` `mysql --user=root --password=FireBrand69 -e "CREATE DATABASE IF NOT EXISTS $1"` `mysql --user=root --password=FireBrand69 --database=$1 < $1.sql` `mysql --user=root --password=FireBrand69 -e "SHOW TABLES FROM $1"` mysql --user=root --password=FireBrand69 -e "SHOW DATABASES" mysql --user=root --password=FireBrand69 -e "CREATE DATABASE IF NOT EXISTS chat" mysql --user=root --password=FireBrand69 -e "SHOW DATABASES" mysqlimport --user=root --password=FireBrand69 --local chat /home/mark/move/mysql/chat.sql mysql --user=root --password=FireBrand69 -e "DROP DATABASE chat" mysql --user=root --password=FireBrand69 -e "SHOW DATABASES" mysql --user=root --password=FireBrand69 -e "SHOW TABLES FROM chat" mysql --user=root --password=FireBrand69 -e "DESCRIBE DATABASE IF NOT EXISTS chat" mysql --user=root --password=FireBrand69 -e "SHOW DATABASES" mysqladmin --user=root --password=FireBrand69 create chat mysql --user=root --password=FireBrand69 -e "SHOW DATABASES" mysqlimport --user=root --password=FireBrand69 --local chat /home/mark/move/mysql/chat.sql mysql --user=root --password=FireBrand69 --database=chat < chat.sql mysql --user=root --password=FireBrand69 -e "SHOW TABLES FROM chat" mysql --user=root --password=FireBrand69 --database=chat -e "DESCRIBE message; DESCRIBE room; DESCRIBE session; DESCRIBE user" mysql --user=root --password=FireBrand69 -e "DROP DATABASE chat" mysql --user=root --password=FireBrand69 -e "DROP DATABASE wh_verbalwarrior_com_listmessenger" mysql --user=root --password=FireBrand69 -e "DROP DATABASE it_listmessenger" mysql --user=root --password=RuneLock69 -e "SHOW DATABASES" mysql --user=root --password=RuneLock69 -e "SHOW TABLES FROM mysql" mysql --user=root --password=RuneLock69 --database=mysql -e "SELECT * FROM db" mysql --user=root --password=RuneLock69 --database=mysql -e "SELECT * FROM user" /opt/local/bin/mysql5 v5.1.42 /opt/local/lib/mysql5/bin/mysql v5.1.42 mysql --user=root --password=ImpLock -e "SHOW DATABASES" mysql5 --user=admin --password=RuneLock69 -e "SHOW DATABASES" /opt/local/lib/mysql5/bin/mysql --user=root --password=RuneLock69 -e "SHOW DATABASES" mysqladmin --user=root --password=FireBrand69 processlist mysqladmin --user=root --password=FireBrand69 shutdown mysqladmin --user=root --password=FireBrand69 status mysqladmin --user=root --password=FireBrand69 variables mysqladmin --user=root --password=FireBrand69 version mysqlshow --user=root --password=FireBrand69 sqldump chat sqldump chpbproductions_com_cmsbase sqldump entertainersdirect_com sqldump flash_db sqldump imptech_net sqldump intranet sqldump it_accounts sqldump it_counter sqldump it_flashstuff sqldump it_listmessenger sqldump it_webcalendar sqldump john_db sqldump myFiles sqldump phpforflash sqldump phpmyadmin sqldump web_db sqldump wellofsouls_org_phpbb sqldump wellofsouls_org_site sqldump wh_amizetta_com sqldump wh_cinemacom_com sqldump wh_csnm sqldump wh_csnm_doctorsns sqldump wh_degenerate sqldump wh_deviantenthrall_com sqldump wh_dougtheslug_com sqldump wh_everythingceltic_com sqldump wh_expectingfitness_com sqldump wh_john sqldump wh_medopus_com sqldump wh_mistresssminx_com sqldump wh_raffertythepiper_com sqldump wh_sarynangel_com sqldump wh_steamwerx_com sqldump wh_sun4_com sqldump wh_the_high_priestess_com sqldump wh_theatricalcombat_com sqldump wh_thegwins_com_listmessenger sqldump wh_thegwins_survey sqldump wh_verbalwarrior_com sqldump wh_verbalwarrior_com_listmessenger sqldump wh_wellofsouls_org sqldump wh_whipenthusiasts_org