Mysql problem connection
lazarus / 16-Databases

----------------------------------------------------------------------
eldonfsr · 2021-12-07 21:49

Hi i have two apps with mysql, on my computer run great, I install a
mysql on computer as server one app runs with no problem but other
send me error Server Connection error Failed press ok to ignored and
risk corruption data, what could be problem, I put same libmysql.dll
why doesn't connect...
  
mysql server 5.7.36

some body have same problem...

any help great...

thanks
Fernando Sandoval

----------------------------------------------------------------------
dseligo · 2021-12-08 00:34

So, problem is from another computer in the network to server?
Check firewall if port 3306 is open. You also have to allow (in MySQL)
access from network for username that is connecting.

I suggest you try connection with HeidiSQL https://www.heidisql.com/,
and when you can connect with HeidiSQL then try your application.

In application check if you have correct HostName (IP or network
address), port, username, password, maybe your antivirus is blocking
your app. Check bitness of your programs: if one is 32-bit and other
is 64-bit same libmysql.dll won't work.
Try to fill LibraryLocation to point to libmysql.dll.

You have to systematically check one by one issue.

And you'll have to give us more details if this won't help you.
What components are you using for mySQL connection? In ZEOS you have
to set correct protocol.
What OS-es are in each computer?

----------------------------------------------------------------------
Zvoni · 2021-12-08 08:55

In my.ini/my.cnf (on that server):
What's the value for Bind_address?

----------------------------------------------------------------------
eldonfsr · 2021-12-10 03:25

Thanks for your help, I found the problem , my mistake was Data
module, I get connect using software heidsql so start dig more deep
and when data module is created send me error and take the values for
ip new location of data base,

on data module i change
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  procedure
TDM.DataModuleCreate(Sender: TObject);    begin     
SQLDBLibLMysql.LibraryName:=WideString(ExtractFilePath(ParamStr(0)) +
'libmysql.dll');      SQLDBLibLMysql.LoadLibrary;      
FPXMLBServ.LoadFromFile('Setting.xml');     
ServerIP:=FPXMLBServ.GetAttrValueByName('Server.ip', 'value');     
serverUser:=FPXMLBServ.GetAttrValueByName('Server.user', 'value');   
 ServerPsw:=FPXMLBServ.GetAttrValueByName('Server.password',
'value');     
ServerDb:=FPXMLBServ.GetAttrValueByName('Server.database', 'value'); 
   if( DM.InvMgrCon.Connected= false) then begin         
DM.InvMgrCon.DataBaseName := ServerDb;         
DM.InvMgrCon.HostName:= ServerIp;         
DM.InvMgrCon.UserName:=ServerUser;         
DM.InvMgrCon.Password:=ServerPsw;     end;      if(
InvMgrCon.Connected = false) then begin       
 InvMgrCon.Connected:=true;      end;    

Thanks for your help....