Link to home
Start Free TrialLog in
Avatar of doctorbill
doctorbillFlag for United Kingdom of Great Britain and Northern Ireland

asked on

xampp and phpmyadmin

Server: 127.0.0.1 via TCP/IP
Server type: MySQL
Server version: 5.6.16 - MySQL Community Server (GPL)
Protocol version: 10
My XAMPP details:
-----------------------

Server: 127.0.0.1 via TCP/IP
Server type: MySQL
Server version: 5.6.16 - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)


Apache/2.4.7 (Win32) OpenSSL/1.0.1e PHP/5.5.9
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
PHP extension: mysqli Documentation


-----------------------

Config.inc.php file:

<?php
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type']     = 'cookie';      // Authentication method (config, http or cookie based)
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][$i]['recent'] = 'pma_recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma_users';
$cfg['Servers'][$i]['usergroups'] = 'pma_usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma_navigationhiding';


/*
 * End of servers configuration
 */

?>
----------------------

I keep getting the following error message:
Error message:
 The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

How do I enable advanced features with no error messages
I log in with root (password) which supposedly has global privilages
I have tried following the documentationj but no result
SOLUTION
Avatar of Dan Craciun
Dan Craciun
Flag of Romania image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of doctorbill

ASKER

How exactly do I use the below script in phpmyadmin please:

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';
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So the mysql database will be phpmyadmin ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So that will give privilages on all the databases in mysql ?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok - will try
I get the following:

Error
SQL query: Documentation

GRANT SELECT ON mysql.host TO 'pma'@'localhost';
MySQL said: Documentation

#1146 - Table 'mysql.host' doesn't exist
Sorry - disregard the last comment
The user pma and pmapass have been correectly assigned but I still get exactly the same error message:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
If i click here this is the error:

$cfg['Servers'][$i]['users'] ...      not OK [ Documentation ]
$cfg['Servers'][$i]['usergroups'] ...      not OK [ Documentation ]
Configurable menus: Disabled
 
$cfg['Servers'][$i]['navigationhiding'] ...      not OK [ Documentation ]
Hide/show navigation items: Disabled
 
MySQL privileges are:

User      Host      Type      Privileges      Grant      Action
root      127.0.0.1      global      ALL PRIVILEGES      Yes      Edit Privileges Edit Privileges
root      ::1      global      ALL PRIVILEGES      Yes      Edit Privileges Edit Privileges
root      localhost      global      ALL PRIVILEGES      Yes      Edit Privileges Edit Privileges

Phpmyadmin privileges are:
pma      localhost      database-specific      SELECT,INSERT,UPDATE,DELETE,EXECUTE      No      Edit Privileges Edit Privileges
root      127.0.0.1      global      ALL PRIVILEGES      Yes      Edit Privileges Edit Privileges
root      ::1      global      ALL PRIVILEGES      Yes      Edit Privileges Edit Privileges
root      localhost      global      ALL PRIVILEGES      Yes      Edit Privileges Edit Privileges
It is all working now - looks like I needed to carry out a number of apache and mysql server stop - starts
Thanks a million
solution
You're welcome.
Glad I could help!