mysql said Cannot connect invalid settings xampp

0 votes

I changed the root password to test and now I cannot log in to the phpMyAdmin page in XAMPP.

I did some research and found that the issue is changed config.inc.php file in XAMPP\PHPMYADMIN folder.

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'test';    <---- changed this
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'test'; <--- I changed this too (Edit: Not needed)

This code below works which uses the above password

if($_SERVER['REMOTE_ADDR']=="127.0.0.1")
{
define("DATABASE_SERVER", "localhost");
define("DATABASE_USERNAME", "root");
define("DATABASE_PASSWORD", "test");
define("DATABASE_NAME", "TIGERWOODS");
} 

Is there a way to solve this?

May 23, 2022 in Others by Kichu
• 19,050 points
6,019 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Cannot connect to Excel SSIS

You need to set run64BitRuntime to False. ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 63,420 points
2,951 views
0 votes
1 answer

How to connect ms excel-2007 with mysql.

Try this: Function runQuery() Dim cn As Object Dim rs ...READ MORE

answered Dec 23, 2022 in Others by narikkadan
• 63,420 points
299 views
0 votes
1 answer
0 votes
0 answers

unable to connect to internet in edureka VM

i am unable to connect to internet ...READ MORE

Jun 7, 2019 in Others by Ashok
• 120 points
409 views
0 votes
1 answer

Error cannot provide both a color and a decoration in Flutter container.

Hi@akhtar, The color and decoration arguments cannot both be supplied, since it ...READ MORE

answered Jul 29, 2020 in Others by MD
• 95,440 points
5,011 views
0 votes
1 answer

MySQL container with PHPMyAdmin or with xampp

I couldn’t get your point. Overall it ...READ MORE

answered Nov 26, 2019 in Docker by Priyank
2,205 views
0 votes
1 answer

PhpMyAdmin not working on localhost

In order to answer your question, you ...READ MORE

answered Feb 8, 2022 in Others by Rahul
• 9,670 points
4,772 views
0 votes
0 answers
0 votes
0 answers
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP