Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. MySQL
  4. New to MySQL

New to MySQL

Scheduled Pinned Locked Moved MySQL
databasemysqlsql-serveroraclesysadmin
6 Posts 4 Posters 120 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Slingshot II
    wrote on last edited by
    #1

    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

    W 1 Reply Last reply
    0
    • S Slingshot II

      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

      W Offline
      W Offline
      Wayne Gaylard
      wrote on last edited by
      #2

      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 helps

      When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

      S 1 Reply Last reply
      0
      • W Wayne Gaylard

        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 helps

        When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

        S Offline
        S Offline
        Slingshot II
        wrote on last edited by
        #3

        Cheers Wayne I'll check both out

        M 1 Reply Last reply
        0
        • S Slingshot II

          Cheers Wayne I'll check both out

          M Offline
          M Offline
          Mohibur Rashid
          wrote on last edited by
          #4

          I am not sure if you are familiar with php, if you are you can install phpmyadmin, outstanding tool for managing mysql :)

          L 1 Reply Last reply
          0
          • M Mohibur Rashid

            I am not sure if you are familiar with php, if you are you can install phpmyadmin, outstanding tool for managing mysql :)

            L Offline
            L Offline
            loctrice
            wrote on last edited by
            #5

            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.

            M 1 Reply Last reply
            0
            • L loctrice

              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.

              M Offline
              M Offline
              Mohibur Rashid
              wrote on last edited by
              #6

              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

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups