Removed local database from phpmyadmin by mistake

[RodG]

Do you have the 'query', 'export', 'operations' and 'privileges' buttons, or are they missing too?

I have query, export, operations but no privileges.

Aha! A clue. Are you logging into phpMyAdmin using the *mysql* administrator password, or the zencart administrator password?

I'm guessing you are using the zencart admin password (which is a 'regular user' as far as MySQL is concerned), therefore there are security restrictions in place.

When you first installed MySQL (which you would have done before it was possible for you to install zencart) you would have had to specify a MySQL 'root' or 'admin' name & password.. These are what you need to use when logging in with phpmyadmin. (There are other methods to gain the required access, but this is the easiest in your case).

Re: Database transfers.
When I am in the filezilla ( ftp ) transfer program the files are all still there on my local and I just transfer them over to my live dot easy account etc.

Filezilla will transfer your zencart *files* without problem, but I seriously doubt that you are using it to transfer your *database*.

You *may* be able to transfer the *database* from your local machine to the dot easy server, but I can assure you that you will not have permission to place them where they need to be. Also, it is very unlikely that you'll have enough access rights to even view the 'active' database file on the dot easy server (and even less chance of actually copying it back to your local machine). This is why you need a 'tool' such as phpMyAdmin to act as a 'middleman' in order to store/retreive data from the database itself.

I apologise if this all sounds confusing to you. I'm really not trying to overcomplicate the situation, it is just the way it is.

Cheers
Rod

[RodG]

Want to ask you how you get all the quotes up and then comment after them, i have tried and can't work it out?

When you reply to a posting you'll note that the original text starts out with
something like [ quote = username ] and ends like [ / quote ]

All you need do is copy these 'tags' around the individual sections of the message that you wish to quote. (I tend to use a cut 'n' paste) rather than typing them each time.

Cheers
Rod

[Soulkreed]

Hi Rod,

Aha! A clue. Are you logging into phpMyAdmin using the *mysql* administrator password, or the zencart administrator password?

I'm guessing you are using the zencart admin password (which is a 'regular user' as far as MySQL is concerned), therefore there are security restrictions in place.

Rod

I am just clicking on the saved address/link i have of my local phpmyadmin, not sure if it's my sql or the standard zen cart one ( i have found a tab at the bottom left of the phpmy admin that says ' priviledges )

Rod I am getting this warning/message at the bottom of the phpmyadmin front page


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.

Does this help us at all my friend? I looked at trying to put a password on it and fix it up but i can't find anywhere that tells me how to do it.

Cheers.

[Soulkreed]

Hi again,
sorry to put this in here, it is from another post but I need to find out if I still need to re-install a new copy of it or not.



Default Re: Remove CC & Cheque from payment screen help


[ quote = Soulkreed]Hi Rod,
I wrote down the wrong names in my last message sorry ( admin/inlcludes/configure.php ) is what i meant to write not ( includes/configuration.php ) ( this is what too many hours on the computer can do to you, lol ) The writing that turned into chinese was from the admin/includes/configure.php file, shall i do as you have suggested and reload an original copy ( checking for any variants and changing them ) and see if this has an effect? or did you mean to only re load it again if the file was the configuration.php one?

There is also no file with the name configuration.php in the directory of admin/includes....., just thought i'd let you know if that makes any kind of difference.
Cheers.
[ / quote ]

Thanks.

[RodG]

I am just clicking on the saved address/link i have of my local phpmyadmin, not sure if it's my sql or the standard zen cart one

It's the same phpMyAdmin either way..... Oh, you mean your not sure if it is logging you in as the zencart user or the mysql user, don't you?

( i have found a tab at the bottom left of the phpmy admin that says ' priviledges )

This would suggest you are logged in as the mysql 'admin' user.

To confirm this, if you click on the 'home' link at the top of the phpmyadmin screen you should see something like the following near the top of the main panel

• Server version: 5.0.77-log
• Protocol version: 10
• Server: Localhost via UNIX socket
• User: xxxxxxxxx@localhost

If the 'user' is the same as your zencart username then you will have restricted access.

However.......

I am getting this warning/message at the bottom of the phpmyadmin front page

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account.

.... this is clear indication that you are logged in as the main mysql user ,,, at least on this occasion ... with this login the 'import' function should almost certainly be available to you.

Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

I wholeheartedly agree with this advisory. However, as long as your localhost has a firewall of some sort in place and isn't *directly* connected to the internet the chances of this security hole being exploited are pretty low. Nonetherless, when you gain more experience I do suggest you set a password for this logon as an additional layer of security.

I looked at trying to put a password on it and fix it up but i can't find anywhere that tells me how to do it.

This one isn't obvious... it is *usually* set when MySQL is first installed. To set it after the fact you need to select 'priviliges', then identify the name of the master/root user account (you'll probably only have a couple of users listed anyway). The master/root user will (or should) show as having "all priviliges" - next, click on the 'edit' icon on the right hand column, rhen midway down the page there is a 'change password' option.

All of the above is a 'by the way' or a 'while you are at it' suggestion while you are trying to fix your main issue, which is the missing import function.

As previously stated, the 'import' option should be available to you by default while logged in as 'root'.. if not, then the 'all priviliges' probably won't be seen either.. to fix this, you'll still need to identify the root user account, again, select the 'edit' icon on the right hand side of the screen, and then click on the 'check all' link in the 'global privileges' section.

With this done you should then be able to 'import' data into any and all tables in the database.

This however is considered to be bad practice (using the root/admin account needlessly).

What you *really* want is to give the 'zencart' user permission to import data into the zencart tables.

To do this, from the original 'priviliges' link, identify the zencart user, as before, click on the 'edit' icon at the RHS of the screen, and in the 'global priviliges' section located the 'data' block, and tick the 'file' checkbox (and no others). Save the changes, log out of phpmyadmin and re-log in using the zencart user account. The 'import' function should now appear.

Note: for any SQL pedants reading this, I know that even this isn't the most secure method to use, and that it is better to restrict by database and even table level, but do you want to explain it?)

Anyway, by following these instructions you should be able to be in a position to import the backup of your database tables.

I will also suggest that as long as you are logged in with 'root' access you *should* be able to import the data anyway, which means you don't NEED to do any of the above unless you are concerned about the potential security risks, which as I also stated, are pretty minimal in your situation anyway..

The main points to note are that there will (should) be at least two userr accounts, the main/root account, and another account for the zencart user. The root account should give FULL access to everything, the zencart account will have restricted access (no import ability being one such limitation).

<phew> That should keep you busy for a bit :-)

Cheers
Rod

[RodG]

The writing that turned into chinese was from the admin/includes/configure.php file, shall i do as you have suggested and reload an original copy ( checking for any variants and changing them ) and see if this has an effect?

Hmmm, yes.. the file "admin/includes/configure.php" should be a regular .php file, in English. Anything else would indicate a corruption of some sort.

or did you mean to only re load it again if the file was the configuration.php one?

The configuration.php file is also a regular .php file, in English. This file isn't one that is normally edited, but if it is also 'chinese' then it too needs to be replaced with an original copy.

There is also no file with the name configuration.php in the directory of admin/includes....., just thought i'd let you know if that makes any kind of difference.
Cheers.

A file of that name is not supposed to be in that directory, so in this case things can be considered 'normal'. If there WAS a file of that name in that directory it may or may not have adverse effects on the store operation... it would however indicate that there is probably more amiss with your installation than it first appears).

Cheers
Rod

[Soulkreed]

Hi Rod,
I have buggered up your instructions below

To do this, from the original 'priviliges' link, identify the zencart user, as before, click on the 'edit' icon at the RHS of the screen, and in the 'global priviliges' section located the 'data' block, and tick the 'file' checkbox (and no others). Save the changes, log out of phpmyadmin and re-log in using the zencart user account. The 'import' function should now appear.

Cheers
Rod

Instead of ticking the ' file ' box in the zen cart user edit section i ticked the ' file ' box ( and no others ) in the root account and now have no databases or anything remotely similar to how it used to look ( i think i am screwed )

Any suggestions....

[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

[RodG]

Instead of ticking the ' file ' box in the zen cart user edit section i ticked the ' file ' box ( and no others ) in the root account and now have no databases or anything remotely similar to how it used to look ( i think i am screwed )

Any suggestions....

Yes. Just log back in as the root/admin user, select 'privileges', tick *everything* in the global privileges section (use the 'check all' link)

Save your changes and you should be back where you were before you made the change.

As long as you can get back to this stage, try following vger's instructions .. personally I can't recall the 'import' tab not being visible on the older versions of phpMyAdmin, and knowing that you have a pretty new installation this possibility didn't even occur to me anyway.
(Thanks vger. Something worth remembering).

Anyway Soulkreed, even if you can't restore back to how things were before you can move forward, you still have another option.

As far as I'm aware from our previous discussions, the only thing you are currently using your mySQL database for is Zencart, correct? and since it is the zencart data you wish to restore I can see no reason why you couldn't just delete your current mySQL installation, reinstall it, and start afresh if you need to.

FWIW, when I first starting learning mySQL I probably trashed my databases/installation at least a dozen times (or more) before I came to grips with what I could and should change, and what I should leave alone. I must admit it was very frustrating at the time, but I really did learn a lot more than if I'd just blindly followed instructions and never had a problem. Your early 'screw ups' will eventually turn out to be to your benefit.

Cheers
Rod

[Soulkreed]

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?

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

Cheers