Good Morning from Houston, Texas. Hi Folks, I'm Charles Triola (rocketlynx) on the Forum, and I'm setting up my HADesigner for Orbiter Mods and General Support. I've had experience over the years on program design, web design and general menu layouts using HTML, PHP and some "C" so I want to get myself familiar with HADesigner as fast as I can. I've gone through the wiki pages, forum posts and videos, but I'm having trouble right at the start, mysql connecting.
Everything's installed, Microsoft stuff, .Net framework, .NET ODBC Provider and MySQL MyODBC Adapter. I'm bombing at connection to the Core's MySQL database.
First, I'm using my laptop running 32bit Vista. Has this been successfully done on Vista or do I need XP. My Laptop is on the Core's Internal LAN, it sees the Windows PC and I see the DCERouter. I have an assigned IP of 192.168.80.247 from the DCERouter on the Vista PC.
On the Core, I've done this:
(console prompt)mysql pluto_main -uroot
mysql>USE mysql (this seems to be redundant, I'm already there)
mysql>GRANT ALL PRIVILEGES ON pluto_main.* TO firstname.lastname@example.org IDENTIFIED BY charles
(back to console prompt)
Then at my Vista laptop, I go to START-->Administrative Tools-->Data Sources (ODBC), click on the tab "System DSN" and edit the connection:
Data Source Name: linuxmce
Upon clicking the Test Button, I get a "MYODBCConfig" popup window with the info: Request Returned With SQL_ERROR.
In looking at the Diagonostics window, I get a message: [MySQL][ODBC 3.5.1 Driver]Access denied for user 'charles'@'192.168.80.247' (using password: YES)
I know I'm close because if I change the Server name from dcerouter or the database name from pluto_main, I get different errors and right now, I must be hitting the MySQL server and am just being denied access.
Is the wiki correct for LinuxMCE 8.10-Alpha2-Latest? Is ther anyone with any suggestions?