doctorbill
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: bf9ad53b11c9a57efdb1057292 d73b928b8c 5c77 $
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]['passw ord'] = '';
$cfg['Servers'][$i]['exten sion'] = 'mysqli';
$cfg['Servers'][$i]['Allow NoPassword '] = true;
$cfg['Lang'] = '';
/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host' ] = '127.0.0.1';
$cfg['Servers'][$i]['conne ct_type'] = 'tcp';
/* User for advanced features */
$cfg['Servers'][$i]['contr oluser'] = 'pma';
$cfg['Servers'][$i]['contr olpass'] = '';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb '] = 'phpmyadmin';
$cfg['Servers'][$i]['bookm arktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relat ion'] = 'pma_relation';
$cfg['Servers'][$i]['table _info'] = 'pma_table_info';
$cfg['Servers'][$i]['table _coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_p ages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['colum n_info'] = 'pma_column_info';
$cfg['Servers'][$i]['histo ry'] = 'pma_history';
$cfg['Servers'][$i]['desig ner_coords '] = 'pma_designer_coords';
$cfg['Servers'][$i]['track ing'] = 'pma_tracking';
$cfg['Servers'][$i]['userc onfig'] = 'pma_userconfig';
$cfg['Servers'][$i]['recen t'] = 'pma_recent';
$cfg['Servers'][$i]['table _uiprefs'] = 'pma_table_uiprefs';
$cfg['Servers'][$i]['users '] = 'pma_users';
$cfg['Servers'][$i]['userg roups'] = 'pma_usergroups';
$cfg['Servers'][$i]['navig ationhidin g'] = '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
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: bf9ad53b11c9a57efdb1057292
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_
$cfg['Servers'][$i]['user'
$cfg['Servers'][$i]['passw
$cfg['Servers'][$i]['exten
$cfg['Servers'][$i]['Allow
$cfg['Lang'] = '';
/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'
$cfg['Servers'][$i]['conne
/* User for advanced features */
$cfg['Servers'][$i]['contr
$cfg['Servers'][$i]['contr
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb
$cfg['Servers'][$i]['bookm
$cfg['Servers'][$i]['relat
$cfg['Servers'][$i]['table
$cfg['Servers'][$i]['table
$cfg['Servers'][$i]['pdf_p
$cfg['Servers'][$i]['colum
$cfg['Servers'][$i]['histo
$cfg['Servers'][$i]['desig
$cfg['Servers'][$i]['track
$cfg['Servers'][$i]['userc
$cfg['Servers'][$i]['recen
$cfg['Servers'][$i]['table
$cfg['Servers'][$i]['users
$cfg['Servers'][$i]['userg
$cfg['Servers'][$i]['navig
/*
* 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So the mysql database will be phpmyadmin ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So that will give privilages on all the databases in mysql ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok - will try
ASKER
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
Error
SQL query: Documentation
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
MySQL said: Documentation
#1146 - Table 'mysql.host' doesn't exist
ASKER
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]['userg roups'] ... not OK [ Documentation ]
Configurable menus: Disabled
$cfg['Servers'][$i]['navig ationhidin g'] ... not OK [ Documentation ]
Hide/show navigation items: Disabled
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
$cfg['Servers'][$i]['userg
Configurable menus: Disabled
$cfg['Servers'][$i]['navig
Hide/show navigation items: Disabled
ASKER
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,DELET E,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
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,DELET
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
ASKER
It is all working now - looks like I needed to carry out a number of apache and mysql server stop - starts
Thanks a million
Thanks a million
ASKER
solution
You're welcome.
Glad I could help!
Glad I could help!
ASKER
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';