<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body><div>[Cross posted on forum so if you want answer there : <a href="http://forum.lazarus.freepascal.org/index.php/topic,30635.0.html">http://forum.lazarus.freepascal.org/index.php/topic,30635.0.html</a> ]<br></div>
<div> </div>
<div>Hi,<br></div>
<div> </div>
<div><div>I want to play with MySQL process and get what ever it write to console so I write this code:</div>
<div> </div>
</div>
<blockquote><div><div>Process := TProcess.Create(nil);</div>
<div> with Process do</div>
<div> begin</div>
<div> Executable := 'C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysql.exe';</div>
<div> with Parameters do</div>
<div> begin</div>
<div> Options := [poUsePipes];</div>
<div> Add('-u');</div>
<div> Add('root');</div>
<div> Add('-p');</div>
<div> end;</div>
<div> Execute;</div>
<div> while Process.Running do</div>
<div> Memo1.Lines.LoadFromStream(Process.Output);</div>
<div> end; <br></div>
</div>
</blockquote><div><div> </div>
<div>But the problem is that this will freeze because there is no output but console window write :</div>
</div>
<blockquote><div><div>Enter password:<br></div>
</div>
</blockquote><div><div>How can I get this in my application and all others?</div>
<div> </div>
<div>As I said I want to work with MySQL executable and read from and write in it, So I dont want to use its library or any other DB component.</div>
</div>
<div> </div>
<div id="sig12586409"><div class="signature">Regards,<br></div>
<div class="signature">Ara<br></div>
</div>
<div> </div>
<pre>
--
http://www.fastmail.com - Choose from over 50 domains or use your own
</pre>
</body>
</html>