- 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 [924], Last Updated: Sat May 18, 2024
wallpaperama
Tue Feb 01, 2011
0 Comments
2654 Visits
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