Pridani database v MySQL

[Dalibor Straka]

On Sat, Nov 30, 2002 at 09:23:09AM +0000, Karel Vyskočil wrote:
> Zdravim,
> chtel bych se zeptat, co je nutne nastavit po instalaci MySQL, aby mohl normalni uzivatel pridavat nove database. Na RH7.3 sem si nainstaloval MySQL z distribuce a pri pokusu o vytvoreni nove database mi to vyplivne toto:
> 
> mysql> CREATE DATABASE new_database;
> ERROR 1044: Access denied for user: '@localhost' to database 'new_database'
> 
> Sem v tom zacatecnik, takze netusim. Snazil sem se neco vykoukat z manualu, ale s moji mizernou anglictinou to nikam nevedlo.
> Diky.

Ahoj,

nejdrive nastav heslo pro roota, jinak se do tve databaze dostane kazdy
$mysqladmin -u root -p
Enter password:moje_super_heslo:)

Pak spust mysql pod rootem a zacneme:
mysql> show database;
+------------+
| Database   |
+------------+
| mysql      |
| test       |
+------------+
4 rows in set (0.00 sec)

mysql> use mysql;
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv    |
| db              |
| func            |
| host            |
| tables_priv     |
| user            |
+-----------------+
6 rows in set (0.00 sec)

user  Tabulka obsahuje vsechna jmena, hesla, hostitele a privilegia
      uzivatelu
db    Tabulka obsahuje sdilene databaze, jejich uzivatele a nazvy
      hostitelu, z kterych se mohou prihlasovat
host  Tabulka obsahuje vsechny nazvy mistnich i vzdalenych hostitelu,
      vsechny sdilene databaze a jejich privilegia

Ted pridame uzivatele "Magor" do tabulky user. Tabulka ma tyto sloupce
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 |

mysql: insert into user values("localhost","Magor",
       password("magorovo_heslo"),"Y","Y","Y","Y","Y","Y",
       "Y","Y","Y","Y","Y","Y","Y");
mysql:quit;
Ted muzete pouzivat databazi jako Magor:-) mysql -u Magor -p

No to jsem byl dneska nejakej hodnej.
  Dalibor Straka