How to connect the mysql from command prompt
Related FAQs
- how to find which tables use innodb in mysql
- How to search a tablename in schema
- How to get the students who are in more than one group mysql
- How to find the duplicate rows by comparing two columns in a table mysql
- How to get the length of a string in a column mysql
- How to get the records posted in this month in mysql
- how to find duplicate rows in a table based on specific column
- how to determine constant values in mysql
- how to concatenate all rows of a particular column in a table mysql
- How to connect the mysql from command prompt
we should know the
Wed, 12/24/2008 - 03:52 — adminwe should know the username/password and Host name of your mysql server
syntax
mysql -u USERNAME -h HOSTNAME -p
eg:
mysql -u sri -h localhost -p
it prompts for the password..enter the password..
done..