Removed local database from phpmyadmin by mistake

[Soulkreed]

Forgot to mention this, I have been trying to find the configure.php file from a new zen cart to overwrite the corrupted configure.php file in admin/includes.... on my current installation and i am unable to track it down, it's just not there anywhere..mystery to me.

All the configure.php files are there on my current store ( both in my admin/includes and my includes.. ) but not visible anywhere on a new zen cart ( one that i unzipped solely for taking out files )

Cheers.

[RodG]

Forgot to mention this, I have been trying to find the configure.php file from a new zen cart to overwrite the corrupted configure.php file in admin/includes.... on my current installation and i am unable to track it down, it's just not there anywhere..mystery to me.

All the configure.php files are there on my current store ( both in my admin/includes and my includes.. ) but not visible anywhere on a new zen cart ( one that i unzipped solely for taking out files )

Cheers.

The configure.php files are created during the installation process so you won't find them in the distribution package.

You *should* have uncorrupted copies on your local machine from the first installation that you did though. Just use those (making sure you update the various settings to match what is needed for your dot easy installation.

If for some reason you DON'T have a local copy, you can also use the files named "dist-configure.php" for recovery purposes (just make a copy and then rename to configure.php). Don't just rename these (as some people have done) because you never know when you may need them again.

Cheers
Rod

[RodG]

Hi,
I am unable to log back in, I don't know how to do it, sorry.
I only have one screen ( phpmyadmin-local ) that I go to when i click on the saved url in my favourites. This screen is no longer looking like it used to. Is it possible to show you a picture of the screen i am looking at which may shed some light on this?

Sure.

In regards to deleting and re-installing a new mysql installation, i wouldn't know where to begin, any clues please?
Cheers

Uninstalling should be possible from your windows control panel add/remove programs (or whatever Windoze calls it these days).

To re-install, just repeat the process you used the first time you installed it.

Also, if you are lucky, the 'uninstall' process may even give you an option to 'repair' the installation - If so, I'd be trying that out before doing an uninstall/re-install. Sorry I can't be any be explicit or definitive about this, but I don't run windows so I can't verify it for you.

Cheers
Rod

[Soulkreed]

Hi Rod,
thanks mate and evryone else for all your help, very much appreciated.
I did the configure.php overwrite of the corrupted one with the original version and there were a few little things i needed to fix which i did. It is now giving me this below

0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any clues...?

I am unable to find anywhere in my windows add/remove anything remotely that looks like a mysql file/folder/program, unless it's named something completely different.

I can't remember how to do the print screen thing to show you a copy of what the phpmyadmin page is now looking like ( i press the print screen button and then what...? ) but here is an attempt with the ctrl c and paste of the actual phpmyadmin screen, hope it sheds some light,

Welcome to phpMyAdmin 2.6.4-pl1

MySQL 4.1.14-nt running on localhost as root@localhost
phpMyAdmin - Logo
MySQL
Create new database Create new database: Documentation
No Privileges
Show processes Show processes Documentation
Character Sets and Collations Character Sets and Collations
Storage Engines Storage Engines
Databases Databases
Export Export

phpMyAdmin
Language
Language Info:
MySQL charset MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation
MySQL connection collation: armscii8_binarmscii8_general_ciascii_binascii_general_cibig5_binbig5_chinese_cib inarycp1250_bincp1250_croatian_cicp1250_czech_cscp1250_general_cicp1251_bincp125 1_bulgarian_cicp1251_general_cicp1251_general_cscp1251_ukrainian_cicp1256_bincp1 256_general_cicp1257_bincp1257_general_cicp1257_lithuanian_cicp850_bincp850_gene ral_cicp852_bincp852_general_cicp866_bincp866_general_cicp932_bincp932_japanese_ cidec8_bindec8_swedish_cieuckr_bineuckr_korean_cigb2312_bingb2312_chinese_cigbk_ bingbk_chinese_cigeostd8_bingeostd8_general_cigreek_bingreek_general_cihebrew_bi nhebrew_general_cihp8_binhp8_english_cikeybcs2_binkeybcs2_general_cikoi8r_binkoi 8r_general_cikoi8u_binkoi8u_general_cilatin1_binlatin1_danish_cilatin1_general_c ilatin1_general_cslatin1_german1_cilatin1_german2_cilatin1_spanish_cilatin1_swed ish_cilatin2_binlatin2_croatian_cilatin2_czech_cslatin2_general_cilatin2_hungari an_cilatin5_binlatin5_turkish_cilatin7_binlatin7_estonian_cslatin7_general_cilat in7_general_csmacce_binmacce_general_cimacroman_binmacroman_general_cisjis_binsj is_japanese_ciswe7_binswe7_swedish_citis620_bintis620_thai_ciucs2_binucs2_czech_ ciucs2_danish_ciucs2_estonian_ciucs2_general_ciucs2_icelandic_ciucs2_latvian_ciu cs2_lithuanian_ciucs2_persian_ciucs2_polish_ciucs2_roman_ciucs2_romanian_ciucs2_ slovak_ciucs2_slovenian_ciucs2_spanish2_ciucs2_spanish_ciucs2_swedish_ciucs2_tur kish_ciucs2_unicode_ciujis_binujis_japanese_ciutf8_binutf8_czech_ciutf8_danish_c iutf8_estonian_ciutf8_general_ciutf8_icelandic_ciutf8_latvian_ciutf8_lithuanian_ ciutf8_persian_ciutf8_polish_ciutf8_roman_ciutf8_romanian_ciutf8_slovak_ciutf8_s lovenian_ciutf8_spanish2_ciutf8_spanish_ciutf8_swedish_ciutf8_turkish_ciutf8_uni code_ci Documentation
Theme / Style
Theme / Style:
phpMyAdmin documentation phpMyAdmin documentation
Official phpMyAdmin Homepage Official phpMyAdmin Homepage
[ChangeLog] [CVS] [Lists]
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

I don't know what alot of this extra stuff is here in the middle but it certainly isn't on the page i just copied, perhaps it just shows up when copying and pasting.

Ciao for now, Ash.

[RodG]

I did the configure.php overwrite of the corrupted one with the original version and there were a few little things i needed to fix which i did. It is now giving me this below

0 DB_ERROR_NOT_CONNECTED

A part of the configure.php files (there are TWO of them) specifies the logon details (and a couple of other things) for the database. Did you set these correctly? Both files?

I am unable to find anywhere in my windows add/remove anything remotely that looks like a mysql file/folder/program, unless it's named something completely different.

Time to stop and take a step or two backwards.

You are telling us things in one message that may require specific actions that you need to take to correct the problem, yet in other messages, (such as this one) you are providing information that shows without a doubt that the information originally supplied was incorrect or incomplete, and as such you are basically digging yourself into a deeper and deeper hole.

Welcome to phpMyAdmin 2.6.4-pl1

MySQL 4.1.14-nt running on localhost as root@localhost
<snip>
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account.

The latest problem we were trying to solve was your inability to login to
phpMyAdmin, which was supposedly caused by the incorrect changing of the mysql administrator priviliges.(and this was in an attempt to fix yet another issue entirely). The 'last resort' option to fixing the login issue was to be to re-install your mySQL database.

You have now shown us positive proof that you CAN log into phpMyAdmin (and therefore the mySQL database), so the re-install is now a moot point. It also totally contradicts what you told us in the first place.

I really don't know what to tell you from here, as I said, you are providing misleading information (albeit, not intentional), and based on this information I/we are giving you answers that you don't need, which you are acting upon anyway, messing up even further when doing so, and in short getting further and further away from the original problem (inability to import your backup data).

So, you tell me .... where do you want to go from here? I no longer even know where to start

Cheers
Rod

[Soulkreed]

Hi Rod,
i am unsure of what to do myself. I simply cannot for reasons most likely of my own lack of knowledge here in regards to certain procedures and the like, navigate my way around the phpmyadmin page/s, a couple of the things you have asked me to do I have no knowledge of them and i am trying to find these things to put the actions into place you have suggested. I am already logged in as you have seen by my previous post ( cool ) i knew i was logged into something i just didn't know if it was the right one or not. ( that's that out of the way then ) In regards to re-installing the mysql file as described by vger below

[ quote = vger ]

When, in your local phpMyAdmin, you could not see the 'Import' tab this was not unusual. If you have an older version of phpMyAdmin then what you'll see is an 'SQL' tab, which you click on. Then you see a Browse link, which you click on. Then you locate the backup of your online db which you downloaded - and select that. Then you click 'Go' and it imports the backup.

It's no more complicated than that.

Vger

[ / quote ]

I no longer have these options on my screen at all, the only thing that is there that say's SQL is a query window and a documentation window, ntohing that opens to a browse option or anything remotely like that, none of the other tabs lead to anything at all like the option explained by vger, it just isn't there.

Cheers

[RodG]

Hi Rod,
i am unsure of what to do myself.

OK, The FIRST thing you need do is realise that you have more than one problem that needs to be solved.

In MY opinion, your 1st priority would be to fix the DB Connection issue on your dot easy server. This is almost certainly caused as a result of those corrupted configure.php file(s).
I know you have already restored these from local(?) backups, so I'm suspecting that these simply need to be re-edited so the correct user/password & database settings are used.

The NEXT problem you need to fix will be your *local* database problems.

I cannot navigate my way around the phpmyadmin page/s,

I *suspect* that this is caused by the erroneous changing of the admin/root privileges for your mySQL database. IF this suspicion is correct, you should be able to resolve the issue by following the details I'm about to give:

1. Using phpMyAdmin log into your mySQL database as the root user.

As long as you can see " MySQL 4.1.14-nt running on localhost as root@localhost" (as per your earlier post) you may proceed.

If you DON'T see this text, then don't continue. It will be pointless.

2. You should now also see ......

the only thing that is there that say's SQL is a query window and a documentation window,

If so, click on (or enter) the SQL query window, which should be displaying a large input screen with a heading like:

"Run SQL query/queries on server localhost"

If so, continue ... if not .... abort.... go no further.

3. Cut and paste the following piece of code into the SQL input box.

GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost' ;

Press the "Go" button.

If you get an error message, take note of what it says and get back to me.

If successful, click on the 'home' icon of phpMyAdmin and logout. (you must use the logout button - don't just close the browser window)

Finally, log back in.

All being well your phpMyadmin will now be restored. .

At this point I would suggest you take a break, and get back to me to confirm that all is as I expect it to be (or not, whichever the case may be).

If you do have problems, screenshot will help.

Cheers
Rod

[Soulkreed]

Hi Rod,
i did have some different username etc on the configure.php overwrite file which have been rectified ( at least i think they have at any rate - i can now get into admin but still not able to turn on or off any side boxes etc or have any of my products show up in categories/products in admin/catalog ) I can't see the results reflected in my store front.
I had a look at the sql query screen as suggested and found a table in sql query that has three tabs up the top
1) SQL 2) IMPORT FILES 3) SQL HISTORY

there is a box section under that that has as it's heading

Run SQL Query / Queries on database

( this was very similar to the one you mentioned may be there)
I put into the box the info you gave and this is what came up below

Error

SQL query:

GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost'

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
[ Back ]

I don't seem to be able to get the screen shot to work, is there a trick to it?

Cheers.

[RodG]

Hi Rod,
i did have some different username etc on the configure.php overwrite file which have been rectified

Did you check this in BOTH configure.php files

/includes/configure.php and
/admin/includes/configure.php

( at least i think they have at any rate - i can now get into admin but still not able to turn on or off any side boxes etc

This may be a security issue.

I can't see the results reflected in my store front.

This may be a result of the /includes/configure.php file not having correct information.

Note: I said *MAY* in both instances ... There could be any number of other possible causes. In any case, it is essential that both your configure.php files are 100% correct before looking into any other problem. I will once again repeat, although the both configure files share the same name they have similar but different content. They are NOT interchangable,


Re: problem with local mysql.

Error
SQL query:
GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost'

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

OK, this looks like you really did modify the root (admin) account so that it no longer has permissions to grant permissions, even to itself. There probably ARE ways that this can still be corrected without doing a complete re-install, but I'm really not familiar enough with the Windows versions of mySQL (or its various tools) to be able to guide you.

There are MANY threads to be found on Google with suggestions on how to fix this, for example.

... but in all honesty, knowing that there is probably nothing in your database that needs to be saved, you may simply be best of doing a reinstall. Your current installation is V4.1 anyway, while the currently recommended installation is V5.1.x .

You can download V5.1.x from here.

There are several different windows 'packages' to choose from, I would suggest you use the one called "Windows MSI Installer (x86)"

Cheers
Rod

[Soulkreed]

Hi Rod,
I believe that both admin/includes/configure.php and includes/configure.php have the same info ( hope so, I can't see anything at any rate)

I have downloaded a copy of the mysql V5.1 with windows msi installer, I am unsure of what to do now.

Cheers.