Home >Database >Mysql Tutorial >How to open mysql using command line

How to open mysql using command line

coldplay.xixi
coldplay.xixiOriginal
2020-08-27 15:22:114017browse

How to open mysql using the command line: 1. Enter the bin directory of mysql and enter [mysql -u USERNAME -pPASSWORD]; 2. If the path during mysql installation is on the C drive, enter the command [mysql -h localhost -u】.

How to open mysql using command line

【Related learning recommendations: mysql tutorial

How to open mysql with the command line:

If the path when mysql is installed is not on the C drive, you should enter the bin directory of mysql, and then enter

“mysql -u USERNAME -pPASSWORD ”
in the command prompt

If the path when installing mysql is on the C drive, directly enter

“mysql -h localhost -u USERNAME -pPASSWORD ”

in the command prompt: Related learning recommendations: Programming video

The above is the detailed content of How to open mysql using command line. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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