Hi,
has anybody successfully got connected to a mysql server using a shared mem connection? I can't get it work. Connecting via tcp works fine but if I set the sql.ini to "skip-networking" and set the parameters for a shared mem connection I get the error:
"Can't connect to MySQL server on 'localhost' (10061) QMYSQL: Unable to connect"
My sql.ini settings:
skip-networking
shared-memory
shared-memory-base-name=TestApp
enable-named-pipe
socket=mysql-TestApp.sock
bind-address=127.0.0.1
port=3333
init-connect="SET NAMES UTF8"
basedir="../"
datadir="../Data/"
default-character-set=UTF8
collation_server=utf8_unicode_ci
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
skip-networking
shared-memory
shared-memory-base-name=TestApp
enable-named-pipe
socket=mysql-TestApp.sock
bind-address=127.0.0.1
port=3333
init-connect="SET NAMES UTF8"
basedir="../"
datadir="../Data/"
default-character-set=UTF8
collation_server=utf8_unicode_ci
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
To copy to clipboard, switch view to plain text mode
Client code:
QSqlDatabase::setConnectOptions("protocol=memory;shared-memory-base-name=TestApp;")
QSqlDatabase::setConnectOptions("protocol=memory;shared-memory-base-name=TestApp;")
To copy to clipboard, switch view to plain text mode
Database: MySQL v. 5.1.26 running as standalone
Qt: 4.3.4
Any ideas?
Thanks,
Patrik
Bookmarks