I've run into something very strange. I'm unable to complete the set up of netorked access to a MySQL 8.0 database.
Here is why it is so strange:
1. I've had no trouble setting up versions 5.6 and 5.7. From either WorkBench or from our software.
2. Local access (using 'LocalHost') is no problem.
3. The access is for the "root" user. With full access rights set.
4. The 3306 port is allowed on all networked PC firewalls. And user control is turned off as well.
5. The IP addresses being used are valid and can be pinged.
6. On WorkBench, even though I specify "Store in vault" for the password, the password keeps being requested. And then we get "Access denied for user "root@development (using password YES)".
Which implies insufficient rights. Even though the root user has been granted full access from the MySQL command line - just in case.
I'm beginning to suspect there is something wrong with the MySQL setup. Anyone got any ideas?
Regards.
Alan
Here is why it is so strange:
1. I've had no trouble setting up versions 5.6 and 5.7. From either WorkBench or from our software.
2. Local access (using 'LocalHost') is no problem.
3. The access is for the "root" user. With full access rights set.
4. The 3306 port is allowed on all networked PC firewalls. And user control is turned off as well.
5. The IP addresses being used are valid and can be pinged.
6. On WorkBench, even though I specify "Store in vault" for the password, the password keeps being requested. And then we get "Access denied for user "root@development (using password YES)".
Which implies insufficient rights. Even though the root user has been granted full access from the MySQL command line - just in case.
I'm beginning to suspect there is something wrong with the MySQL setup. Anyone got any ideas?
Regards.
Alan