Configure SQuirreL with MySQL


SQuirreL is great because is universal and platform independent. You can use it to connect to almost every database that you can imagine.
The only drawback is that it doesn't ship with the database drivers due to licensing issues.

So here is a step-by-step procedure for connecting to MySQL from SQuirreL.

First of all verify that you have network access to the mysql host and its port. Usually mysql servers run at port 3306, so test the connection from your host:
telnet xxx.xxx.xxx.xxx 3306

If you get something like:
Trying xxx.xxx.xxx.xxx...
telnet: Unable to connect to remote host: Connection refused

then you won't be able to connect.

The correct response you should get is something like:
Trying xxx.xxx.xxx.xxx...
Connected to xxx.xxx.xxx.xxx.

Then you must check that the database user you will be using has access from the host that the squirrel client will run.

You can check the privileges using phpmyadmin, or by command line:
GRANT USAGE ON *.* TO 'user'@'hostname'

Now go to SQuirrel's website, download and install it.

When you run the program you will see on your left pane a list of database drivers. Most of them are not installed, so we have to manually install the drivers we use often, eg MySQL, Oracle, Sybase etc.

Now, download the platform independent mysql jdbc driver from http://dev.mysql.com/downloads/connector/j/

Unzip/untar the downloaded file. In the uncompressed folder you should see a file named mysql-connector-java-X.X.XX-bin.jar. Place this file file into the lib subfolder under SQuirreL's install folder.

This is the mysql jdbc driver.
We are now ready to install the mysql jdbc driver.
Scroll down to the MySQL driver, double-click it and set the Extra Class Path as illustreted below:


Press OK, if everything is fine, then you will see the following screen:


Now you can create your connection(s) to any mysql database(s) by using the aliases tab:



Use the "Test" button to test your connection
Hopefully the connection should be created successfully...

Have fun with your queries!

85 comments:

  1. Thanks a lot for the tutorial, I was stuck with connecting but your tutorial helped me a lot.

    ReplyDelete
    Replies
    1. Ourlife01: Configure Squirrel With Mysql >>>>> Download Now

      >>>>> Download Full

      Ourlife01: Configure Squirrel With Mysql >>>>> Download LINK

      >>>>> Download Now

      Ourlife01: Configure Squirrel With Mysql >>>>> Download Full

      >>>>> Download LINK xn

      Delete
  2. Thank you very much for the tutorial, it worked fine :D

    ReplyDelete
  3. Thanks so much for your clear tutorial! The official site certainly lacks a lot of this documentation.

    ReplyDelete
  4. Thank you so much for this tutorial.
    It is a helpful post.

    ReplyDelete
  5. Great tutorial. I should note that when attempting this with hostgator I could never get telnet to work, but it worked fine when connecting through squirrel. I used my cpanel username and password, and I used the ip address that it showed me inside cpanel on the left column towards the bottom.

    ReplyDelete
  6. An important catch: for SQuirreL to be able to load the driver/connector you need to place its .jar file into the lib subfolder under SQuirreL's install folder.

    ReplyDelete
  7. Thanks for taking the time to write the tutorial!

    ReplyDelete
  8. Thank you!

    How did you know to add jdbc:mysql:// and then the port number at the end (:3306) of the URL?

    ReplyDelete
  9. This is ansuperior writing service point that doesn't always sink in within the context of the classroom. In the first superior writing service paragraph you either hook the reader's interest or lose it. Of course your teacher, who's getting paid to teach you how to write an good essay, 
    python Training institute in Pune
    python Training institute in Chennai
    python Training institute in Bangalore

    ReplyDelete
  10. This comment has been removed by the author.

    ReplyDelete
  11. This is quite educational arrange. It has famous breeding about what I rarity to vouch. Colossal proverb.
    This trumpet is a famous tone to nab to troths. Congratulations on a career well achieved. This arrange is synchronous s informative impolites festivity to pity. I appreciated what you ok extremely here 


    Selenium training in bangalore
    Selenium training in Chennai
    Selenium training in Bangalore
    Selenium training in Pune
    Selenium Online training

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing
    apple service center chennai
    apple service center in chennai
    apple mobile service centre in chennai
    apple service center near me

    ReplyDelete
  14. Attend The Python training in bangalore From ExcelR. Practical Python training in bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Python training in bangalore.
    python training in bangalore

    ReplyDelete

  15. I feel very grateful that I read this. It is very helpful and very informative and I Python training in pune really learned a lot from it.

    ReplyDelete
  16. dmcaignoredhosting.com is a leading offshore web hosting company. Providing Quality Web Hosting Since 2014 to 1200+ Happy Clients.

    ReplyDelete
  17. I gathered a lot of information through this article.Every example is easy to undestandable and explaining the logic easily.hadoop training in bangalore

    ReplyDelete
  18. This is really an awesome post, thanks for it. Keep adding more information to this.tableau training in bangalore

    ReplyDelete
  19. Really i appreciate the effort you made to share the knowledge. The topic here i found was really effective...

    Upgrade your career Learn Oracle Training from industry experts gets complete hands on Training, Interview preparation, and Job Assistance at My Training Bangalore.

    ReplyDelete
  20. Really i appreciate the effort you made to share the knowledge. The topic here i found was really effective...

    Learn DevOps Training from the Industry Experts we bridge the gap between the need of the industry. Softgen Infotech provide the Best DevOps Training in Bangalore with 100% Placement Assistance. Book a Free Demo Today.

    ReplyDelete
  21. Really impressed! Everything is very open and very clear clarification of issues. It contains truly facts. Your website is very valuable. Thanks for sharing.
    data analytics course
    business analytics course
    data science courses

    ReplyDelete
  22. Thanks For sharing Your information. The information shared Is Very Valuable Please Keep Updating Us Time Just went On reading The article.
    devops training in chennai | devops training in anna nagar | devops training in omr | devops training in porur | devops training in tambaram | devops training in velachery

    ReplyDelete
  23. This great article has really peaked my interest. I am going to book mark your blog and keep checking for new information about once per week.
    Selenium Training in chennai | Selenium Training in anna nagar | Selenium Training in omr | Selenium Training in porur | Selenium Training in tambaram | Selenium Training in velachery

    ReplyDelete
  24. You created some decent points there. I looked online for the issue and found most people may go as well as using your internet site good luck.
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

    ReplyDelete
  25. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.

    SAP HR Online Training

    SAP HR Classes Online

    SAP HR Training Online

    Online SAP HR Course

    SAP HR Course Online

    ReplyDelete
  26. Nice blog Post ! This post contains very informative and knowledgeable. oracle training in chennai

    ReplyDelete
  27. Keep up the great work, I read few blog posts on this site and I believe that your website is really interesting and has loads of good info.
    AWS training in Chennai

    AWS Online Training in Chennai

    AWS training in Bangalore

    AWS training in Hyderabad

    AWS training in Coimbatore

    AWS training

    ReplyDelete
  28. I have been meaning to post something like this on my blog and you have given me an idea. Cheers.
    webcare360

    ReplyDelete
  29. Many blogs like this cover subjects that just aren’t covered by magazines.
    offshoreservers.net

    ReplyDelete
  30. Good. I am really impressed with your writing talents and also with the layout on your weblog. Appreciate, Is this a paid subject matter or did you customize it yourself? Either way keep up the nice quality writing, it is rare to peer a nice weblog like this one nowadays. Thank you, check also virtual edge and 5 Areas of LinkedIn to Help Promote Your Business

    ReplyDelete
  31. It's really nice and meanful. it's really cool blog. Linking is very useful thing.you have really helped lots of people who visit blog and provide them usefull information.
    data scientist certification

    ReplyDelete
  32. This is a fabulous post I seen because of offer it. It is really what I expected to see trust in future you will continue in sharing such a mind boggling post
    data scientist training and placement

    ReplyDelete
  33. Useful article Thanks for sharing your work. Keep up the good work Angular training in Chennai

    ReplyDelete
  34. Great post! I really enjoyed reading it. Keep sharing such articles. Looking forward to learn more from you.
    Reactjs Training in Chennai |
    Best Reactjs Training Institute in Chennai |
    Reactjs course in Chennai

    ReplyDelete
  35. Hey Nice Blog!! Thanks For Sharing!!! Wonderful blog & good post. It is really very helpful to me, waiting for a more new post. Keep Blogging…

    AWS Training in Hyderabad

    ReplyDelete
  36. Very intersting post about sql.Thanks for sharing this post.

    SQL Course in Pune

    ReplyDelete
  37. Well we really like to visit this site, many useful information we can get here.
    data science training

    ReplyDelete
  38. Thank a lot. You have done excellent job. I enjoyed your blog . Nice efforts
    data science course

    ReplyDelete
  39. This comment has been removed by a blog administrator.

    ReplyDelete
  40. am sure it will help many people. Keep up the good work. It's very compelling and I enjoyed browsing the entire blog.

    PTE institute in ambala
    Best PTE Coaching in ambala
    IELTS Institute in Ambala

    ReplyDelete
  41. Sir apki website par original content diya jata ha muje apke dyra di gyi jankari bhout acchi lagi agar ap moje yh bta ske ki agla airtical kab ayega your very very knowledge full airtical thanks sir:
    short story in hindi motivational

    ReplyDelete
  42. Great Article. Thank you for providing such a unique and valuable information to your

    readers. I really appreciate your work.


    Best PTE Coaching in ambala, PTE Coaching in ambala , Spouse Visa Consultants in Ambala,
    Best IELTS Institute in Ambala

    ReplyDelete
  43. Informative and knowledgeable content, big thumps up for your article. Keep sharing more stuff like this. Thank you.
    Data Science Course Training Institute in Hyderabad with Placements

    ReplyDelete
  44. This post is so interactive and informative.keep update more information...
    Android Training in Anna Nagar
    Android Training in Chennai

    ReplyDelete
  45. Thanks for posting the best information and the blog is very good...i like your post...arbaj khan hindi skill

    ReplyDelete
  46. A great website with interesting and unique material what else would you need.
    full stack web development course

    ReplyDelete
  47. Thanks for sharing this valuable information MySQL from SQuirreL step by step process. Visit the Best Data science training course in Delhi for learning Data Science from experts through live projects.

    ReplyDelete
  48. Ourlife01: Configure Squirrel With Mysql >>>>> Download Now

    >>>>> Download Full

    Ourlife01: Configure Squirrel With Mysql >>>>> Download LINK

    >>>>> Download Now

    Ourlife01: Configure Squirrel With Mysql >>>>> Download Full

    >>>>> Download LINK

    ReplyDelete
  49. An impressive share! I have just forwarded this to a colleague who was doing a little research on this. 9xmovies tamilrockers khatrimaza tamilgun filmywap

    ReplyDelete
  50. i'm unequipped for perusing articles online especially as often as possible, but Im blissful I did these days. it is chosen dexterously composed, and your focuses are capably communicated. I request you agreeably, engage, dont at any point lower composing. Driver Downloader License Key

    ReplyDelete
  51. I understand this is one of the most significant direction for me. What's more, I'm fiery concentrating on your article. anyway need to analysis upon a few standard matters, the web webpage style is unmodified; the articles are strong. much thanks to you for the significant amount of real and reasonable express.Download MS Office 2016 With Crack

    ReplyDelete
  52. Your substance material is nothing prompt of throbbing in bunches of ways. I guess this is alluring and eye-start texture. much obliged accurately a huge amount for stressing generally your substance material and your perusers. Happy Friday Quotes For Work

    ReplyDelete
  53. This comment has been removed by the author.

    ReplyDelete
  54. This comment has been removed by the author.

    ReplyDelete
  55. Thanks for sharing this great article we appreciate it, we provide youtube short download freely and unlimited.

    ReplyDelete
  56. Kindly Visit my website for cracked software, Windows & Mac. Download Now Latest Versions.
    IObit Driver Booster Crack

    ReplyDelete
  57. Kindly Visit my website for latest movies.
    watchasiantv

    ReplyDelete
  58. I really appreciate your efforts for writing this blog. That was very well explained.Thanks for sharing.
    SQL Classes in Pune

    ReplyDelete

  59. Thank you for sharing! I always appreciate engaging with high-quality content that offers valuable insights. The presented ideas are not only excellent but also incredibly innovative, making your post a truly enjoyable read. Keep up the fantastic work.
    visit: Advanced Python Techniques: Unleash the Power of Python

    ReplyDelete