View MySQL installation information under Linux server

View MySQL installation information under Linux server

View the installation information of mysql:

#ps -ef | grep mysql

usr/bin/mysql means: the running path of mysql
var/lib/mysql refers to: the storage path of mysql database files
usr/lib/mysql refers to: the installation path of mysql

#whereis mysql

#mysqladmin -u root -p variables

root is your database account. Press Enter and you will be prompted to enter your password. Enter the password corresponding to the account filled in above and press Enter. A large table will appear. Find the datadir line, and the value behind it is the path where the database is located.

You may also be interested in:
  • Steps to configure the mongodb environment in Linux server
  • Detailed explanation of Linux NTP server time synchronization settings
  • How to enable MySQL remote connection in Linux server
  • Linux detects whether the server is connected to the network
  • How to use FTP on Windows desktop to upload files to Linux server
  • How to solve the problem of full disk space on Linux server
  • How to copy files between two Linux servers and log in without password
  • Detailed steps to deal with Linux server hacking

<<:  How to create, start, and stop a Docker container

>>:  JavaScript canvas implements graphics and text with shadows

Recommend

Implementation of TypeScript in React project

Table of contents 1. Introduction 2. Usage Statel...

Implementation of master-slave replication in docker compose deployment

Table of contents Configuration parsing Service C...

Comparing Document Locations

<br />A great blog post by PPK two years ago...

Detailed explanation of samba + OPENldap to build a file sharing server

Here I use samba (file sharing service) v4.9.1 + ...

How to modify the contents of an existing Docker container

1. Docker ps lists containers 2. Docker cp copies...

How to use vue3+TypeScript+vue-router

Table of contents Easy to use Create a project vu...

Table Tag (table) In-depth

<br />Table is a tag that has been used by e...

MySQL series: redo log, undo log and binlog detailed explanation

Implementation of transactions The redo log ensur...

Design Story: The Security Guard Who Can't Remember License Plates

<br />In order to manage the vehicles enteri...

Example of how to quickly build a Redis cluster with Docker

What is Redis Cluster Redis cluster is a distribu...

Implementation of navigation bar and drop-down menu in CSS

1. CSS Navigation Bar (1) Function of the navigat...

How to reset Zabbix password (one-step)

Problem Description Since we don't log in to ...

Solution to the routing highlighting problem of Vue components

Preface Before, I used cache to highlight the rou...

JavaScript implements simple scroll window

This article example shares the specific code of ...