Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
help me plz lost my database
Posted by: makxri (85.75.148.---)
Date: April 17, 2007 10:21AM

hi guys!
I think i made a stupid mistake...
first of all i use wamp5 latest version
In phpmyadmin i have created a database( called voiot) and a user (mak) with all privileges.
Then in phpmyadmin i selected my database (voiot) and in privileges which has the user mak and the user root i pressed on the root and i unmarked all the options in it.
After that i saw that in main phpmyadmin in the left position all the databases have been lost and in the center of the page said that ''create database with no privileges''and also there was no users...
Im new in phpmyadmin and sql

in c:\wamp\mysql\data there is in a folder my database

plz help me how to recover my database and the users

Options: Reply•Quote
Re: help me plz lost my database
Posted by: CyberSpatium (71.237.217.---)
Date: April 17, 2007 07:28PM

if you attempted to drop a database in phpmyadmin it would put up a popup window asking you if you really wanted to delete the database. and if you did delete (aka drop) a database mysq does not make a backup of it, it just deletes it. so you cannot get it back if you deleted it. you may have set the permissions incorrectly

if you have this folder C:\wamp\mysql\data\voiot then the database has not been dropped.

to see how to set permissions correctly see my wamp manual.


CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!

Please visit my latest website Clarify Loans:
clarifyloans.com

Options: Reply•Quote
Re: help me plz lost my database
Posted by: yfastud (72.236.169.---)
Date: April 17, 2007 07:34PM

The problem is he eliminated the root's privilege, so now he's really in deep....

Have fun,

[www.jlbn.net] (testing WAMPS)
[test.jlbn.net] (testing codes)

Options: Reply•Quote
Re: help me plz lost my database
Posted by: CyberSpatium (71.237.217.---)
Date: April 17, 2007 10:44PM

if that is the case the easiest solution to fix that problem is to uninstall wamp, delete the c:\wamp folder, reinstall wamp

CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!

Please visit my latest website Clarify Loans:
clarifyloans.com

Options: Reply•Quote
Re: help me plz lost my database
Posted by: yfastud (---.cable.mindspring.com)
Date: April 18, 2007 01:01AM

If your db doesn't have any data yet, just do as cyber's suggestion, but if it does, instead delete wamp folder, just install new wamp over old wamp folder, but before doing this, make sure to copy that old wamp folder to somewhere safe first, in case you might need it later.

Have fun,

[www.jlbn.net] (testing WAMPS)
[test.jlbn.net] (testing codes)



Post Edited (04-18-07 02:03)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: help me plz lost my database
Posted by: makxri (88.218.73.---)
Date: April 20, 2007 11:37PM

thanks guys for your help.
i just go to c://wamp/phpmyadmin/config.inc and i replace the user root with user mak and the problem fixed.

Options: Reply•Quote
Re: help me plz lost my database
Posted by: yfastud (---.mia.bellsouth.net)
Date: April 20, 2007 11:42PM

Only if user Mak has all privileges, if not, you can guess what might happen... he he... he he... ;-)

Have fun,

[www.jlbn.net] (testing WAMPS on Vista)
[test.jlbn.net] (testing codes on Vista)

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login