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

  • Enable AMDGPU Linux Driver
  • apache symlinks denied even with followsymlinks
  • chown how to change ownership on a symlink
  • how to use ifplugd in Linux to execute a command or script when a NIC cable is unplugged or plugged in
  • dd how to backup and restore disk images including compression with gzip
  • mpv / mplayer with Radeon / AMD GPU Video Card Driver enable VDPAU GPU Accelerated Video Decoding
  • Wordpress Reset Blog User Password from MySQL Using Linux Bash and not PHPMyadmin
  • Ubuntu Linux Mint Debian xorg performance and tear-free tuning for AMD Radeon Based Cards
  • Centos 7 Stopped and Disabled Firewalld and ports still blocked
  • MariaDB / MySQL Reset Root Forgotten Password on Centos 7
  • Centos 7 How to install Mysql/Mariadb
  • PHP 7.2, Apache and Centos 7 How To Install
  • Ubuntu Debian Linux Mint r8169 r8168 Network Driver Problem and Solution
  • Linux 3D Performance benchmarks with glxgears 59-60fps solution
  • How To Install Asterisk 16 17 on Debian Ubuntu Linux
  • Linux Ubuntu Debian Centos How To Make a Bootable Windows 7, 8, 10, 2016, 2019 Server USB from ISO
  • How To Restore Windows MBR Bootsector from Linux using syslinux
  • Linux Ubuntu Cannot Print Large Images
  • Cannot Print PDF Solution and Howto Resize
  • Linux Console Login Screen TTY Change Message