Home > Database > Mysql Tutorial > body text

Enter the MySQL database through the DOS command prompt under windows

黄舟
Release: 2017-03-01 13:48:50
Original
1982 people have browsed it

Environment Introduction

Mysql is installed when installing the PHP integrated environment wampserver. There is no operation interface. I have always used SQLyog to manage operations. Today I suddenly want to use the command prompt window. Operations, so I summarized some, how to use DOS commands to enter the MySQL database under windows.

First determine the installation location of mysql

For example, my mysql is installed in D:\wamp\bin\mysql\mysql5.6.17\bin


Secondly, enter the following command

mysql -h+host -u+username[-p+password]

Because I did not set a password, directly mysql -hlocahost -uroot


Finally, you can enter the corresponding command to operate and exit using exit;


## The above is the content of entering the MySQL database through the DOS command prompt under Windows. For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com)!




Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!