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!

131 comments:

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

    ReplyDelete
    Replies
    1. The effectiveness of IEEE Project Domains depends very much on the situation in which they are applied. In order to further improve IEEE Final Year Project Domains practices we need to explicitly describe and utilise our knowledge about software domains of software engineering Final Year Project Domains for CSE technologies. This paper suggests a modelling formalism for supporting systematic reuse of software engineering technologies during planning of software projects and improvement programmes in Final Year Projects for CSE.

      Software management seeks for decision support to identify technologies like JavaScript that meet best the goals and characteristics of a software project or improvement programme. JavaScript Training in Chennai Accessible experiences and repositories that effectively guide that technology selection are still lacking.

      Aim of technology domain analysis is to describe the class of context situations (e.g., kinds of JavaScript software projects) in which a software engineering technology JavaScript Training in Chennai can be applied successfully

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      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. You can check free tool Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview which I think is far superior to other GUI tools.

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

    ReplyDelete
  6. 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
  7. 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
  8. Thanks for taking the time to write the tutorial!

    ReplyDelete
  9. Thank you!

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

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

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

    ReplyDelete
  15. 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
  16. Really very happy to say that your post is very interesting. I never stop myself to say something about it. You did a great job. Keep it up.
    We have an excellent IT courses training institute in Hyderabad. We are offering a number of courses that are very trendy in the IT industry. For further information, please once go through our site. DevOps Training In Hyderabad

    ReplyDelete
  17. Offshore Hosting By #1 Trusted Offshore Host Provider. https://offshorededicated.net

    ReplyDelete
  18. 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
  19. Webcare360 Provides you safe and secure cheap Offshore Hosting Best offshore hosting and DMCA ignore Hosting with 99.9% Up time Guarantee, with Ddos protection.

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

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

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

  23. 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
  24. For Python training in Bangalore, Visit:- Python training in Bangalore

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

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

    ReplyDelete
  27. 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
  28. 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
  29. Very useful and information content has been shared out here, Thanks for sharing it.Microsoft azure training in bangalore

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

    ReplyDelete
  31. 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
  32. Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving.sap s4 hana simple finance training in bangalore

    ReplyDelete
  33. Linking is very useful thing.you have really helped lots of people who visit blog and provide them use full information.javascript training in bangalore

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

    ReplyDelete
  35. Very useful and information content has been shared out here, Thanks for sharing it.sap hr training in bangalore

    ReplyDelete
  36. 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
  37. thank you so much for this nice information Article, Digitahanks for sharing your post with us.Real Time Experts training center bangalore

    ReplyDelete
  38. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful . student review for Realtime Experts marathahalli bangalore

    ReplyDelete
  39. 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
  40. 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
  41. 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
  42. Excellent Blog. Thank you so much for sharing...Glad Tidings for Job Seekers! Are you interested to get employed in reputed organization and to grasp high paying Job, Postal Recruitment 2020 is the pool of resource where you can find the golden Job opportunities in Top Companies across India according to your willingness...

    ReplyDelete
  43. 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
  44. 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
  45. 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
  46. 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
  47. 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
  48. 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
  49. 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
  50. Nice blog Post ! This post contains very informative and knowledgeable. oracle training in chennai

    ReplyDelete
  51. 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
  52. 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
  53. 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
  54. You have provided finicky information for a new blogger so it has turned out to be really obliging. Keep up the good work!
    Data Science training in Mumbai
    Data Science course in Mumbai
    SAP training in Mumbai

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

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

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

    ReplyDelete
  58. 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
  59. 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

  60. Very awesome!!! When I searched for this I found this website at the top of all blogs in search engines.
    Data Science Training

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

    ReplyDelete
  63. Kim Ravida is a lifestyle and business coach who helps women in business take powerful money actions and make solid, productiveIamLinkfeeder IamLinkfeeder IamLinkfeeder IamLinkfeeder IamLinkfeeder IamLinkfeeder IamLinkfeeder IamLinkfeeder IamLinkfeeder IamLinkfeeder

    ReplyDelete
  64. 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
  65. 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
  66. 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
  67. 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
  68. Useful article Thanks for sharing your work. Keep up the good work Angular training in Chennai

    ReplyDelete
  69. 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
  70. 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
  71. 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
  72. Very intersting post about sql.Thanks for sharing this post.

    SQL Course in Pune

    ReplyDelete
  73. 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
  74. Thanks for posting the best information and the blog is very important.digital marketing institute in hyderabad

    ReplyDelete
  75. Learn Amazon Web Services for excellent job opportunities from Infycle Technologies, the Excellent AWS Training in Chennai. Infycle Technologies gives the most trustworthy AWS course in Chennai, with full hands-on practical training from professional trainers in the field. Along with that, the placement interviews will be arranged for the candidates, so that, they can meet the job interviews without missing them. To transform your career to the next level, call 7502633633 to Infycle Technologies and grab a free demo to know more

    ReplyDelete
  76. 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
  77. Thanks for posting the best information and the blog is very important.artificial intelligence course in hyderabad

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

    ReplyDelete
  79. 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
  80. upbocw BOCW UP is a labor registration portal created by the Labor Department, Government of Uttar Pradesh. The registration of the unorganized workers (working class) of the state takes place on this portal.
    Shram Vibhag registration is provided by the Uttar Pradesh government

    Full Form

    ReplyDelete
  81. 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
  82. 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
  83. Well we really like to visit this site, many useful information we can get here.
    data science training

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