MySQL/MariaDB Reference - Revision history

Support at 22:52, 13 June 2017

2017-06-13T22:52:00Z

Support at 22:51, 13 June 2017

2017-06-13T22:51:16Z

Support at 22:50, 13 June 2017

2017-06-13T22:50:19Z

Support at 22:49, 13 June 2017

2017-06-13T22:49:07Z

Support at 22:45, 13 June 2017

2017-06-13T22:45:32Z

Support at 21:39, 13 June 2017

2017-06-13T21:39:11Z

Support at 21:38, 13 June 2017

2017-06-13T21:38:33Z

Support: Created page with "List Databases mysql> show databases; List Tables mysql> show tables; Change Passwords # mysqladmin -u root password 'new-password' Note: the mysqladmin command..."

2017-05-19T21:17:34Z

Created page with "*List Databases* mysql> show databases; *List Tables* mysql> show tables; *Change Passwords* # mysqladmin -u root password 'new-password' Note: the mysqladmin command..."

New page

*List Databases*
mysql> show databases;

*List Tables*
mysql> show tables;

*Change Passwords*
# mysqladmin -u root password 'new-password'
Note: the mysqladmin command should be run from a shell script, so as to not have this critical password exposed in the command history - make sure to delete the shell script after running

*Delete Database*
mysql> drop database test;

*Creating a new DB and assigning permissions*

Command line/scripted
# mysqladmin -p create wikidb
# echo "grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';" | mysql -p
Note: the echo command should be run from a shell script, so as to not have a critical password exposed in the command history - make sure to delete the shell script after running

mySQL command line - note: this is added to the mysql command history (not a good idea to leave the password exposed):
# mysql -p
mysql> create database wikidb;
mysql> grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';

*Delete From Table*
*Table Structure*
*View Data (Some Query Examples)*

@@ Line 30: / Line 30: @@
   select * from user;
   select Host,User,Grant_priv from user;
   select * from SystemEvents where SysLogTag='CROND';
   select * from SystemEvents limit 5;

@@ Line 19: / Line 19: @@
    # echo "grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';" | mysql -p
-mySQL command line - note: this is added to the mysql command history (not a good idea to leave the password exposed):
+mySQL command line<br>
    # mysql -p
    mysql> create database wikidb;

@@ Line 5: / Line 5: @@
    mysql> show tables;
-*Change Passwords
+*Change Passwords<br>
 Note: the mysqladmin command should be run from a shell script, so as to not have this critical password exposed in the command history (preferred/more secure method) - make sure to delete the shell script after running
    # mysqladmin -u root password 'new-password'
@@ Line 14: / Line 14: @@
 *Creating a new DB and assigning permissions
-Command line/scripted
+Command line/scripted<br>
 Note: the echo command should be run from a shell script, so as to not have a critical password exposed in the command history (preferred/more secure method) - make sure to delete the shell script after running
    # mysqladmin -p create wikidb
@@ Line 40: / Line 40: @@
 *Delete From Table

@@ Line 1: / Line 1: @@
-*List Databases*
+*List Databases
    mysql> show databases;
-*List Tables*
+*List Tables
    mysql> show tables;
-*Change Passwords*
+*Change Passwords
    # mysqladmin -u root password 'new-password'
 Note: the mysqladmin command should be run from a shell script, so as to not have this critical password exposed in the command history - make sure to delete the shell script after running
-*Delete Database*
+*Delete Database
    mysql> drop database test;
-*Creating a new DB and assigning permissions*
+*Creating a new DB and assigning permissions
 Command line/scripted
@@ Line 24: / Line 24: @@
    mysql> grant index, create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';
-*Table Structure*
+*Table Structure
   describe SystemEvents;
-*View Data (Some Query Examples)*
+*View Data (Some Query Examples)
   select * from user;
   select Host,User,Grant_priv from user;
@@ Line 34: / Line 34: @@
   select * from SystemEvents where SysLogTag like '%[%' limit 5;
-*Modify Data*
+*Modify Data
   update SystemEvents set SysLogTag='CROND:' where SysLogTag='CROND';
   update SystemEvents set SysLogTag='sshd:' where SysLogTag like 'sshd[%';
-*Delete From Table*
+*Delete From Table