Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[aolex]

am urmatorul cod :

<?php                             $query1 = mysql_connect('localhost', $_SESSION['username'], $_SESSION['password']);                             $query2 = mysql_list_dbs($query1);                             while($row = mysql_fetch_object($query2))                             {                             echo "                         <div class='row'>                             <b style='color:red'>Database name:</b>                             $row->Database                             <br>                             <form action='modules.php?module=mysql_manager_database_view_go' method='POST'>                                 <input type='image' src='themes/default/btn/mysql_manager_database_view_query.jpg' name='$row->Database' title='Query this database!'>                             </form>                         </div>\n";                             }                             mysql_close($query1);                         ?>

adica ma conectez la server cu userul meu si imi arata bazele de date care
imi apartin . problema mea este urmatoarea :

cum fac sa imi arate userii care i-am facut eu ? sa zicem ca pentru fiecare
baza de date imi fac un user (care are permisiuni full pe acea baza de date)
cum fac sa imi afisez userii intr-un mod asemanator bazelor de date ? :)

[carco]

Pai userii sunt in mysql.user iar drepturi per baza de date / tabela sunt in mysql.db.

Te joci pe select-ul:
an style="color: #000000"><?php SELECT * FROM `db` WHERE db = 'numebazadate'; 

[aolex]

ahm ... ca tot vine vorba de useri , cum adaug/sterg un user in mysql din php ?
care e query-ul ? :)

un exemplu ar fi bun !

[strategy]

adaugi user citeste
Cod:
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
    [, user [IDENTIFIED BY [PASSWORD] 'password']] ...

---
acorzi drepturi citeste
Cod:
mysql> GRANT ALL PRIVILEGES ON db.*
    -> TO user_name@'192.58.197.0/255.255.255.0';

---
stergi user citeste
Cod:
mysql> DELETE FROM mysql.user
    -> WHERE User='user_name' and Host='host_name';
mysql> FLUSH PRIVILEGES;


sau
Cod:
DROP USER user;

[aolex]

multumesc :) ... dar multumesc FRUMOS ! :wink:

[PHPRomania Bot]