i have seen many stack overflows questions , blogs tried workarounds, nothings helped - hence re-posting question more details.
i seeing weird behaviour mysql , python application, details follows:
1) application works fine mysql (tried , tested on many platforms) on particular machine fails connect mysql.
structure of application :
windows service -> parent process -> mysql(child process) and when application tries connect mysql error:
error 2013 , lost connection mysql server @ 'waiting initial communication packet' - system error 0 i tried:
- connect_timeout=300 - skip-name-resolve=0 - firewall off - use 17.0.0.1, localhost , ip of machine connect still fails same error. 2) weird thing -
if manually follow steps application does, works fine, details follows: a) start mysql same command (which application uses) administrator privileges
mysql --default-file = xxx --basedir =xxx b) connect same credentials ( -u root -p 6075 -h 127.0.0.1) , works fine, double checked steps application does, there no difference between manually steps , application code.
am missing here ? suggestions ?
mysql version : 5.5.35 python : 2.7 base os : windows 2012 r2 thanks in advance..
found reason - answering question:
when used run mysql application - running under system user privileges - used pick "c:\windows\temp" temp directory- directory messed - has lot of unnecessary files .. , mysql stuck while processing files under directory...
but when ran manually under administrator account using temp directory... c:\users\user_name\appdata\local\temp , working magic...
to fix permanently changed tmp directory through mysql conf file , application runs wind.... :)
[mysqld] tmpdir = 'path_to_the_directory' 