mysql

Section: Misc. Reference Manual Pages (pj)
Updated: 4 July 2003
Index Return to Main Contents
 

NAME

MySQL Notes  

DESCRIPTION

To see the indexes on a table and their definitions:

SHOW INDEX FROM [dbname.]tablename

SHOW INDEX FROM tablename [FROM dbname]

Create a new database:

CREATE DATABASE database-name
GRANT ALL PRIVILEGES ON database-name.*
TO user@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

or to let a user create/use any databases starting with their username:

CREATE USER 'foo'@'localhost' IDENTIFIED BY 'bar';
GRANT ALL PRIVILEGES ON `foo\_%`.* TO 'foo'@'%';
FLUSH PRIVILEGES;
 

AUTHOR

Paul Jungwirth


 

Index

NAME
DESCRIPTION
AUTHOR

This document was created by man2html, using the manual pages.
Time: 19:46:04 GMT, August 02, 2017