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

Detailed tutorial on installation and configuration of nginx under Centos7

Note: The basic directory path for software insta...

Working principle and example analysis of Linux NFS mechanism

What is NFS? network file system A method or mech...

Detailed explanation of the construction and use of docker private warehouse

1. Download the repository image docker pull regi...

CentOS method to modify the default ssh port number example

The default ssh port number of Linux servers is g...

Ways to improve MongoDB performance

MongoDB is a high-performance database, but in th...

Introduction to basic concepts and technologies used in Web development

Today, this article introduces some basic concept...

Detailed example of MySQL (5.6 and below) parsing JSON

MySQL (5.6 and below) parses json #json parsing f...

Detailed example of clearing tablespace fragmentation in MySQL

Detailed example of clearing tablespace fragmenta...

Detailed explanation of various types of image formats such as JPG, GIF and PNG

Everyone knows that images on web pages are genera...

mysql 5.7.17 winx64.zip installation and configuration method graphic tutorial

Preface: I reinstalled win10 and organized the fi...

Sharing of experience on repairing MySQL innodb exceptions

A set of MySQL libraries for testing. The previou...

Summary of web design experience and skills

■ Website theme planning Be careful not to make yo...

Install and configure MySQL 5.7 under CentOS 7

This article tests the environment: CentOS 7 64-b...

Page Refactoring Skills - Content

Enough of small talk <br />Based on the lar...