cheat sheets.

Cheat Sheet Title: [ no_spaces_alphanumeric_only ]

Cheat Sheet:
To create a database: $ mysqladmin -u root create <database_name> ---- To CREATE a database and assign rights to a NEW user. Useful when starting a new Rails app, especially when you aren't using root:empty password. $ mysql --user=root msql> CREATE DATABASE <database_name>; msql> USE <database_name>; msql> GRANT ALL PRIVILEGES ON *.* TO '<new_user>'@'localhost' IDENTIFIED BY '<new_user_password>' WITH GRANT OPTION; msql> quit; ---- To DELETE a database: msql> DROP DATABASE <database_name>; --- To DELETE a row msql> DELETE FROM MYTABLE where <column_name>=1; ---- Show databases, connect, show tables and table schema msql> SHOW DATABASES; msql> CONNECT <database_name>; msql> SHOW TABLES; msql> DESC <table_name>; ---- To create and grant all privileges to a user mysql> grant all privileges on some_db.* to 'someuser'@'localhost' identified by 'somepassword'; mysql> flush privileges; ---- To SET a user password mysql> use mysql; mysql> update user set Password = PASSWORD('<password>') where host='<host_name>' and user='<user_name>'; mysql> flush privileges; mysql> exit $ mysqladmin -uroot -p<password> reload ---- To rename a column mysql> ALTER TABLE <table_name> change <old_col_name> <new_col_name> <data_type>; ---- To dump a database into an sql-text file $ mysqldump --opt -u username -p database > database_backup.sql --- To load a dump file into a database $ mysql -u username -p database < dump_file.sql ---- To reset the root password to the original empty password: Use the commandline tool mysqladmin - the trick is to use 2 single-quotes (ticks) to specify an empty password: Linux: Note: you probably need to run this from the mysql bin dir: $ cd /usr/local/mysql/bin $ ./mysqladmin -uroot -p<existing_password> password '' Windows: Note: Use 2 double-quotes (windows doesn't trim out the single-quotes). If you ran the Linux version ('') your password is now two single-quotes. > mysqladmin -uroot -p<existing_password> password "" To be prompted for password: omit <existing_password>, but include the -p arg. ---- Display as table mysql> select * from queries order by id desc limit 1 \G

Your cheat sheet will be editable (fixable) by anyone. Each cheat sheet is essentially a wiki page. It may also be used by millions of people for reference purposes from the comfort of their command line. If this is okay with you, please save.