WampServer

All I can find on google is reports that mysql 5.5 didnt like hyphens - in tables names and if they existed it would generate this message

Here are a couple pages that mention a fix

[www.trevoroconnell.com]
[www.brandonchecketts.com]


That does not explain why it worked before in the same version of MySQL as you are using now, which I am starting to wonder about!

So do you have tables names in that database that use the hyphen seperator for example tbl-fred? If so try the fix mentioned in the above 2 documents

---------------------------------------------------------------------------------------------
(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-

Ok, I found a file at the top of the list of databases in myphpadmin that is right above the non working database, and it is named: #mysql50#default files

SO what is that??? that name matches the error in sql log, which is generated every time I look at my databases in myphpadmin. I click on it, no tables, or doesnt look like anything. Could this be the prob?

Could be, try getting rid of it.

---------------------------------------------------------------------------------------------
(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-

I get the following error trying to "drop" it:

SQL query: Edit Edit

DROP DATABASE `#mysql50#default files`

MySQL said: Documentation

#1010 - Error dropping database (can't rmdir '.\default files\', errno: 17)

Take a look at the \wamp\bin\mysql\mysql.x.y.z\data folder. You will probably find there is a directory under there with that name or something similiar.

Delete it or copy it somewhere else.

Mysql looks at all subdirectories of \wamp\bin\mysql\mysql.x.y.z\data and assumes they are holding databases. Maybe somthing about your crash or previous attempts at recovery created a strange folder under there and it is confusing MySQL's restart/recovery process.

---------------------------------------------------------------------------------------------
(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-

ok, renamed it to default_files, and that problem has gone away, still get error establishing a database connection for the site we have been trying to get back up.

In myphpadmin the renamed database comes up now as default_files instead of #mysql50#default files, and in sql log this is what I am seeing now:

140905 8:57:22 [Note] wampmysqld: Shutdown complete

140905 8:57:23 [Note] Plugin 'FEDERATED' is disabled.
140905 8:57:23 InnoDB: The InnoDB memory heap is disabled
140905 8:57:23 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140905 8:57:23 InnoDB: Compressed tables use zlib 1.2.3
140905 8:57:23 InnoDB: Initializing buffer pool, size = 128.0M
140905 8:57:23 InnoDB: Completed initialization of buffer pool
140905 8:57:23 InnoDB: highest supported file format is Barracuda.
140905 8:57:23 InnoDB: Waiting for the background threads to start
140905 8:57:24 InnoDB: 1.1.8 started; log sequence number 10833391970
140905 8:57:25 [Note] Server hostname (bind-address): '(null)'; port: 3306
140905 8:57:25 [Note] - '(null)' resolves to '::';
140905 8:57:25 [Note] - '(null)' resolves to '0.0.0.0';
140905 8:57:25 [Note] Server socket created on IP: '0.0.0.0'.
140905 8:57:25 [Note] Event Scheduler: Loaded 0 events
140905 8:57:25 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)

And when I type in the not working site, i get error establishing database connection. When I add /wp-admin to the url I get:

Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?

SUCCESS!!! I got it. So I took a look at the wp-config and compared it to one of the working databases wp-config and the difference was: database username and database password (the working one was "root" so I changed that to root, and password was empty just two ticks so I changed that) Site is now up.

Ok, now how to back up and export so I can upgrade to the current version? Also, curious about this error I see in my apache error log:

" AH01797: client denied by server configuration: C:/wamp/www/, referer: [www.insecam.com];

and this one:

3316:tid 604] [client 117.86.197.60:55777] AH01797: client denied by server configuration: C:/wamp/www/render, referer: [hotel.qunar.com]
[Wed Sep 03 04:12:38.452237 2014] [access_compat:error] [pid 3316:tid 604] [client 110.45.241.238:50660] AH01797: client denied by server configuration: C:/wamp/www/cfg
[Wed Sep 03 07:44:19.548699 2014] [access_compat:error] [pid 3316:tid 760] [client 202.90.198.68:19454] AH01797: client denied by server configuration: C:/wamp/www/eiei
[Wed Sep 03 07:44:20.047727 2014] [access_compat:error] [pid 3316:tid 760] [client 202.90.198.68:19509] AH01797: client denied by server configuration: C:/wamp/www/phpMyAdmin
[Wed Sep 03 07:44:20.572757 2014] [access_compat:error] [pid 3316:tid 760] [client 202.90.198.68:19593] AH01797: client denied by server configuration: C:/wamp/www/pma
[Wed Sep 03 07:44:21.080786 2014] [access_compat:error] [pid 3316:tid 760] [client 202.90.198.68:19643] AH01797: client denied by server configuration: C:/wamp/www/myadmin
[Wed Sep 03 10:27:24.234351 2014] [access_compat:error] [pid 3316:tid 748] [client 66.249.79.64:47134] AH01797: client denied by server configuration: C:/websites/gleamla/wp-content/uploads/sl-uploads

the referer in both of those seam odd, is that normal? hotel qunar and insecam???

Thank you so much!!

That woudl appear to be someone trying to hack your site by looking for known compromises.

---------------------------------------------------------------------------------------------
(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-

having the same trouble here too.. please help @Riggsfolly

am getting "Error establishing a database connection" after reinstalling wamp server and moving all the web sites from the old and broken backup to the newly installed and working system.

the new WampServer has the same version of MYSQL as the old.

am running a wampserver 2.4 -- 32 bit on windows 8 and have microsoft windows redistributable x86 installed.

Lets have a look at your MYSQL Error log please.

---------------------------------------------------------------------------------------------
(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-