MySQL --- nastaveni prav databazim

[linux_lukas na atlas.cz]

Ahoj linux,

  Pokousim se nastavit prava normalnimu uzivateli v mysql tak abych mu
  zalozil databazi jako uzivatel root a on si vevnitr databaze mohl
  delat co chtel ale stou podminkou ze nemuze smazat databazi muze
  mazat a vytvaret jenom tabulky. tady níže
  je tabulka user.
  --------------------------------------------------------------------
---------------+------+------------------+------------+--------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host         | User | Password         | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+--------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost    | root | sifra            | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          |
| localhost    |      |                  | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
| localhost    |martin| 261e294700278cc3 | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          |
+--------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
4 rows in set (0.02 sec)

a tady tabulka db
  ---------------------------------------------------------------------
+------+------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db   | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+------+------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| %    |martin|martin| Y           | Y           | Y           | Y           | Y           | Y         | N          | N               | N          | N          |
+------+------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
1 row in set (0.01 sec)
-----------------------------------------------------------------------

uzivatel je Martin A zalozena databaze martin.

Moc diky za napady,rady a pripominky ahoj Lukas.
root na heroes:/usr/share#
root na heroes:/usr/share#

--------------------------------------------- 
                             mailto:linux_lukas na atlas.cz