Hello, Im sotty if this is silly question, im new to this and im wondering is there any software to manage databases instead browser based managing? Thanks you!
Try downloading the MySql workbench - its free to download from the mysql site. Make sure you download the 5.2 beta version as it is this one that enables server administrations and sql queries.
via the browser you can look into phpMyAdmin, which is free software. If you prefer connecting via a Windows GUI interface, mysql does have several tools to connect to a database. The advantage of browser-based sessions, is you can restrict queries locally, and never have to open the mySQL port up to any outside traffic.
Navicat is the best I've ever used. Workbench is great for visual design but Navicat is much better for creating, editing, and general day-to-day management.
Along with Workbench, MySQL also has a graphic query browser and an administrator gui tools. I use both of them and they work quite well.
Pretty much everything you can do with serverside SQL managers like phpMyAdmin and it, can be done remotely and portably with any SQL data base
There are many options as mentioned earlier. I have recently seen another good tool MyWebSql. Here is a list of MySQL GUIs you can choose from.
MySQL Workbench is quite nice, and its free. It might be a bit overwhelming for someone who is not familiar with those kind of tools. You have to go a step at the time. phpmyadmin is nice also but a bit old. But hey, they are free, so cant really complain, i personally prefer the MySQL Workbench. Cheerio
I have down loaded My sql yog but not knowing how to deal with it..if any one know then please share here... thanks in advance....
Try using one of the desktop ones like Navicat. They're so much better and more efficient that there's no comparison. For any designer that needs to do anything but the most basic database usage on a single server, Navicat is an investment that will easily pay for itself in productivity. I can manage databases on 50 different servers at a time, and manage remote backups, scripting, reports, and anything else on every database.
I have already used Navicat software, but not satisfied yed. how is mysql yog ? ...one of my friend, recently pass his computer engineering, suggest me that software........