Database stored in a network drive

Hello together,

i have a big problem. I stored my database in a network drive and change the my.ini file like FAQ #52. The phpmyadmin user is root with no password. It works fine from my PC. When I install EasyPHP on another PC I change themy.ini file too with the same directory. And now i have the problem. PHPMyadmin says #2003 - The server is not responding and my site says "Can't connect to MYSQL - username or password is wrong!

What is the problem?

Greetings from sad germany :-)

Hi,

Can you tell us what is into MySQL log ?

Hello.

i think the log is ok... The "traffic light" for MySQL and Apache is green.

I have only the problem that i can't open PHPMyAdmin and my site is not working.

If you start MySQL manually (mysqld.exe), is there any error ?

Hi,

no, i closed it. Change the address in the my.ini file. Start it and thats all.

I try something but...

Uninstall EasyPHP on all PC's.

Install EasyPHP on the first PC. I change the adress to the data files on my network drive.

PHPMyadmin is working, my site is working. Wonderfull.

I go to the second PC. Install EasyPHP, change the address, and the same problem!

Apache and MySQL works fine. And on the second PC is an error log.

-----------
100709 16:02:32 [Note] Event Scheduler: Purging the queue. 0 events
100709 16:02:32 InnoDB: Starting shutdown...
100709 16:02:32 InnoDB: Shutdown completed; log sequence number 0 44233
100709 16:02:32 [Warning] Forcing shutdown of 1 plugins
100709 16:02:32 [Note] C:\EASYPH~1.10\MySql\bin\mysqld.exe: Shutdown complete
-----------

I started on the second PC my site and this is the error message.


Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '127.0.0.1' (10061) in C:\EasyPHP5.2.10\www\serviceinfo\inc\config.php on line 3
keine Verbindung möglich. Benutzername oder Passwort sind falsch

-- Username and Password are incorrect

It's the same page like on the other PC

My newest Error Log on the second PC

100709 21:45:04 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.



Edited 1 time(s). Last edit at 07/09/2010 09:34PM by ds160384.

I quote "InnoDB: This might be a backup or antivirus software or another instance ", so can you try without any antivirus, on both computers ?

Sorry not possible! Two Computers at work.

Only to try... after you can install it again ;)

If you want, you can try to disable it before ?

That's a freak idea to use same file set on network drive for 2 different mysql instances. It can't work. Use mysql replication capabilities.

You think 2 MySQL are opened together ?