If these questions have been answered elsewhere, the post is too long or you basically do not feel like reading it, please feel free to tell me so. I am typing it out, in hopes it helps someone. :-)
In all seriousness though, let me say that learning MySQL, SQL Server, Perl, Apache, Bugzilla, what ODBC is and Excel programming all at the same time, while in the long run will serve me well, is daunting right now. I am learning on my own, but thank God this support list is here, otherwise it would take me forever. I am attempting to gather data into Excel (for charting or simple spreadsheets) from our MySQL Bugzilla database. The Bugzilla database is located on a newtwork server (installation and DB) and is basically farmed out, although my company (read "ME") has to manage it. In order to be able to speak to the server, I had to create and ODBC connection, using MySQL connector (don't get me started on trying to understand the difference between User DSN, System DSN, ODB files, etc.). When attempting to create this connection, I had to connect to the actual server as is is not a localhost. I finally figured out that I had to designate the name of the server and then got an error that I could not conect. Originally, I thought I could do something like the following; GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY 'password!'; However, this did not work. I now believe it is because all of the privledges were set as "N". I then created a ROOT user with the same MySQL statement, using the IP address of my system (instead of %) and manually granted all the permissions, using MySQL Workbench queries. That worked. Now, I have 3 ROOT users. The one for "localhost", the one I created with "%" and the one I created with "my IP address". I then attempted to use the Query Wizard in Excel 2010 to bring over what info I wanted to see in my spreadsheet. I now have the following questions about what I have done. 1. Does anyone know of a link to completely explain what a Pivot Table is? 2. If I switch all of the privledges for the ROOT user I created with "%", will I then be able to access the database through Excel, from any system, provided that system had the ODBC connection? a. Basically, I need someone to be able to click a link and have the data they want, spit out into Excel. I won't be running these queries every time. 3. How do I delete all of the extra ROOT users I created, without deleting the main ROOT? a. Is there a way to simply modify the existing ROOT account to work off of any other IP address? b. Regarding the above, I am assuming it would be more secure, for me to create a user other than ROOT and grant that user the permissions needed to run the Excel queries. 4. If I want to run queries and dump the data into Excel, is it easier to run through the Query Wizard,, use VB code, use Excel code or a combination of all 3? 5. When I did connect to the database and attempted to get the data I wanted into Excel, I noticed that some of the data (assigned_to, product_id, component_id, etc.) are numbers. Is that because they need to be referenced by that number in another table? If so, how do I associate that data without the Excel query complaning that they aren't? How do I get the names of the items into my spreadsheet, instead of numbers? I apologize this is long and I don't know if it will even get read, answered or even deleted. If anyone can only answer a part of it though, I would appreciate any info I could get. Thanks. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
