By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

locked myself out of my database

P: 19
I've locked myself out of my database. I was trying to connect to mysql and decided to create a new user with full privs, then remove privileges from root, as i know the db server shouldn't be running at root ( a tutor set it up for me). the server is still runnning as root and i cant fix it! :( I'm using phpmyadmin on a uniserver. Please can anyone help me get back in? i can open the phpmyadmin page but cant do anything as it says 'no privileges'
thanks
Diz
Mar 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: 19
Diz
i fixed this problem by saving the www and database table files files from the server to another location, then uninstalling and reinstalling the server, then putting the files back. Had to do all of the queries again tho..... :rolleyes:
Apr 5 '06 #2

Expert Mod 100+
P: 2,327
You got it working? I've had to use similar methods before when i got locked out. It's also a good way to move large databases. If you don't want to run a long dump. Just copy the database folder.

:-)
Apr 5 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.