CentOS, Databases, Linux / July 11, 2022 / ashishpsk / 0
MySQL SHOW USERS: List All Users in a MySQL Database Server: To get more information on the user table, you can preview its columns using the following command: To show users and other information such as host, account locking, and password expiration status, you use the following query: SELECT user, host, account_locked, password_expired FROM user; To get
Databases, Linux, wordpress / May 9, 2022 / ashishpsk / 0
The root cause of the above error is that MySQL was not closed properly, during database shutdown. Due to this socket file is not removed by MySQL and had to be removed manually. Verify that MySQL is not running on your system: Remove leftover socket file using following command: Start the MySQL database and verify
Databases, Linux / December 7, 2021 / ashishpsk / 0
To check the sizes of all of your databases, at the mysql> prompt type the following command: To check the sizes of all of the tables in a specific database, at the mysql> prompt, type the following command. Replace database_name with the name of the database that you want to check: To View The MySQL/MariaDB Database Size In Linux: Use the
Databases, Linux / November 24, 2021 / ashishpsk / 0
Best to do options, posts, post content and post meta: