> I'm a new MySQL user. (And if you don't believe that now you will after
> you've read this! ;-))
> My setup: RH 5.2 (Mandrake dist) and the MySQL 3.22.22 i386 RPM server
> and client.
> After it installed, I did: mysqladmin -u root password 'test'
> That went fine, and it now required a password to get into mysql (the
> shell script). Then I wanted to change the password back to nothing.
> After fruitlessly trying it from the command line a few ways, I went into
> mysql.user and updated the password for root@localhost to be blank.
> The result was that it still wanted the password. Why does this occur?
> How can I make a password blank?
> Another question: I've uninstalled and reinstalled MySQL a few times
> trying different things. I wanted to save a test database I'd made, so I
> went into /var/lib/mysql, pulled out the relevant database folder, then
> uninstalled everything. Then I placed that folder back into
> /var/lib/mysql, but it doesn't seem to like it much now -- it gives me:
> Can't read dir of './itest' (Errcode: 13)
> Looked in the manual and couldn't find that error code or whether copying
> databases as I did should work. Can anyone lower themselves to explain
> this to a novice who hasn't read the entire manual yet? ;-)
> Steve Freitas
You have to reload the priviledges after changing them directly.
mysqladmin -u root -ptest flush-priviledges
After this the "new" settings are active.