开发者

connecting mysql through command prompt

开发者 https://www.devze.com 2023-04-12 01:07 出处:网络
I have query regarding connecting mysql t开发者_如何转开发o comand prompt. I did: open cmd prompt

I have query regarding connecting mysql t开发者_如何转开发o comand prompt. I did:

open cmd prompt
telnet localhost com 3306
 I RECEIVED REPLY as---

some instructions mentioning

telnet [-a][-e escape char][-f log file][-1 user][-t term][host [port]]
-a     attempt automatic logon. same as -1 option except uses the currently logged on  user's name.

-e   Escape char to enter telnet client prompt.

and some more...

but is it right?? or i am lost??? kindly help.


do not telnet to your mysql database.

Instead use the mysql command, a UI like db visualizer (they have a pay version and a free version), or the free ui that comes with maria db (a drop in replacement for mysql).

more more info on the mysql command, try running mysql --help or find it in the mysql reference manual

Edit: more info added here.
Telnet is not a "command prompt", it is a communication protocol (check out telnet protocol on wikipedia) and a program (that uses the communication protocol to communicate). You can not connect to mySql with telnet because mySql does not use the telnet protocol for communication.

I have only accessed mySql for jdbc, so I'm not sure how to solve your problem. I know there is a c api interface for mySql as well. Sections "20 Connectors and APIs," and "15 Replication" in the mysql reference might be helpful.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号