Better, i recommend you, to add the port 3306 to your firewall and deny connections.Īll other information is transferred as text, and can be read by anyone who is able to watch the connection.īut the proper solution is, to ask putty for help. To follow up the topic, i do not recommend, to allowed any user from other than localhost. My guess is - as siMKin already said - that your provider has set the "skip-networking" option in the my.cnf or my.ini on his server. I can connect with HeidiSQL and this username. So I created a username with exactly 16 characters: "1234567890123456". String 'db.' is too long for user name (should be no longer than 16) However, if I try to create a user with a longer username than 16 characters, the server replies with an errormessage The username in the error message is not cut. Then I deleted the user from the priv tables again and - what a surprise - could no longer connect via HeidiSQL. I just tested that by creating a user "db." on my local mysql server which let's me connect via HeidiSQL - no problem. If it's I think that would count as a bug :-) ![]() So I'm wondering - is the username being cut off after a certain number of characters in HeidiSQL, is it done by MySql or is it just shortened for the error message. What's interesting is that the error message says something like "SQL Error: Access denied for user: (Using password:YES)" BUT the username I filled in in the connection dialog in HeidiSQL is db. Ġ2 May - chump: XML data stored in Postgresql Causes HangĠ1 May - gulshan212: Python Hangman Program ErrorĢ9 Apr - ansgar: Incorrect information in error message Ġ4 May - Jorg71: Query is not updated after adding a colu. Ġ5 May - IvanFerrer: Possibility hide/show tables on the. Ġ5 May - aSystemOverload: Support for 'Active Direct. ġ3 May - timint: Can we copy tables from MSSQL to MySQL?ġ2 May - roshin_philip2: MySQL View Table Countsġ1 May - gulshan212: Syntax error when exporting to a. ġ5 May - ansgar: Loading large files on the SQL tab resul. ġ9 May - TTSneko: Problem Importing CSV Fileġ7 May - dnichols: Errors Importing SQL Fileġ5 May - FreeFun: 0 rows updated when that should have be. Ģ5 May - Makkeysn: Editing mode tabulatorĢ5 May - Makkeysn: Next Data field edit with Tab keyĢ2 May - ansgar: Insert row with foreign key does not all. You may want toĢ7 May - BubikolRamios: bug import sql file errorĢ6 May - K13483: Is it possible to set up the datatype of. User support and hosting takes time and money. But keep in mind that developing HeidiSQL,
0 Comments
Leave a Reply. |