|Re: MySQL table access [message #894026 is a reply to message #893497]
||Fri, 06 July 2012 12:33
| Richard Moulton
Registered: August 2011
Location: Devon, UK
Hi Nathan, |
Sorry for the delay in getting back, I've not been monitoring the forum for updates. There's probably a setting somewhere that allows email notifications to be sent through for post updates.
Anyway, I've outlined below method that I've just tested and works for me. My guess is that your URL is wrong, note that the database name on the back end of the URL.
Let me know how you get on.
- Create a new workspace
- Switch to the database development perspective
- Click the new connection profile button
- Select connection profile type of MySQL, enter a name and click next
- Click the new driver definition button
- Select name/type of MySQL JDBC Driver 5.0, click the JAR List tab, click edit Jar/Zip and point to the mysql-connector-java-5.0.8-bin.jar file
- Back in the new connection profile wizard, on the general tab I enter my database name, url, user name and password, click the test connection button and get the success panel, click ok and click finish
In my case I enter the following ...
- My connection profile is then displayed under the database connections folder
- I can now double click on the connection profile to see my database (mydatabase), when I double click on this and then double click on schemas I can see my schema (mydatabase), double clicking on this and then tables shows me my list of tables
- My understanding is that database and schema are one and the same in MySQL
- Within the data source explorer view if I then select mydatabase and click the open scrapbook button I can then enter and excute the following command and it does create a table ... create table test (id int)
Powered by FUDForum
. Page generated in 0.09969 seconds