How To Connect To MySQL Database With Command Terminal

Forums » MySQL » How To Connect To MySQL Database With Command Terminal
this post will show you what command you need to use in order to connect to your mysql server using the command line terminal. this is helpful if you are using ssh sessions to login to your server and you need to test your mysql database
this post will show you what command you need to use in order to connect to your mysql server using the command line terminal. this is helpful if you are using ssh sessions to login to your server and you need to test your mysql database.

i need to post this here because there are many administrators who find it userful to just connect from the command terminal in linux server. so if you have like a wallpaper website with a dedicated server from webune.com - this is a very useful command.

this is the command you can use:


mysql -u USER -h HOST -p


NOTE:
USER = whatever username is for your database
HOST = whatever you server hostname is. if you are not sure, try using: localhost or the ip address of your server

after you enter this command, you will be prompted to enter the password for the USER

NOTE:
-u = user
-h = host

hope this helps

Title: How To Connect To MySQL Database With Command Terminal [924]
Tags: mysql command connect database linux ssh shell terminal login admin
By
Comments 0
Visits 2285