Changes
From SME Server
Jump to navigation
Jump to search
← Older edit
Newer edit →
Useful Commands
(view source)
Revision as of 11:17, 21 April 2013
3 bytes added
,
11:17, 21 April 2013
→Create a Database and its User
Line 111:
Line 111:
exit
exit
−
Other useful MySQL commands:
+
===
Other useful MySQL commands:
===
−
mysqlshow
+
mysqlshow
;
−
will
list all available database. Use 'mysqlshow --help' for all available options.
+
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.
Stephdl
Administrators
5,576
edits
Navigation menu
Page actions
Page
Discussion
View source
History
Page actions
Page
Discussion
More
Tools
In other languages
Personal tools
English
Log in
Koozali SME Server
Main Page
Welcome
Releases
Testimonials
Documentation
SME Server FAQ
Volunteering
Commercial Support
Recent activities
Dashboard
Recent wiki changes
Recent bug changes
Unread Forum posts
Koozali resources
Contribs
How-To's
Forums
Bugzilla
Mailing Lists
Translations
Download
Koozali SME Server wiki
Wiki statistics
Wiki categories
Wiki Help
Koozali Wiki Help
Tools
Special pages
Printable version
Search