5,576
edits
Changes
Jump to navigation
Jump to search
Line 111:
Line 111: − + − + − will list all available database. Use 'mysqlshow --help' for all available options.+ − +
→Create a Database and its User
exit
exit
Other useful MySQL commands:
===Other useful MySQL commands:===
mysqlshow
mysqlshow;
list all available database. Use 'mysqlshow --help' for all available options.
SELECT user FROM mysql.user;
SELECT user FROM mysql.user;
display a list of the MySQL users
display a list of the MySQL users
SHOW GRANTS FOR 'user'@'localhost';
SHOW GRANTS FOR 'user'@'localhost';
list the privileges granted to the account user
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.