Link to home
Start Free TrialLog in
Avatar of Eduardo Fuerte
Eduardo FuerteFlag for Brazil

asked on

Could you point the better tools to develop PHP/ MySQL on Ubuntu?

Hi Experts

Could you point the better tools to develop PHP/ MySQL on Ubuntu?
Possibly free.
I'm using PHPDesigner/ dbForge on Winodows environment and had to change.

Thanks in advance
Avatar of Jason Carson
Jason Carson
Flag of Canada image

There are a lot of editors out there for ubuntu. Click here for a partial list and how to install them.

I use Sublime Text for HTML/CSS/Javascript/PHP/MySQL development. Simple interface, lots of options.It's free to download and evaluate but a license costs $80.00. Whenever version 4 comes out you have to buy a new license. It works on Windows/Linux/Mac and you can have it installed on all 3 operating systems at once without violating the license terms.
Avatar of Eduardo Fuerte

ASKER

Hi

I just installed and start testing Sublime...
Any suggestions on using MySQL?
SOLUTION
Avatar of Jason Carson
Jason Carson
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I had been using dbforge studio for MySQL
and just one doubt... by using Sublime is it possible to use X-Debug?
ASKER CERTIFIED SOLUTION
Avatar of gr8gonzo
gr8gonzo
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
if you are looking for something to maintain your databases I'd second Chris's recommendation of phpMyAdmin.
I don't really recommend phpMyAdmin anymore to most people. If they're asking for recommendations, it's my opinion that they're more than likely to install it in a way that will leave their database exposed.

Go check your web access logs for bot hits to "/my" and "/phpymyadmin" and "/pma" - you'll likely find a group of hits that target common install paths for phpMyAdmin (because that's where people generally choose to install it). Plus, the popularity of it makes it a bigger target for vulnerability attacks (and too often, it's installed alongside a production site).

External SQL tools like dbForge and HeidiSQL and Workbench are all good options for MySQL administration and are usually smaller targets (common control panels like CPanel try to enforce IP whitelisting by default, and there are multiple layers to trying to hack a listening MySQL server).
Thank you for your significant replies

I just installed PHPStorm (demo)  also, it looks to facilitate debug with its own resources (without X-Debug use) Am I right?

Just another doubt: to use HEIDI on Ubuntu environment is it necessary a previous instalation of Wine to simulate Win env, isn't it?
Is it a complex task?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for the help.