Posts

How to mount the partition with NTFS file system in Ubuntu with read-write access

How to mount the partition with NTFS file system in Ubuntu with read-write access If you can't access the drive, execute the following command: sudo ntfsfix /dev/sdXY where XY is the partition e.g sda2 or sdb1 Then, mount with: sudo mount -o rw /dev/sdXY /mnt/folderName

Installing Java 11 on Ubuntu 16

sudo add-apt-repository ppa:openjdk-r/ppa sudo apt-get update -q sudo apt install -y openjdk-11-jdk

How to Install Latest MySQL Server on AWS EC2 Ubuntu 18.04

Install MySQL Server To install the MySQL server, you must update your Linux packages system first, type: sudo apt update Then install the MySQL Server package: sudo apt-get install mysql-server MySQL prompt asking you to proceed install, then type: Y Set Password on Root User Please note that the MySQL root user is unsecured you need to provide a secure password for the root user once you deployed on production. To do this, run this command on your terminal: $ sudo mysql Next, we need to check which authentication method of each MySQL user, type command: mysql> SELECT user,authentication_string,plugin,host FROM mysql.user; You can see that the root user doesn’t have authentication_string using the auth_socket plugin. To configure the root account to authenticate with a password, run the following ALTER USER command: mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' ; Please note, make sure...

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