MySQL Cheatsheet Guide and Tutorial

Create Database:

create database yourdbname;

Show All Databases:

show databases;

Change Database:

use mysql;



Drop / Delete a MySQL Database:

drop database nameofyourdatabase;


mysql> drop database cardb;
Query OK, 1 row affected (0.10 sec)

 

How To Dump The Table Structure SQL Code:

show create table yourtablename;

View tables in database:

show tables;

View table structure:

describe yourtablename;

How To Change a Column Field:

Make sure you edit what is in bold to suit your table name, column name and type (eg. int, varchar, text).

alter table yourtable modify column columname int;

 

Create a new user and password for your database:

myfirstdb is the name of your database and the .* grants the same privileges to all tables (you could fine tune this by replacing the * with a table name).

yourusername is the username

yourpassword is the password

After grant are the privileges, if you want to give them full access you could just use "GRANT ALL" or if you want to restrict them to only reading you could just use "GRANT SELECT" and any other number of options that meet your needs for security.

GRANT SELECT, INSERT, DELETE on myfirstdb.* to yourusername@localhost IDENTIFIED BY 'yourpassword';


Tags:

mysql, cheatsheet, tutorialcreate, database, yourdbname, databases, delete, nameofyourdatabase, cardb, query, ok, sql, yourtablename, column, edit, bold, eg, int, varchar, text, alter, yourtable, modify, columname, user, password, myfirstdb, grants, privileges, replacing, yourusername, username, yourpassword, quot, restrict, select, insert, localhost, identified,

Latest Articles

  • How To Install OpenProject on Centos 7 Step-by-Step Guide
  • Ubuntu Debian Linux Cannot Install Wine Solution - wine1.6 : Depends: wine1.6-i386 (= 1:1.6.2-0ubuntu14.2) but it is not installable wine1.4 : Depends: wine1.6 but it is not going to be installed
  • How To Install python 3.4 3.5 and up on Linux with wine - Working Solution
  • using Xvfb on virtual remote ssh server to have X graphical programs work
  • ssh Received disconnect from port 22:2: Too many authentication failures
  • named bind errors - DNSKEY: unable to find a DNSKEY which verifies the DNSKEY RRset and also matches a trusted key for '.'
  • OpenVZ vs LXC DIR mode poor security in LXC
  • httpd: Syntax error on line 221 of /etc/httpd/conf/httpd.conf: Syntax error on line 6 of /etc/httpd/conf.d/php.conf: Cannot load modules/libphp5.so into server: /lib64/libresolv.so.2: symbol __h_errno, version GLIBC_PRIVATE not defined in file libc.s
  • Radeon R3 GPU on Debian Crashing
  • MySQL 5.7 on Debian and Ubuntu - How To Reset Root Password
  • SSH and sshfs timeout settings keepalive
  • Linux How To Add User To Additional Group
  • Howto Set Static IP on boot in initramfs for dropbear or other purposes NFS, Linux, Debian, Ubuntu, CentOS
  • Convert and install to LUKS Encrypted Drive Ubuntu 18.04 19.10 Linux Mint and Debian Based Linux
  • Debian and Netplan
  • CentOS 8 how to restart the network!
  • CentOS 8 how to convert to a bootable mdadm RAID software array
  • ADATA USB Thumb Drive Issues
  • KMODE EXCEPTION NOT HANDLED - QEMU/KVM Won't Boot Windows 2016 or 10 Image or Physical Machine
  • Linux Mint / Ubuntu / Debian Mate Disable Guest Session and Hide Usernames on Lightdm Login screen GUI