MySql Making Remote & Local user, but erroring out on local attempt

1 post / 0 new
#1 Wed, 10/25/2017 - 05:15
webbytemedia

MySql Making Remote & Local user, but erroring out on local attempt

I have remote MySQL configured and it works fine, it worked when doing Cpanel imports to automatically create users & import databases. So I went to install PhpMyAdmin and got an error mysql isn't enabled, no problem. I enable MySQL for the server and it errors out when adding it to the VM:

.. MySQL database failed! : mysql::execute_sql_logged failed : SQL set password for 'webbyte'@'10.142.0.2' = password('fdsawfds') failed : Can't find any matching row in the user table at /usr/libexec/webmin/web-lib-funcs.pl line 1433.

I adjusted the MySQL settings under usermin configuration - > usermin module configuration also and still having the issue, yet it is making the user on the remote DB...I guess it's trying to create users on local and remote or isn't recognizing that the DB is only remote...im a bit lost on this one.