[ LUGOS ] mysql vprasanje

[MadDave]

Hellow !

Da se lahko povezuje brez gesla:

mysql -u root -p

connect mysql
update user set Password = '' where User = 'Uporabnik';
flush privileges;

Da ga izbrises:

mysql -u root -p

connect mysql
delete from user where User = 'Uporabnik';
flush privileges;


lp, MadDave 

----------------------------------------------------------------------
|Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.|
----------------------------------------------------------------------
| > FreeBSD < - > Power to SERVE <                                   |
----------------------------------------------------------------------
| Open source software - with no walls and fences, who needs Windows |
| and Gates?							     |
----------------------------------------------------------------------

On Tue, 29 Feb 2000, Bostjan Muller wrote:

> Pozdravljeni!
> 
> Zanima me kako bi nekemu uporabniku za mysql bazo, ki ima dodeljeno geslo
> omogocil, da se povezuje brez gesla (vem, da je to security risk, vendar je
> baza popolnoma izolirana od kake eksterne mreze).
> Oziroma ce to ni mogoce, kako bi uporabnika odstranil (popolnoma) iz mysql-a?
> Prebral sem ze vse kar sem nasel, pa nikjer ne pise kako odstranis, vedno le
> kako dodas userje ali gesla.
> 
> Vnaprej hvala!
> 
> Bostjan
> -- 
>  Boštjan M&uuml;ller [NEONATUS], NEONATUS na bigfoot.com, http://surf.to/NEONATUS
>  RSA id: 0x90178DBD, ICQ #:7506644, PGP key: finger neonatus na gimp.thz.net
> GEEK CODE = PGP key Registered Linux User #87774, Powered by SuSE Linux 6.2
>         Don't hate yourself in the morning -- sleep till noon.        
>