• 10

A PHP Error was encountered

Severity: Notice

Message: Undefined index: userid

Filename: views/question.php

Line Number: 191


File: /home/prodcxja/public_html/questions/application/views/question.php
Line: 191
Function: _error_handler

File: /home/prodcxja/public_html/questions/application/controllers/Questions.php
Line: 433
Function: view

File: /home/prodcxja/public_html/questions/index.php
Line: 315
Function: require_once

I have a fresh Ubuntu 14.04 LTS system and installed MariaDB on it (version 5.5.36-1) whichI can access with the root user through phpMyAdmin. When I now create a new user in phpMyAdmin and then try to login with it, the logon fails and I see the following message in the error log of MariaDB:

'user' entry 'new_user@%' has both a password and an authentication plugin specified. The password will be ignored.

Do you have an idea what the problem might be and how to solve it?

Thanks and regards, Daniel

OK, meanwhile I solved the mistery. If I create the user in the shell directly with SQL, the new user works as expected. The second solution would be to create the user with phpMyAdmin and then go to table mysql.user and clear the field "plugin" for the newly created user.

  • 3
Reply Report

Warm tip !!!

This article is reproduced from Stack Exchange / Stack Overflow, please click

Trending Tags