Connecting to the MySQL Server
Start your free 7-days trial now!
We can connect to the MySQL server using the following command:
mysql -u root -p
-u rootis used to connect as the MySQL root user (i.e. the
ustands for user, and
--userworks as well)
-ptells 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:
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.