mysqladmin Command in MySQL



mysqladmin - is a utility provided by MySQL to perform admin tasks from command line.


syntax:
# mysqladmin -h hostname -u username -p <Commands>
 user will be prompted for password.


example:
mysqladmin -h localhost -u root -p Create College
this will create college database


mysqladmin -h localhost -u root -p drop College
this will delete existing college database


Note:
# --> shell prompt
C:\>  Command prompt


mysqladmin -h localhost -u root status
 return status information from the server


mysqladmin -h localhost -u root ping
checks MySQL server is available or not

No comments:

Post a Comment

Thanks for visiting my Blog!

Have a Question ? Need Help in College Assignments, Need Code that is not available here? Just leave a comment & get your code instantly.

Tips to Enhance Your Blog