mysql

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

NAME

MySQL Notes

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;

Paul Jungwirth

This document was created by man2html, using the manual pages.
Time: 23:18:39 GMT, April 26, 2010