Witam.... Bardzo proszę o pomoc. Nagle zniknęły wszystkie table w bazie. Próbowałem wgrać kopię bazy, ale otrzymuję komunikat :

CREATE TABLE `fusion_admin` (
`admin_id` tinyint( 2 ) unsigned NOT NULL AUTO_INCREMENT ,
`admin_rights` char( 2 ) NOT NULL default '',
`admin_image` varchar( 50 ) NOT NULL default '',
`admin_title` varchar( 50 ) NOT NULL default '',
`admin_link` varchar( 100 ) NOT NULL default 'reserved',
`admin_page` tinyint( 1 ) unsigned NOT NULL default '1',
PRIMARY KEY ( `admin_id` )
) ENGINE = MYISAM AUTO_INCREMENT =50 DEFAULT CHARSET = latin1;


MySQL zwrócił komunikat:
#1142 - CREATE command denied to user 'macportal'@'localhost' for table 'fusion_admin'

Próbowałem inne kopie przywrócić i jest to samo. Bardzo proszę pomóżcie.....Tyle pracy poszło na marne :-(.....

Przy ponownej instalacji pojawia się komunikat :

CREATE command denied to user 'macportal'@'localhost' for table 'fusion_weblinks'Skrypt nie mógł stworzyć jednej lub więcej tabel w bazie danych.
Dlaczego tak się dzieje? Przecież instaluję tak jak zawsze...:-(

Jak byk jest napisane, ze konto uzytkownika, z ktorego sie laczysz z baza danych, nie ma uprawnien do wykonania polecenie CREATE. Poszukaj w manualu informacji o poleceniu GRANT zeby przyznac sobie uprawnienia potrzebne do modyfikacji bazy.

For 'HTTP' and 'cookie' modes, phpMyAdmin needs a controluser that has only the SELECT privilege on the `mysql`.`user` (all columns except `Password`), `mysql`.`db` (all columns), `mysql`.`host` (all columns) and `mysql`.`tables_priv` (all columns except `Grantor` and `Timestamp`) tables.
You must specify the details for the controluser in the config.inc.php file under the $cfg['Servers'][$i]['controluser'] and $cfg['Servers'][$i]['controlpass'] settings.
The following example assumes you want to use pma as the controluser and pmapass as the controlpass, but this is only an example: use something else in your file! Input these statements from the phpMyAdmin SQL Query window or mysql command–line client.
Of course you have to replace localhost with the webserver's host if it's not the same as the MySQL server's one.


GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT (
Host, User, 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,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO 'pma'@'localhost';


If you are using an old MySQL version (below 4.0.2), please replace the first GRANT SELECT query by this one:


GRANT SELECT (
Host, User, 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
) ON mysql.user TO 'pma'@'localhost';


... and if you want to use the many new relation and bookmark features:

GRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db>.* TO 'pma'@'localhost';

Wpisuję nazwę bazy hasło i nic........:-(. Same błędy.........