Posted By: znouza (ILoveSanFrancisco) on 'CZscripts'
Title:     Re: Mysql spravovani
Date:      Fri Aug 31 09:45:47 2001

> Co musi udelat root, aby pridelil nejakemu uzivateli: user heslo: passwd v 
> MySQL na unixu nejakou databazi? a ten k ni mohl pristupovat?
> 
> Nejaky to mysqladmin -u user -p passwd  create databasename bla bla... D'
> 
>                       ...koneckoncu vse zalezi na uhlu pohledu.
> 
> sedivy@seznam.cz
> http://www.fi.muni.cz/~xsedivy

-zalozit databazi

create database

-udelat 'grant'..

grant all on database.* to uzivatel identified by 'heslo';

mysqladmin -proot -uheslo flush-privileges
                                             - znouza -
--
  At a higher altitude with flag unfurled
  We reached the dizzy heights of that dreamed of world...
                                                          --

Search the boards