Ad block is installed and active. Please support us by disabling it.
HomeTuesday, February 20, 2018, 01:32:13
31

How to set up password for phpMyAdmin in Wamp Server

Sunday, January 31, 16, 04:00:11, 2 Yaers Ago Via wain, Hits: 3833
Password for phpMyAdmin in Wamp
1. Make sure this code is in your C:wamp/apps/phpmyadmin/config.inc.php

Code:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';


2. Left-click on the green WAMP icon.

3. Select MySQL -> MySQL Concole

http://phpform.net/images/wamp1.png

4. When you get a prompt 'Enter password:', press Enter.

http://phpform.net/images/wamp2.png

5. When you get a prompt mysql>, type:
Code:
set password for root@localhost=PASSWORD('testpass');


http://phpform.net/images/wamp3.png

6. Hit Enter:

http://phpform.net/images/wamp4.png

7. In config.inc.php replace this code

Code:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';


with this code:

Code:
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'testpass';


8. Restart WAMP

Sign In

Sponsor

Related

View content in a zip file with PHP

List all files in a zip archive with PHP

MySQL to RSS

Publishing MySQL data in RSS

PHP Cookies - setcookie

Defines a cookie to be sent along with the rest of the HTTP headers.

Bookmark Script

Allow your users to easily bookmark your site, by clicking on a link on the page.

Link Base 2.0.

Manage your links using a MySQL database. It features easy install, user submission, and an admin panel to add, edit and remove categories and links.

Random MySQL Query

Random MySQL query, requirement(s): PHP Server, MySQL

Sitemap

phpForm.net Website Sitemap

PHP Date Examples

Returns a string formatted according to the given format string using the given integer timestamp or the current time if no timestamp is given.

Convert pdf to image - mpdf

Convert pdf file to jpg with php and mpdf

Password Protect With PHP

Password protect tith PHP - tutorial
About Author

wain

Date Registered: Sun, Feb 8, 15
Last Time Online: Mon, Jan 29, 18
So far has created 115 entries.
wain
This author has not yet filled in any details.