mySQL console

[b4u]

Hi,

... and so I installed my SQL ...

now can anyone tell me of a good "console" to access their databases? Something in the form of "Query Analysed" of SQL Server2000

 

[Superwormy]

Not sure what you mean... if by console you mean acommand line interface to MySQL... try typing mysql at the command prompt

 

[Need4Speed]

'man mysql'

'man mysqladmin'

that should get you started

 

[Need4Speed]

of course im assuming this is running on linux....

 

[b4u]

I'm running a windows version, I'm looking for an easier way to work with mySQL databases.

For example, I have in SQL Server the Enterprise Manager to work in DB or the Query Analiser, which allows me to create sql statements manually, with all the simplicity of windows environment (copy-paste for example).

 

[CTho9305]

Originally posted by: b4u
I'm running a windows version, I'm looking for an easier way to work with mySQL databases.

For example, I have in SQL Server the Enterprise Manager to work in DB or the Query Analiser, which allows me to create sql statements manually, with all the simplicity of windows environment (copy-paste for example).

I've also been looking for something like that... I haven't found anything nearly as good (which is sad, considering the number of annoyances there are with Query Analyzer... you'd think the open source people would try to make something better).

 

[kt]

I use MySQL Control Center. It's no MSSQL enterprise manager, but for free it's a nice tool.

 

[b4u]

I'll give it a try ... thanks

 

[adlep]

Also, make sure to use PHPmyadmin

 

[CTho9305]

anyone have screenshots?