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

[diaconuliviu]

Cind intru in phpMyAdmin, in partea de jos a ecranului(dreapta) primesc urmatorul mesaj de eroare

Eroare
Optiunile aditionale pentru folosirea tabelelor intercalate (legate intre ele) au fost dezactivate. Pentru a afla de ce ... here.

Dupa ce apas HERE, ma trimite intr-un ecran in care am asta:

Baza de date librarie ruland pe localhost
PMA Database ... Nu este bine[ Documentatie ]
Facilitati generale Dezactivat

Apasind pe Documentatie, ma trimite aici:

cfg['Servers'][$i]['pmadb'] string
Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables. To use those as well as the bookmark feature you need special tables with a predefined structure, which we explain below.
If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb'].

If you are setting up a multi-user phpMyAdmin installation, you will need to create a new db and setup special privileges, so, as superuser:


create a new database for phpmyadmin:
CREATE DATABASE phpmyadmin;
Note that "controluser" must have SELECT, INSERT, UPDATE and DELETE privileges on this database. Here is a query to set up those privileges (using "phpmyadmin" as the database name, and "pma" as the controluser):
GRANT SELECT,INSERT,UPDATE,DELETE ON phpmyadmin.* to 'pma'@'localhost';
do not give any other user rights on this database.
enter the databasename in $cfg['Servers'][$i]['pmadb']


Cum nici cu engleza nu stau prea bine.. ce trebuie sa fac? Acea eroare provine chiar de aici? \
Va multumesc...

[diaconuliviu]

Inca ceva, ca sa nu deskid alt topic..

daca schimb parola de root... si mut baza de date pe alt calculator unde root-ul are alta parola.. se poate intra in baza mea?

Cum se pot da drepturi userilor strict pe baza de date? Cine a folosit drepturile si userii in Access, sa zicem, stie de ce vorbesc..

[sitram]

cred ca asta te va ajuta sa faci tot ce vrei tu si ce ai spus mai sus ...
ftp://82.208.137.69/mysql-administrator-1.0.6-beta-win.zip

[PHPRomania Bot]