5,576
edits
Changes
Jump to navigation
Jump to search
Line 114:
Line 114: + + + +
→Create a Database and its User
mysqlshow
mysqlshow
will list all available database. Use 'mysqlshow --help' for all available options.
will list all available database. Use 'mysqlshow --help' for all available options.
SELECT user FROM mysql.user;
display a list of the MySQL users
SHOW GRANTS FOR 'user'@'localhost';
list the privileges granted to the account user
mysqladmin drop '''databasename'''
mysqladmin drop '''databasename'''
will let you destroy a database. Use with care. Use 'mysqladmin --help' for all available options.
will let you destroy a database. Use with care. Use 'mysqladmin --help' for all available options.