When I start BusCoX hosting on a VPS I’ll need to know this.
MySQL is a powerful relational database system and probably the most used (especially on shared hosting) . It is also a pre-installed service on all web-development “bundled” local servers like :WAMP , XAMP , MAMP . MySQL’s mysqladmin is a command-line (terminal) interface for administrators to perform server administration tasks . It can be used to replace the root user default password with your own , check the server’s configuration and current status , create and drop databases , check if the MySQL database service is running , shutdown the MySQL database service and bring it up running again and more …. Let’s see 15 practical examples .
- Changing the root password for Mysql :
mysqladmin -u root -p ‘newpassword’
- Checking whether the MySQL server is running
mysqladmin -u root -p ping
- Exploring the status of the MySQL server
mysqladmin -u root -p status
- what version of MySQL is running
View original post 480 more words