Seems like all the steps of this project will have been a bit more difficult that what I had anticipated. Some times I get a bit irate. But that is all part of learning!!!
I already have explored most of the topics here MySQL and I have not found exactly what I need.
Around Christmas I installed MySQL, downloaded from their website. When I was ready to configure the database connection I was unable to find out how or even what to do. I though Ignition was taking care of everything. Next I learned that I needed Workbench(taken from a post here). I downloaded it last week and installed it. To me a few hours to understand it. At least I believe I do.
I was able to create Schema Privileges. I have no idea if it was the right thing to do.
On workbench’s left side pane I can see the Catalog tree with mydb and the one I created, I can also see the two data tables I created, one with the employees reference name and the other with the complete list of product we assemble for our largest customer.
This being done I go to Ignition Gateway and try to set up the communication between Ignition and the Data tables. I’ve watched a few times the webinar on that topic and I took some notes down.
From a blank slate I create a new connection to MySQL. The path is: jdbc:mysql://localhost:3306/PrIgnition (I put stars because I use the company’s name). PrIgnition is the name of the Shema. If I need to connect directly to the Data Table (one example would be the one called test used by Travis) should the path be: jdbc:mysql://localhost:3306/employee?
The other major problem I encounter with MySQL is that I cannot seem to get a user and password to connect. I do not recall setting up a password as I installed the software. Had I, I would have used one that I created for this project. Is there a default password in MySQL? The information is not easy to find on the software. Here we know for sure that the default one is Password.
Further more I made some attempts to use the previous installation of MySQL. In the start menu/all programs/MySQL. There is a folder in which there is: MySQL Administrator, MySQL Migration Toolkit, MySQL Query Browser, MySQL System tray monitor, A folder as Server 5.1 that contains also: MySQL Command line and MySQL Server Instance Config Wizard.
What hints me is that I may not have the proper software is that the window of the MySQL is not alike the one Travis uses. At one point he goes to his TEST data table and erases it’s content. The tree is on the right side of the window. I don’t recall having hallucinations lately.
I tried the Wizard and the Administrator to log in.
What should I do? I feel like I am lost in the wild.