WampServer

I have installed Wampserver2.2e-php5.4.3-httpd-2.4.2-mysql5.5.24-x64

After disabling Antivirus & firewall and quitting Skype, Apache and PHP are working.

However the Mysql Service doesnt work (Wampserver icon is orange) and so I can´t connect to phpMyAdmin.
Error Message is : #2002 - No connection could be made because the target machine actively refused it.

So i tried the Mysql installation manual with "mysqld --console". It runs on port 3306 (I have checked with nestat, port is free) and i can access the Database via console.

Now if I try to start Mysql via the wampmanager I got the following error:

131121 17:32:12 [Note] Plugin 'FEDERATED' is disabled.
131121 17:32:12 InnoDB: The InnoDB memory heap is disabled
131121 17:32:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131121 17:32:12 InnoDB: Compressed tables use zlib 1.2.3
wampmysqld: File 'C:\Windows\TEMP\ibC027.tmp' not found (Errcode: 13)
131121 17:32:12 InnoDB: Error: unable to create temporary file; errno: 13
131121 17:32:12 [ERROR] Plugin 'InnoDB' init function returned error.
131121 17:32:12 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131121 17:32:12 [ERROR] Unknown/unsupported storage engine: InnoDB
131121 17:32:12 [ERROR] Aborting

131121 17:32:12 [Note] wampmysqld: Shutdown complete

I also located the wampmysqld service in the taskmanager, trying to start it there results in a "Access is denied" error.

If I understand correctly, the services should be run under the SYSTEM account, so they should have read/write access in the C:\Windows\TEMP\ folder.
I also tried to make the C:\Windows\TEMP\ accessible for all users. Then I tried to move the tmp directory of mysql without success.

I tried to find some answers on the internet but without success ...

Thanks a lot in advance for thelp



Edited 1 time(s). Last edit at 11/21/2013 07:43PM by bbob.

No I think you have a rough my.ini somewhere

Do a search for my.in and my.cnf if you find either anywhere OUTSIDE the C;\wamp\... folder structure, DELETE THEM.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

RiggsFolly Wrote:
-------------------------------------------------------
> No I think you have a rough my.ini somewhere
>
> Do a search for my.in and my.cnf if you find
> either anywhere OUTSIDE the C;\wamp\... folder
> structure, DELETE THEM.


I have searched all places, there is only one file named my.ini inside the C:\wamp\... folder and no my.cnf at all ...



Edited 1 time(s). Last edit at 11/21/2013 06:15PM by bbob.

You should not need to change any of that under normal circumstance.

Ok so I have learnt something here to.

So MySQL attempts to store some temporary files in C:\Windows\Temp when it is initialising itself.

This should normally not be a problem as the service is started under the 'Local System' account and that has all the rights it need.

Have you changed the User account that wampmysql is being started with?
Or changed the local system account in any way?
Or are you running on a system that is Active Directory controlled from a network?



You can change the default tmp directory by doing this:

Edit your my.ini
Locate this line

# Point the following paths to different dedicated disks
#tmpdir = /tmp/

Uncomment the paramter and give it a folder that you do have access to!

For example I tried this and it worked, create the 'mysql' folder before trying to start mysql.

tmpdir = D:/wamp/tmp/mysql

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 11/21/2013 07:28PM by RiggsFolly.

Thanks a lot for your help, now it works

tmpdir does the job !

I already tried to change paths in the my.ini but i missed this one ...

I start the wampmysql as Administrator, apache works but mysql seems to have insufficient file permissions.

Just run the WampServer icon on your desktop or start menu. You dont need to do anything else its all done internally.

Oh if you keep this setting, it may be a good idea to put the temp folder on a different drive from the wamp folder. As MySQL uses this folder for temporary table it creates a different spindle may speed things up.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 11/21/2013 08:09PM by RiggsFolly.