I transferred my website from X server to Y server and it is working. However, my user does not have right of admin. I am missing some tabs like theme,options,logs etc.

1. Can I give admin right to my user from mysql?

Thanks

No, you have to login with the master account and assign that rights to the user. If you don't know that anymore you have to follow the instruction to reset the users as described on our troubleshooting.

Well, actually with MySQL PHPMyAdmin access you can give your user full rights. Look at the administrators table. There should be an entry there for "Administrators". Copy the rights field from this entry to the user you want to have full rights.

[edit] But of course, using a tool like PHPMyAdmin will also allow you to screw things up pretty well if you make a mistake. Make backups first and be very careful!

In the permission(right) table the user has already the same number like administrator. However, still, I dont have access to themes,options etc

I suggest to follow the troubleshooting entry to reset it all manually. Delete the administrators table and re-run setup. Then you can enter a new user name and password that has full rights.

Thanks I solved as:
My Source Server(x) had lower version of ZPHOTO and Destination has Newer version. After transfering data to the new server. It could not recognize that permission. So I installed new version in my Localhost and did see the database parameter and copy it to my live. now it is working.
Let me know if I could not explain this better for other users?

Thanks

We will add to our troubleshooting entry that the Zenphoto versions must be the same.

Yes there was the same version. But, It is ok now evern with newer version just I replaced the rights

Thanks a lot for your support