Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Useful Commands
(view source)
Revision as of 16:20, 11 January 2014
45 bytes removed
,
16:20, 11 January 2014
→Other useful MySQL commands:
Line 349:
Line 349:
drop database database-name;
drop database database-name;
===Other useful MySQL commands:===
===Other useful MySQL commands:===
−
mysqlshow
;
+
show databases
;
−
list all available database
. Use 'mysqlshow --help' for all available options
.
+
list all available database.
SELECT user FROM mysql.user;
SELECT user FROM mysql.user;
display a list of the MySQL users
display a list of the MySQL users
Stephdl
Administrators
5,576
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
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