How to verify whether MySQL is installed successfully

How to verify whether MySQL is installed successfully

After MySQL is installed, you can verify whether MySQL is installed successfully through a DOS window or the MySQL 5.7 Command Line Client.

DOS window verification

Step 1): Open a DOS window. If you have configured MySQL environment variables, log in directly. If you have not configured environment variables, you need to log in to the mysql/bin directory. As shown in the picture.

Step 2): Enter the status command to view the MySQL version information, as shown in the figure.

The appearance of the above code indicates that the installation is successful.

Method extension:

How to test whether MySQL is installed successfully

Command line:

net start mysql

If it can be started, it means the installation is successful.

If you want to query the default database, you can use mysqlfont, or directly operate the command line

Enter the bin folder under the installation directory, or configure the environment variables, and then

mysql -uroot -p

Then enter your password!

This is the end of this article about how to verify whether MySQL is installed successfully. For more information about how to verify whether MySQL is installed successfully, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • Two ways to determine whether a Mysql string field contains a certain string
  • How to use time as a judgment condition in MySQL
  • How to check if data exists before inserting in mysql

<<:  Vue implements multi-column layout drag

>>:  Detailed tutorial for installing ffmpeg under Linux

Recommend

MYSQL database basics - Join operation principle

Join uses the Nested-Loop Join algorithm. There a...

How to solve the problem that mysql cannot be closed

Solution to mysql not closing: Right-click on the...

JavaScript Factory Pattern Explained

Table of contents Simple Factory Factory Method S...

Introduction to the use of several special attribute tags in HTML

The following attributes are not very compatible w...

Analysis of log files in the tomcat logs directory (summary)

Each time tomcat is started, the following log fi...

Elements of user experience or elements of web design

System and user environment design <br />Th...

How to use pdf.js to preview pdf files in Vue

When we preview PDF on the page, some files canno...

Build a Docker image using Dockerfile

Table of contents Build a Docker image using Dock...

Pure CSS to change the color of the picture

The css technique for changing the color of an im...

Vue+ssh framework to realize online chat

This article shares the specific code of Vue+ssh ...

sql script function to write postgresql database to implement parsing

This article mainly introduces the sql script fun...

Installation tutorial of mysql8.0rpm on centos7

First, download the diagram 1. First uninstall th...