CODEWITHSUNDEEP
phpphpmyadminxampp
Paolo Lambojon
Paolo Lambojon

Reputation: 155

cannot log-out from phpmyadmin in XAMPP

I have completely set up my xampp with username and password. Once I have logged in, I cannot seem to find a way to log-out. No button for log-out can be seen near the home button at the left sidebar. Please help. This is getting in my way to create a web application. Thanks.

Upvotes: 13

Views: 30172

Answers (2)

Utkarsh Salaria
Utkarsh Salaria

Reputation: 21

By default, phpMyAdmin stores the username and password for MySQL's root user in its configuration file, which is a plain text file. Since this isn't secure, it's generally considered a good practice to modify these default settings.............see below

The default location of the config file for phpMyAdmin

C:\xampp\phpMyAdmin conno. Inc.php

How to configure authentication for phpMyAdmin

1.Open the config. ine php file in a text editor such as Notepade.

  1. Set the 'blowfish secret option to a random 32 character siring. The specifies the encryption key for the cookie.

  2. Set the auth_type' option to a value of cookie.

  3. Set the 'user' and password' options to empty strings as shown below.

  4. Save your changes.

The default settings

$cfg('blownah secret') = 'xampp' /* YOU SHOULD CHANGE THIS FOR A MORE SE-
CURE COOKIE AUTH! */
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

The settings after phpMyAdmin has been configured for authentication

$cfg('blowfish_secret') = 'Ak20vo93me201290184pb56nedIwa70';
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

How to use phpMyAdmin to test the MySQL server and set a password

  1. Use the XAMPP Control Panel to start the Apache and MySQL servers
  2. Use the XAMPP Control Panel to start phpMyAdmin To do that, click on the Admin button for MySQL. This should start phpMyAdmin and prompt you for a username and password. If it doesn't, click the "Log out" link to display a "Login" page,
  3. Log in as the root user by specifying a username of 'root' By default, the root user doesn't have a password, so you don't need to enter one. When you successfully log in as the root user, phpMyAdmin should display its Home page. At this point, both the MySQL server and phpMyAdmin are working correctly.
  4. Click the Change Password link in the General Settings section, enter and re-enter a password, and click the Go button.
  5. Log out by clicking the Log Out icon near the upper left corner of the page, and then log back in using the new password.

Upvotes: 1

iksandi
iksandi

Reputation: 476

just change this line on config.inc.php

$cfg['Servers'][$i]['auth_type'] = 'config';

to

$cfg['Servers'][$i]['auth_type'] = 'cookie';

then you will be prompted to login when you refreshed the page. Afterwards, the log out icon will appear next to home icon.

Upvotes: 39

Related Questions