Setting to run mysql query within aptana studio

These are the steps that are needed to make a database connection to run queries inside the aptana IDE .

Click the Database Perspective . Right click and add Database . Enter a name to recogise easy for you .  ( Picture below shows it )

First screen shot , how to run mysql queries inside aptana studio

Clicking Next will ask you for the username and password and the connection string . The user name and password is that of your mysql db . Hope you have already installed MySQL .

Connection string for aptana studio

The connection string is jdbc://mysql://localhost:3036/

when its ok you can test it and check whether it works fine .

Connecting to server is jdbc://mysql://www.domain.com:port/

I too have searched to find the solution . Got it from Aptana forum . The forum is great, so you don't need to worry about it .

Anonymous's picture

There is no Database Perspective in Aptana 1.5.

hari's picture

I am using Aptana studion version 1.2 . I hope the 1.5 defnitely will be having this perspective . Have you tried Window->Open Perspective->Other . From there you can see  a list of perspectives . Select the Database Explorer . It will defnitely work for you .
Thanks

Anonymous's picture

ciao, am roberto and i saw ur article while i was looking for a solution to my problem
i cant find a database prospective (even in Window->Open Perspective->Other)
i use ubutnu 9.04 and i opened a new web project for a php training
any sugg?

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
Powered by Drupal, an open source content management system