New to MySQL
-
I have some experience of Oracle MS Access and SQL Server, but none in MySQL. Could you recommend:- 1) Some good beginners books 2) A decent database development tool 3) A good admin tool Cheers in advance
-
I have some experience of Oracle MS Access and SQL Server, but none in MySQL. Could you recommend:- 1) Some good beginners books 2) A decent database development tool 3) A good admin tool Cheers in advance
Hi, In terms of books, I think the book MySQL Administrators Bible[^] (Amazon) is a must read for any one coming to MySQL. In terms of Admin tools I use MySQL Workbench[^] which you can download free. This is great for development as well as admin tasks. If you use .Net and install the .Net connector, then you can also use Visual Studio's
Server Explorer
to create and manage Databases, although this is a last resort option in my opinion. Hope this helpsWhen I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
-
Hi, In terms of books, I think the book MySQL Administrators Bible[^] (Amazon) is a must read for any one coming to MySQL. In terms of Admin tools I use MySQL Workbench[^] which you can download free. This is great for development as well as admin tasks. If you use .Net and install the .Net connector, then you can also use Visual Studio's
Server Explorer
to create and manage Databases, although this is a last resort option in my opinion. Hope this helpsWhen I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
Cheers Wayne I'll check both out
-
Cheers Wayne I'll check both out
I am not sure if you are familiar with php, if you are you can install phpmyadmin, outstanding tool for managing mysql :)
-
I am not sure if you are familiar with php, if you are you can install phpmyadmin, outstanding tool for managing mysql :)
phpmyadmin is a good tool. Like many other services you would use for this purpose, it requires upkeep to remain secure. Make sure you know how to keep this product patched, and use strong passwords. I only mention this because some trusted sites I belong to have been hacked through the phpmyadmin interface recently.
-
phpmyadmin is a good tool. Like many other services you would use for this purpose, it requires upkeep to remain secure. Make sure you know how to keep this product patched, and use strong passwords. I only mention this because some trusted sites I belong to have been hacked through the phpmyadmin interface recently.
As a matter of fact, The setting for phpmyadmin must have to be set for local only not global. which is a common mistake. But for the public site it is required so, make sure whether your entire page is SSL secure or not but phpmyadmin page must have to SSL Secure otherwise a simple monitoring on the network will reveal the password