Unable to access to PHPMYADMIN

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

Unable to access to PHPMYADMIN

Postby sniperkill » 21. January 2019 12:32

Hello Everyone

I Installed XAMPP today and changed my root password as mentioned in official How-To guide

Code: Select all
/opt/lampp/bin/mysqladmin --user=root password "mypassword"



after changing password when I open localhost/Phpmyadmin , it shows me an error

Error
Code: Select all
mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)


I have also tried to enter new password in config.inc.php file

Code: Select all
$cfg['Servers'][$i]['password'] = 'mypassword';


but phpmyadmin is not picking up the new password, however when I change the password to "" from command line, I can access PhpMyAdmin page again

Any idea how can I make the phpmyadmin pick my new password ?

Any help would be appreciated


Thanks
sniperkill
 
Posts: 8
Joined: 21. January 2019 12:23
XAMPP version: XAMPP-VM / PHP 7.3.0
Operating System: Mac OS High Sierra v 10.13.6

Re: Unable to access to PHPMYADMIN

Postby Altrea » 21. January 2019 13:22

Hi,

Ever took a look in phpmyadmins configuration file config.inc.php?
search for the word password in there.

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Unable to access to PHPMYADMIN

Postby sniperkill » 21. January 2019 13:30

Altrea wrote:Hi,

Ever took a look in phpmyadmins configuration file config.inc.php?
search for the word password in there.

best wishes,
Altrea


Yes I have changed password in PhpMyAdmin config.inc.php file but still getting error. I have added my current config.inc.php file below and also screenshot of error.

Thanks for your help!

Image

Code: Select all
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * phpMyAdmin sample configuration, you can use it as base for
 * manual configuration. For easier setup you can use setup/
 *
 * All directives are explained in documentation in the doc/ folder
 * or at <https://docs.phpmyadmin.net/>.
 *
 * @package PhpMyAdmin
 */

/**
 * This is needed for cookie based authentication to encrypt password in
 * cookie. Needs to be 32 chars long.
 */
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

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

/**
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mynewpassword';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/**
 * phpMyAdmin configuration storage settings.
 */

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Storage database and tables */
$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]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $cfg['Servers'][$i]['users'] = 'pma__users';
// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
// $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
// $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
// $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
// $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

/**
 * End of servers configuration
 */

/**
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

/**
 * Whether to display icons or text or both icons and text in table row
 * action segment. Value can be either of 'icons', 'text' or 'both'.
 * default = 'both'
 */
//$cfg['RowActionType'] = 'icons';

/**
 * Defines whether a user should be displayed a "show all (records)"
 * button in browse mode or not.
 * default = false
 */
//$cfg['ShowAll'] = true;

/**
 * Number of rows displayed when browsing a result set. If the result
 * set contains more rows, "Previous" and "Next".
 * Possible values: 25, 50, 100, 250, 500
 * default = 25
 */
//$cfg['MaxRows'] = 50;

/**
 * Disallow editing of binary fields
 * valid values are:
 *   false    allow editing
 *   'blob'   allow editing except for BLOB fields
 *   'noblob' disallow editing except for BLOB fields
 *   'all'    disallow editing
 * default = 'blob'
 */
//$cfg['ProtectBinary'] = false;

/**
 * Default language to use, if not browser-defined or user-defined
 * (you find all languages in the locale folder)
 * uncomment the desired line:
 * default = 'en'
 */
//$cfg['DefaultLang'] = 'en';
//$cfg['DefaultLang'] = 'de';

/**
 * How many columns should be used for table display of a database?
 * (a value larger than 1 results in some information being hidden)
 * default = 1
 */
//$cfg['PropertiesNumColumns'] = 2;

/**
 * Set to true if you want DB-based query history.If false, this utilizes
 * JS-routines to display query history (lost by window close)
 *
 * This requires configuration storage enabled, see above.
 * default = false
 */
//$cfg['QueryHistoryDB'] = true;

/**
 * When using DB-based query history, how many entries should be kept?
 * default = 25
 */
//$cfg['QueryHistoryMax'] = 100;

/**
 * Whether or not to query the user before sending the error report to
 * the phpMyAdmin team when a JavaScript error occurs
 *
 * Available options
 * ('ask' | 'always' | 'never')
 * default = 'ask'
 */
//$cfg['SendErrorReports'] = 'always';

/**
 * You can find more configuration options in the documentation
 * in the doc/ folder or at <https://docs.phpmyadmin.net/>.
 */
sniperkill
 
Posts: 8
Joined: 21. January 2019 12:23
XAMPP version: XAMPP-VM / PHP 7.3.0
Operating System: Mac OS High Sierra v 10.13.6

Re: Unable to access to PHPMYADMIN

Postby Altrea » 21. January 2019 13:47

Obviously your changes does not take effect.
Otherwise i cannot explain why phpmyadmin is still of the opinion you did not specify a password (using password: NO)
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Unable to access to PHPMYADMIN

Postby sniperkill » 21. January 2019 13:52

Altrea wrote:Obviously your changes does not take effect.
Otherwise i cannot explain why phpmyadmin is still of the opinion you did not specify a password (using password: NO)


When I set my password to empty using command line then phpmyadmin opens up. Is there any other file besides phpmyadmin/config.inc.php where we have to enter the new password ?

Thanks
sniperkill
 
Posts: 8
Joined: 21. January 2019 12:23
XAMPP version: XAMPP-VM / PHP 7.3.0
Operating System: Mac OS High Sierra v 10.13.6

Re: Unable to access to PHPMYADMIN

Postby sniperkill » 21. January 2019 14:06

The main concern is I want to install Wordpress module, during installation process it asks for DB password and when I enter my password over there it does not pick that

#1

Image


#2

Image

and we cannot leave it empty :cry:

Image
sniperkill
 
Posts: 8
Joined: 21. January 2019 12:23
XAMPP version: XAMPP-VM / PHP 7.3.0
Operating System: Mac OS High Sierra v 10.13.6

Re: Unable to access to PHPMYADMIN

Postby sniperkill » 21. January 2019 16:48

Now when I open http://192.168.64.2/phpmyadmin/ , it shows blank screen ,,, any idea why is that ?
sniperkill
 
Posts: 8
Joined: 21. January 2019 12:23
XAMPP version: XAMPP-VM / PHP 7.3.0
Operating System: Mac OS High Sierra v 10.13.6

Re: Unable to access to PHPMYADMIN

Postby sniperkill » 21. January 2019 18:08

I have figured this out , Kindly please close this topic


Cheers
sniperkill
 
Posts: 8
Joined: 21. January 2019 12:23
XAMPP version: XAMPP-VM / PHP 7.3.0
Operating System: Mac OS High Sierra v 10.13.6

Re: Unable to access to PHPMYADMIN

Postby Altrea » 21. January 2019 18:32

Don't you think you should tell us what the problem was and how you solved it?
Could be interesting for other users having the same problem.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Unable to access to PHPMYADMIN

Postby sniperkill » 21. January 2019 18:42

Altrea wrote:Don't you think you should tell us what the problem was and how you solved it?
Could be interesting for other users having the same problem.


The problem was not that big, In the beginning I was trying to edit phpmyadmin/config.inc.php file with texteditor and that was main cause because textedior would let me edit the file but it was not saving the file.

Solution - Edit config.inc.php through termnial

-Login to terminal from XAMPP interface
-type sudo apt-get update to update all the things
-type sudo apt-install vim to install vim editor
-browse to phpmyadmin folder and type vim config.inc.php
-press i key on keyboard to go to file editor mode
-Enter your db password in file
-press escape key on keyboard to exit from editor mode
-type :wq! and hit ener to save file


Hope it will help someone :D Cheers :D


Good luck
sniperkill
 
Posts: 8
Joined: 21. January 2019 12:23
XAMPP version: XAMPP-VM / PHP 7.3.0
Operating System: Mac OS High Sierra v 10.13.6

Re: Unable to access to PHPMYADMIN

Postby Altrea » 21. January 2019 19:34

That are great news.
Thank you very much for the explaination.
Best wishes.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Unable to access to PHPMYADMIN

Postby Nobbie » 22. January 2019 12:03

As your texteditor does not save changes - how could you show us the modified config.inc.php WITH password (see above), when you could not change it?? I think, you simply edited the wrong file from another installation.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Unable to access to PHPMYADMIN

Postby sniperkill » 22. January 2019 12:05

Nobbie wrote:As your texteditor does not save changes - how could you show us the modified config.inc.php WITH password (see above), when you could not change it??


I copied the whole file content after typing my password in there, It took me while to realize that it is not saving.
sniperkill
 
Posts: 8
Joined: 21. January 2019 12:23
XAMPP version: XAMPP-VM / PHP 7.3.0
Operating System: Mac OS High Sierra v 10.13.6

Re: Unable to access to PHPMYADMIN

Postby shgss01 » 20. February 2019 09:44

Hi,

Please try to change the flag "AllowNoPassword" to false like below.

$cfg['Servers'][$i]['AllowNoPassword'] = false;

Hope still it works.
shgss01
 
Posts: 2
Joined: 20. February 2019 09:22
XAMPP version: 7.3.1
Operating System: Mac OSX 10.14.3


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 21 guests