Sfrgttk

Is it appropriate to give a culturally-traditional gift to a female coworker?

Why does Python copy numpy arrays where the length of the dimensions are the same?

Why did Shae (falsely) implicate Sansa?

Which was the first story to feature helmets which reads your mind to control a machine?

What happens to someone who dies before their clone has matured?

If you're falling because of ball bearings, do you automatically land on caltrops in the same space?

How bad is a Computer Science course that doesn't teach Design Patterns?

I hate taking lectures, can I still survive in academia?

finding the probability of an event, not equiprobable cases.

Why does RAM (any type) access time decrease so slowly?

Identical projects by students at two different colleges: still plagiarism?

How to have a different style for edges of a triangle

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Why do climate experts from the UN/IPCC never mention Grand Solar Minimum?

GPL - Is it required to post source code to the Public - when is a software released?

Is a particular string regular (e.g is '010') regular?

Tikz - highlight text in an image

Would life expectancy increase if we replaced healthy organs with artificial ones?

if else in jq is not giving expected output

Manager has noticed coworker's excessive breaks. Should I warn him?

Does the phrase がんばする makes sense?

If I can't win, but can stop my opponent from winning, is the game drawn?

How to know if I am a 'Real Developer'

Simple Question About Conservation of Angular Momentum

“Can't find any matching row in the user table” when attempting “SET PASSWORD”

Error Code: 1133. Can't find any matching row in the user tableGrant table privileges to a user connecting from any hosthow to import mysql system “mysql” databaseDatabase structure for multiple users sharing one dataset, but also many users with their own datasetError Code: 1133. Can't find any matching row in the user tableElegant Database DesignMySQL replication master-slave with 2 or more users in masterCan't grant privileges to “root” when it has no password in MariaDBHow do you grant SQL Server 2016 user-permissions to access local files?Stock quantity TriggerAccess denied error in trying to connect to a MySQL db in Python

0

When I do SELECT User, Host FROM mysql.user I see that I have a user named myuser on %. I tried setting that users password thusly:

SET PASSWORD FOR 'myuser'@'%' = 'mypassword';

Doing so, however, resulted in this error:

Error Code: 1133. Can't find any matching row in the user table

Superficially this sounds like Error Code: 1133. Can't find any matching row in the user table but it's not the same because the username and password do appear to exist...

Any ideas?

mysql mysql-5.7 users

share|improve this question

asked 5 hours ago

neubertneubert

565

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you using 'native' passwords, or some other plugin?
  
  – Rick James
  1 hour ago
  

  
  
  
  

add a comment | 

0

When I do SELECT User, Host FROM mysql.user I see that I have a user named myuser on %. I tried setting that users password thusly:

SET PASSWORD FOR 'myuser'@'%' = 'mypassword';

Doing so, however, resulted in this error:

Error Code: 1133. Can't find any matching row in the user table

Superficially this sounds like Error Code: 1133. Can't find any matching row in the user table but it's not the same because the username and password do appear to exist...

Any ideas?

mysql mysql-5.7 users

share|improve this question

asked 5 hours ago

neubertneubert

565

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you using 'native' passwords, or some other plugin?
  
  – Rick James
  1 hour ago
  

  
  
  
  

add a comment | 

When I do SELECT User, Host FROM mysql.user I see that I have a user named myuser on %. I tried setting that users password thusly:

SET PASSWORD FOR 'myuser'@'%' = 'mypassword';

Doing so, however, resulted in this error:

Error Code: 1133. Can't find any matching row in the user table

Superficially this sounds like Error Code: 1133. Can't find any matching row in the user table but it's not the same because the username and password do appear to exist...

Any ideas?

mysql mysql-5.7 users

share|improve this question

asked 5 hours ago

neubertneubert

565

SET PASSWORD FOR 'myuser'@'%' = 'mypassword';

Error Code: 1133. Can't find any matching row in the user table

share|improve this question

asked 5 hours ago

neubertneubert

565

share|improve this question

asked 5 hours ago

neubertneubert

565

asked 5 hours ago

neubertneubert

565

asked 5 hours ago

neubertneubert

565