MySQL Performance: MySQL => Telnet issues after fresh install

Members

Help

Home

Home » Performance » MySQL » Telnet issues after fresh install - Connection to host lost

Show: Today's Messages :: Show Polls :: Message Navigator

Telnet issues after fresh install - Connection to host lost [message #2602]

Thu, 07 February 2008 18:10

carnevale
Messages: 2
Registered: February 2008

Junior Member

I replicated this issue on two machines and I am dumfounded to find no articles or postings on this matter. I can not be the only person who has ran into this issue on 2 different machines.

This is a fresh install of 4.1. I am tying to telnet through port 3306 and I receive the following message.

“D♦Host 'MYSQLSERVER' is not allowed to connect to this MySQL server

Connection to host lost.”

OK, no worries, I will make a root user that can control everything. After such a user is created and I attempt the telnet session I get the following garbage.

“A
4.1.22-community-ntTU/*%xPg,☻5r^bPKe<;SoV

Connection to host lost.”

Help!

Report message to a moderator

Re: Telnet issues after fresh install - Connection to host lost [message #2604 is a reply to message #2602 ]

Thu, 07 February 2008 22:14

carnevale
Messages: 2
Registered: February 2008

Junior Member

Evidently you can not telnet directly from the command prompt to a MYSQL server. You must have MYSQL installed in the client machine as well. From the /bin directory issue the following command to telnet to your MYSQL server.

mysql -u root -p<password> -h <IP_number>

Tada!

Report message to a moderator

Previous Topic:	Slow SELECT ... LIMIT without WHERE clause on federated table
Next Topic:	Query slow first time, then fast

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 20:06:51 EDT 2009

Total time taken to generate the page: 0.04182 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.