chevron_left
Getting started
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
auto_stories new
settings
Connecting to the MySQL Server
Database
chevron_rightMySQL
chevron_rightCommon questions
chevron_rightGetting started
schedule Jul 1, 2022
Last updated local_offer MySQL
Tags tocTable of Contents
expand_more Check out the interactive map of data science
We can connect to the MySQL server using the following command:
mysql -u root -p
Where:
-u root
is used to connect as the MySQL root user (i.e. theu
stands for user, and--user
works as well)-p
tells Mysql to prompt for a password. If you have set a password, you would need to use this parameter.
If done correctly, you should see the following:
mysql>
This means that you are now connected to the MySQL server! Great, let’s start messing around with databases!
Connecting to a specific host
We can also explicitly state the server name (i.e. host name) that we are connecting to:
mysql –h localhost –u root -p
Since our server is hosted by localhost
, we connect using the following: –h localhost
. Note that even if we
do not supply this parameter, the command will simply assume that you are connecting to localhost
by default.
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Ask a question or leave a feedback...
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!