Hello, I am trying to setup phpmyadmin so that I can create databases on mysql server which is running.. I went over the document that came with phpmyadmin and it says the controluser needs to have select privileges only.. and it give an example to edit the config.inc.php3 file.. my problem is I'm not to sure where to insert this code in the file and if any other adjustments need to be made.. here's the example colde.

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';

where does this go in the config.inc.php3 file?

Thanks.

    in short, it doesn't

    you run that code at the command line, using mysqld (i think). instructions are in the mysql manual under 'installation'.

    if you're on shared hosting (and cannot get to command line), your host should have given you a mysql username and password - these are what goes in the phpmyadmin config.inc.php file

    post more info if this doesnt help - ie unix/windows etc

    adam

      thanks for the reply, it's on a localhost installation for windows.
      I can login into myphpadmin but when I try and create a database, it gives me page not found errors.. when I go to the directory, the page it's trying to find is there.

      Thanks for any help.

      Mike.

        Write a Reply...