Topic: Starting to use MySQL Community edition
Hello,
I want to start learning about using MySQL Community edition. I have installed MySQL Community edition, choosing server only, and installed the workbench. I am intending to do all this on the local PC to start with, no LAN. The "Server Status" tab in workbench tells me the host name which is the name of the PC. In MVB I start a new project and set the database to MySQL and it comes up with a window labelled "Connect". I put the name of the PC in the "Server (Host)" field, the port is 3306, user name is root, and I put the password in I set when I installed the server. I click the green plus sign to see what it does and a message appears "Host 'OEM-PC.lan' is not allowed to connect to this MySQL server.'. Is there some basic step by step list of instructions that I can follow that will allow me to get started with this on my local PC with the aim to eventually provide end user software.
Thanks in advance for any help, David.