Bug #94927 Failure to create any new user account
Submitted: 6 Apr 18:23 Modified: 10 Apr 16:41
Reporter: ERNESTO ESTEVES Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:8.0.15 OS:Microsoft Windows (windows 10 pro)
Assigned to: CPU Architecture:x86

[6 Apr 18:23] ERNESTO ESTEVES
Description:
Whenever I try to create a new User Account I get an error alert.

wb.log (log-level=debug3) shows (last 2 attempts):

18:39:24 [WRN][wb_admin_control.py:exec_sql:658]: Error executing SQL CREATE USER 'ijdbEEuser'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'Mypassword&&&777': 
18:39:24 [WRN][wb_admin_control.py:exec_sql:660]: exec_sql: Loss of connection to mysql server was detected.
18:39:24 [ERR][       pymforms]: Unhandled exception in Python code: 
Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security.py", line 2026, in commit
    self.reload_user(is_new_user)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security.py", line 2063, in reload_user
    self._selected_user.load(self._selected_user.username, self._selected_user.host)
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security_be.py", line 933, in load
    if not result.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'
18:40:09 [ERR][wb_admin_control.py:server_polling_thread:581]: Error in monitoring thread: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_control.py", line 573, in server_polling_thread
    result = self.poll_connection.executeQuery("SHOW GLOBAL STATUS")
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\db_utils.py", line 354, in executeQuery
    raise QueryError("Error executing '%s'\n%s"%(query, error), code, error)
QueryError: Error executing 'SHOW GLOBAL STATUS'
MySQL server has gone away.
SQL Error: 2006

18:47:55 [ERR][wb_admin_control.py:server_polling_thread:581]: Error in monitoring thread: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_control.py", line 573, in server_polling_thread
    result = self.poll_connection.executeQuery("SHOW GLOBAL STATUS")
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\db_utils.py", line 354, in executeQuery
    raise QueryError("Error executing '%s'\n%s"%(query, error), code, error)
QueryError: Error executing 'SHOW GLOBAL STATUS'
MySQL server has gone away.
SQL Error: 2006

18:48:28 [ERR][wb_admin_security.py:commit:2010]: Exception while saving account: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security.py", line 1997, in commit
    self._selected_user.save()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security_be.py", line 803, in save
    assert self._orig_username is not None and self._orig_host is not None
AssertionError

How to repeat:
Easy:

Whenever I try to create a new User Account I get an error alert.

Suggested fix:
none
[6 Apr 18:49] ERNESTO ESTEVES
This problem just started to happen. A month ago it did not happen.

Note_1:-My Server Status screen shows: 
  a)- Version: MySQL Server - 5.7.25-Oubuntu0.18.04.2 ((Ubuntu))
      - But in my machine I have MySQL Server 8.0.15 (not 5.7.25 !!!)
  b)- Compiled for: Linux (x86_64)
  c)- Configuration File: unknown !!!

Note_2:- I am working in a - Homestead Improved - Virtual Machine (VirtualBox)

   Best Regards - Ernesto Esteves
[7 Apr 18:16] ERNESTO ESTEVES
2019/04/07:

Clarifying the Steps of Occurence/Repeat:

Apparently the Screenshot showing the details below didn't reach you !!! 

Selected Database:- ijdb

1. Choosing -> Server / Users and Privileges / Add Account / Login:
2. Typed in:
   - Login Name: ijdbuser
   - Authentication Type: Standard
   - Limit to Hosts Matching: localhost
   - Password: ijdbuserPass###
3. Click on: Apply
4. Alert - Error:
   - Unhandled Exception. 'NoneType' object has no attribute 'nextRow'
   - Check the log for more details (the details I have uploaded to you)
   
   Best Regards and Thanks - Ernesto Esteves
[7 Apr 18:19] ERNESTO ESTEVES
Sorry - User Password: Mypassword&&&777
[7 Apr 21:19] Miguel Solorzano
Thank you for the bug report. I couldn't repeat with WorkBench on 8.0.15 on Windows 10 Pro and MySQL server 5.7.25 running on Ubuntu 18.04.
[8 Apr 21:41] ERNESTO ESTEVES
Thank you, Mr Miguel Solorzano.

1. Did you use it with - Laravel Homestead Improved ??
2. Maybe this is the origin of my problems ?? Do you suggest another ??
   Such as using Laravel Homestead - and not the - Improved Git fork.
3. From wb.log:- A Security problem ??
16:53:12 [ERR][wb_admin_security.py:commit:2010]: Exception while saving account: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security.py", line 1997, in commit
    self._selected_user.save()
  File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_security_be.py", line 803, in save
    assert self._orig_username is not None and self._orig_host is not None
AssertionError 
4. Do you think I have a - security problem traced - in - wb_admin_security_be.py ??
5. How can I upload screenshots of the problem ???

  Sorry to bother - Best Regards and Thanks in Advance - Ernesto Esteves
[10 Apr 16:41] ERNESTO ESTEVES
Hi Mr. Solorzano.
Problem SOLVED:
1. I am using - Homestead Improved - Cloned from a Github fork of the original Laravel Homestead. 
It installs a MySQL Server 5.7 (version 5.7.25-0ubuntu0.18.04.2)
2. MySQL Workbench 8.0.15 is apparently NOT compatible with this MySQL Server.
3. Example 1: Server's - Failure to create new Users - Fatal Errors.
4. Example 2: Server's - Failure to Export Data:
Warning Popups stating mysqldump.exe version 8.0.15 different from MySQL Server version 5.7.25-0ubuntu0.18.04.2 to be dumped. Recommend to downgrade mysqldump.exe or upgrade the MySQL Server. Fatal Error if clicked in - Continue Anyway.
5. MY SOLUTION:- From archives, installed MySQL Workbench version 6.0.9 (no version 5.7.25 available). ALL PROBLEMS DISAPPEARED !!!
6. A Final NOTE:- Of course I would prefer to use MySQL Workbench 8.0.15. 
Is there a workaround (not too complicated) to make it compatible with - MySQL Server 5.7.25 ?? (or a way to upgrade the running MySQL Server 5.7.25 installed by - Homestead Improved - to version 8.0.15 ??). 
    Best Regards and Thanks - Ernesto Esteves