phpMyAdmin gets the users’ privileges directly from MySQL’s

Problems with the Windows version of XAMPP, questions, comments, and anything related.

phpMyAdmin gets the users’ privileges directly from MySQL’s

Postby lazyman123 » 11. April 2021 10:44

Hello,
I installed XAMPP v7.4.16 , and after I set a password for root username, I get this error at the end of the page.
Note: phpMyAdmin gets the users’ privileges directly from MySQL’s privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.

You can see it in the screenshot from the link below:
Code: Select all
https://ibb.co/x6bWZmD


How to fix this issue?
lazyman123
 
Posts: 12
Joined: 04. April 2021 18:29
XAMPP version: 8.0.3
Operating System: windows 10

Re: phpMyAdmin gets the users’ privileges directly from MySQ

Postby Nobbie » 11. April 2021 10:50

Its not an error, its not a warning, only a note, a little hint. Read it carefully and thats it, as you did not change privileges. Dont you understand that little note?
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: phpMyAdmin gets the users’ privileges directly from MySQ

Postby lazyman123 » 11. April 2021 11:11

Nobbie wrote:Its not an error, its not a warning, only a note, a little hint. Read it carefully and thats it, as you did not change privileges. Dont you understand that little note?


sorry my mistake. I didn't read it.

Another issue appear, If you can help me , it would be great.
After login into phpmyadmin page, with username "root" and password. I get two red error:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

The secret passphrase in configuration (blowfish_secret) is too short.

This is a screenshot for them
Code: Select all
https://i.ibb.co/28TWF5r/2.png
lazyman123
 
Posts: 12
Joined: 04. April 2021 18:29
XAMPP version: 8.0.3
Operating System: windows 10

Re: phpMyAdmin gets the users’ privileges directly from MySQ

Postby lazyman123 » 11. April 2021 12:13

Just an update:
I change the Authentication method from config to cookie, as shown below, and I search the internet and find a solution for the blowfish_secret error. I change it from "xampp" to a long string.
it is fixed, and the error disapear.

Still have the second error.



Just another question. In the config.inc.php page
shall I put my password in the password line or leave it empty?

Code: Select all
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';
lazyman123
 
Posts: 12
Joined: 04. April 2021 18:29
XAMPP version: 8.0.3
Operating System: windows 10

Re: phpMyAdmin gets the users’ privileges directly from MySQ

Postby Nobbie » 11. April 2021 12:23

lazyman123 wrote:I get two red error:


No, once again, these arent errors - can you read the word "error" somewhere?

I just read your update - wasnt that pretty easy? Google is your friend...

You MUST put the password into config.inc.php if you use "config" as auth_type (a few lines above). Try to find out why and try to find out which values are also valid for auth_type and what they are doing. (Google!).
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: phpMyAdmin gets the users’ privileges directly from MySQ

Postby lazyman123 » 11. April 2021 12:54

Nobbie wrote:
lazyman123 wrote:I get two red error:


No, once again, these arent errors - can you read the word "error" somewhere?

I just read your update - wasnt that pretty easy? Google is your friend...

You MUST put the password into config.inc.php if you use "config" as auth_type (a few lines above). Try to find out why and try to find out which values are also valid for auth_type and what they are doing. (Google!).


Yes you are right. I didn't read a lot about it.
Thanks for your help.
lazyman123
 
Posts: 12
Joined: 04. April 2021 18:29
XAMPP version: 8.0.3
Operating System: windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 111 guests