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!

144 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 most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Best Devops online Training
    Online DevOps Certification Course - Gangboard

    ReplyDelete
  12. 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
  13. This comment has been removed by the author.

    ReplyDelete
  14. 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
  15. OffshoreDedi offers high quality DMCA Ignored Hosting. We make offshore hosting simple for you to use with reliable servers and one-click installers. Your data is safe with us as it’s is kept in a high security facility in an offshore jurisdiction assuring your privacy.

    ReplyDelete
  16. 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

  17. 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

  18. Erectile dysfunction is a condition where a man is not able to get an erection. Even if they are able to get an erection, it does not last for too long. Suffering from erectile dysfunction can affect the person both physically and mentally. Therefore a person needs to take medical help to make the condition better. Also suffering from erectile dysfunction can affect the relation of the person with their partners. The medication that has brought about a wave of change in this field is the use of Viagra for erectile dysfunction. It works by targeting the basic cause of the issue thus helping millions of men all across the world. If you are a man who has been facing an issue with getting and maintaining an erection for a long time now, then you should
    .Buy Viagra online

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

    ReplyDelete
  20. Your articles really impressed for me,because of all information so nice.informatica training in bangalore

    ReplyDelete
  21. These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post.dotnet training in bangalore

    ReplyDelete
  22. 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
  23. This is really an awesome post, thanks for it. Keep adding more information to this.tableau training in bangalore

    ReplyDelete
  24. Really it was an awesome article,very interesting to read.You have provided an nice article,Thanks for sharing.angular 7 training in bangalore

    ReplyDelete
  25. I have been reading for the past two days about your blogs and topics, still on fetching! Wondering about your words on each line was massively effective. Techno-based information has been fetched in each of your topics. Sure it will enhance and fill the queries of the public needs. Feeling so glad about your article. Thanks…!
    best software testing training in chennai
    best software testing training institute in chennai with placement
    software testing training
    courses

    software testing training and placement
    software testing training online
    software testing class
    software testing classes in chennai
    best software testing courses in chennai
    automation testing courses in chennai

    ReplyDelete
  26. 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
  27. 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
  28. 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
  29. Thanks for sharing this valuable information to our vision. You have posted a worthy blog keep sharing.
    Digital Marketing Course In Kolkata
    Web Design Course In Kolkata
    SEO Course In Kolkata

    ReplyDelete
  30. 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
  31. 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
  32. 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
  33. I like your article Your take on this topic is well-written and original. I would never have thought of this.
    Best Data Science training in Mumbai

    Data Science training in Mumbai

    ReplyDelete
  34. Great writing! You have a flair for informational writing. Your content has impressed me beyond words. I have a lot of admiration for your writing. Thank you for all your valuable input on this topic.
    SAP training in Kolkata
    SAP training Kolkata
    Best SAP training in Kolkata
    SAP course in Kolkata
    SAP training institute Kolkata

    ReplyDelete
  35. 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
  36. Nice blog Post ! This post contains very informative and knowledgeable. oracle training in chennai

    ReplyDelete
  37. 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
  38. Good Post! , it was so good to read and useful to improve my knowledge as an updated one, keep blogging.After seeing your article I want to say that also a well-written article with some very good information which is very useful for the readers....thanks for sharing it and do share more posts likethis. https://www.3ritechnologies.com/course/angular-js-training-institute-in-pune/

    ReplyDelete
  39. Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
    devops online training
    best devops online training
    top devops online training

    ReplyDelete
  40. Thanks for sharing the valuable information. it’s really helpful.Best data science courses in hyerabad

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

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

    ReplyDelete
  43. I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!
    data science training in Hyderabad

    ReplyDelete
  44. 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
  45. 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
  46. Thanks for posting the best information and the blog is very helpful.python course in Bangalore

    ReplyDelete
  47. Sharing the same interest, Infycle feels so happy to share our detailed information about all these courses with you all! Do check them out
    Best Hadoop training in chennai & get to know everything you want to about software trainings.

    ReplyDelete
  48. Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.

    data science certification in bangalore

    ReplyDelete
  49. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    AWS certification course in Chennai

    ReplyDelete
  50. 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
  51. Useful article Thanks for sharing your work. Keep up the good work Angular training in Chennai

    ReplyDelete
  52. This is a great post. I like this topic.This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.Thanks for posting this again.
    data scientist training and placement

    ReplyDelete
  53. 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
  54. 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
  55. Very intersting post about sql.Thanks for sharing this post.

    SQL Course in Pune

    ReplyDelete
  56. Infycle Technologies, the No.1 software training institute in Chennai offers the best Oracle course in Chennai for tech professionals and students at the best offers. In addition to the Oracle training, other in-demand courses such as Python, Selenium, Big Data, Java, Python, Power BI, Digital Marketing will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.Best Oracle Course in Chennai | Infycle Technologies

    ReplyDelete
  57. Thanks for posting the best information and the blog is very important.digital marketing institute in hyderabad

    ReplyDelete
  58. Finish the Big Data Certification in Chennai from Infycle Technologies, the best software training institute in Chennai which is providing professional software courses such as Data Science, Artificial Intelligence, Java, Hadoop, Selenium, Android, and iOS Development, etc with 100% hands-on practical training. Dial 7502633633 to get more info and a free demo and to grab the certification for having a peak rise in your career. Get Big Data Certification in Chennai | Infycle Technologies

    ReplyDelete
  59. Thanks for posting the best information and the blog is very important.data science institutes in hyderabad

    ReplyDelete
  60. Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. data analytics course in delhi

    ReplyDelete
  61. Thanks for bringing such innovative content which truly attracts the readers towards you. Certainly, your blog competes with your co-bloggers to come up with the newly updated info. Finally, kudos to you.

    Data Science Course in Varanasi

    ReplyDelete
  62. Great to become visiting your weblog once more, it has been a very long time for me. Pleasantly this article i've been sat tight fosuch a long time. I will require this post to add up to my task in the school, and it has identical subject along with your review. Much appreciated, great offer. data science course in nagpur

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

    ReplyDelete
  64. Grab the Digital Marketing Training in Chennai from Infycle Technologies, the best software training institute, and Placement center in Chennai which is providing professional software courses such as Data Science, Artificial Intelligence, Cyber Security, Big Data, Java, Hadoop, Selenium, Android, and iOS Development, DevOps, Oracle, etc with 100% hands-on practical training. Dial 7502633633 to get more info and a free demo and to grab the certification for having a peak rise in your career.

    ReplyDelete
  65. Amazing Article! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.If you are Searching for info click on given link
    Data science course in pune

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

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

    ReplyDelete
  68. 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
  69. 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
  70. Thanks for posting the best information and the blog is very good.data science in kolkata

    ReplyDelete
  71. Wonderful illustrated information. I thank you for that. No doubt it will be very useful for my future projects. Would like to see some other posts on the same subject!
    data science classes in hyderabad

    ReplyDelete
  72. Thanks for posting the best information and the blog is very good.business analytics course in rajkot

    ReplyDelete
  73. 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
  74. 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
  75. This post is so interactive and informative.keep update more information...
    Android Training in Anna Nagar
    Android Training in Chennai

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

    ReplyDelete
  77. Your post is very informative. I want to share this post with more people, so I bookmarked your website and shared your post on my website. Thanks for your help
    english short english stories

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

    ReplyDelete
  79. Great post. keep sharing such a worthy information.
    Mobile app development courses

    ReplyDelete
  80. 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
  81. 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
  82. 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
  83. 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
  84. 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
  85. 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
  86. This comment has been removed by the author.

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

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

    ReplyDelete
  89. WebAnimator Plus may be found in the “Graphics Applications” category, specifically the “Animation Tools” subcategory.
    https://thepcsoft.com/webanimator-plus-full-crack-latest/

    ReplyDelete