vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Fortunately, I'm learning MySQL on my home machine, so this MEGA-Mistake doesn't sink a Fortune 500 corporation. I was experimenting with a batch file that ... (1) Created a set of user accounts with tiered privileges, (2) Set passwords for the new accounts, and then (3) Displayed the grants for these new accounts on the command line. The last few lines of code took advantage of a new security tip I had just learned--change the name of the root account to something unguessable and then give the disguised root account a new password. I was running this file over and over again to debug it, dropping new users left and right, and ... oops ... not recognizing the off-the-wall new name I had given to the root account, I Dropped the root account. Duhhhhh. I deleted MySQL server and client 5.0, rebooted, then reinstalled server and client 5.0 with Synaptic. I still seem to be locked out, however. Are there some configuration files that are clinging to Linux that I need to manually delete in order to get a installation with a password-less root access? |
| ||||
| On 6-mei-2007, at 0:37, John Kebbel wrote: > Fortunately, I'm learning MySQL on my home machine, so this > MEGA-Mistake doesn't sink a Fortune 500 corporation. > > I was experimenting with a batch file that ... > (1) Created a set of user accounts with tiered privileges, > (2) Set passwords for the new accounts, and then > (3) Displayed the grants for these new accounts on the command line. > The last few lines of code took advantage of a new security tip I had > just learned--change the name of the root account to something > unguessable and then give the disguised root account a new password. > > I was running this file over and over again to debug it, dropping new > users left and right, and ... oops ... not recognizing the off-the- > wall > new name I had given to the root account, I Dropped the root account. > Duhhhhh. > > I deleted MySQL server and client 5.0, rebooted, then reinstalled > server and client 5.0 with Synaptic. I still seem to be locked out, > however. Are there some configuration files that are clinging to Linux > that I need to manually delete in order to get a installation with a > password-less root access? > Maybe I'm going to tell you nothing new, but what the heck.. There are two ways to deinstall with synaptic: remove and purge. Remove leaves the config files, purge tries to get rid of everything. Try to purge mysql and then reinstall. Then there should be no lingering configs anymore. Peter |