mysqladmin Command in MySQL

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

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

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

# --> 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