Determine Whether Your MySQL Server Is Running

-
  1. Log into your mysql server
  2. Switch to your into your mysql directory by typing the following command:
    cd mysql
  3. Type the following at the command line:
    ~/mysql/bin/mysqladmin -u root -p status
    • Enter your root MySQL password in order to continue.
  4. If the results look something like the following output, MySQL is running properly:
    Uptime: 4 Threads: 1 Questions: 62 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables: 45 Queries per second avg: 15.500
    If the results look like the following output, MySQL is running properly, but you entered the incorrect password:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    If the results look like the following output, MySQL is not running properly:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/path/to/sock/mysql.sock' (111)







Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more