Breaking News: Grepper is joining You.com. Read the official announcement!

change password xampp

Snippets answered on December 3, 2023 Popularity 4/10 Helpfulness 6/10

answer change password xampp

change password xampp

Comment

#1- mysql>> User accounts
#2- choose root user for localhost 
#3- Edit privileges beside the root user, then select Change password 
#4- enter the password >> Go
#5- Explorer C:\xampp\phpMyAdmin\config.inc 

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'YourPassword';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

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

#3- change mysql password
> mysql -u root -p
> enter password: 
> GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'localhost'  IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
> FLUSH PRIVILEGES;

Popularity 4/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: change-password sql xampp

Link to this answer
Share Copy Link

Contributed on Dec 03 2023

Snippets

0 Answers Avg Quality 2/10

change password xampp

Contents

More Related Answers

change password xampp

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.