Here is the mysqlshow commands examples
1. Display available databases
Please replace tmppassword with your MySQL DB root user password.
# mysqlshow -u root -ptmppassword
+——————–+
| Databases |
+——————–+
| information_schema |
| mysql |
| sugarcrm |
+——————–+
2. Display all tables in a database
The example below will display all the tables located under sugarcrm database
# …
1. How to change the MySQL root user password?
# mysqladmin -u root -ptmppassword password ‘newpassword’
# mysql -u root -pnewpassword
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.25-rc-community MySQL Community Server (GPL)
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql>
2. How to check whether MySQL Server is up and running?
# mysqladmin -u root -p ping
Enter password:
mysqld is alive
3. How do I find out what version of MySQL I …
