List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:May 28 1999 5:16pm
Subject:Re: Grant tables & db question
View as plain text  
sflist wrote:
> 
> Hi,
> 
> 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? ;-)
> 
> Thanks,
> 
> Steve Freitas

Hi Steve

You have to reload the priviledges after changing them directly.
Use:
mysqladmin -u root -ptest flush-priviledges

After this the "new" settings are active.

Tschau
Christian

Thread
Grant tables & db questionsflist28 May
Re: Grant tables & db questionChristian Mack28 May