Posts

Showing posts from August, 2019

How to Enable SSH on Ubuntu

Enabling SSH on Ubuntu The SSH server is not installed by default on Ubuntu desktop systems but it can be easily installed from the standard Ubuntu repositories. To install and enable SSH on your Ubuntu system complete the following steps: Open your terminal either by using the Ctrl+Alt+T keyboard shortcut or by clicking on the terminal icon and install the openssh-server package by typing: sudo apt update sudo apt install openssh-server Enter the password when prompted and enter Y to continue with the installation. 

To install the mysql driver manually in Dbeaver

Image
Go to https://mvnrepository.com/artifact/mysql/mysql-connector-java and choose the version we want in my case I will take version 5.1.47 this is the direct link to download http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.47/mysql-connector-java-5.1.47.jar I also leave the following image so that you can see where you can download it. Then we save the driver in the directory easy to find.

Can't connect to Remote MySQL Server (10061) to Ubuntu

STEP 1: To allow remote access to MySQL, you have to comment out bind-address (you did) and skip-networking in the configuration file. Next, you have to make sure the user is allowed remote access. Check your user with this: SELECT User , Host FROM mysql . user ; If your user here has '127.0.0.1' or 'localhost' listed as host, you don't have remote access. Change this with: UPDATE mysql . user SET HOST = '%' WHERE User = '__here_your_username' ; Flush privileges: FLUSH PRIVILEGES ; The '%' is a wildcard for 'all hosts'. STEP 2: To Allow remote access to MySQL installed on a Ubuntu, you will have to access the file at this location: / etc / mysql / mysql . conf . d / mysqld . cnf There, you comment out the following line: bind-address = 127.0.0.1 basically to change: bind-address = 127.0.0.1 to: #bind-address = 127.0.0.1 Now you either restart the computer or just the mySQL service using the follwing...