Dear all, I found the solution:
1. If you want to use the shared memory protocol locally on windows a. Stop the TCP/IP protocol by adding –skip-networking in my.ini file. b. Add the shared memory protocol by adding –shared-memory in my.ini file. c. Both should be added under [mysqld] option. [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 skip-networking shared-memory 2. Save the my.ini file. 3. Stop the mysql service, by services.msc console. 4. Start the mysql service. 5. Connect to the server by typing: Mysql -h localhost -u root --protocol =memory -p Enter password : ***** 6. mysql> status; -------------- mysql Ver 14.14 Distrib 5.1.57, for Win32 (ia32) Connection id: 1 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.1.57-community MySQL Community Server (GPL) Protocol version: 10 Connection: Shared memory: MYSQL Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 TCP port: 3306 Uptime: 51 sec Thanks. SIVASUTHAN. [SCMA, OCP] > From: nsivasut...@live.com > To: mysql@lists.mysql.com > Subject: Shared memory protocol can not be accessed in windows > Date: Sat, 14 Apr 2012 17:15:46 +0600 > > > > > > I used windows 7 OS. I try to connect to the MySQL server locally using > shared memory prtotocolthis error message comes. Any one, can you tell me how > to figure out this? C:\>mysql -h localhost -u root --protocol=memory > --enable-shared-memory -p > Enter password: **** > ERROR 2038 (HY000): Can't open shared memory; client could not create request > event (2)C:\> Also I am unable to use nt-pipe protocol.C:\>mysql -h > localhost -u root --protocol=pipe --enable-named-pipe -p > mysql: unknown option '--enable-named-pipe'C:\> Thanks.Sivasuthan. >