5,576
edits
Changes
From SME Server
Jump to navigationJump to search→MySQL
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
GRANT ALL PRIVILEGES ON *.* TO 'new_dba'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
give all rights on all databases for new_dba user
GRANT SELECT, UPDATE, INSERT, DELETE ON database.* TO 'new_user'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
give all rights on database for new_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.
