Hello everybody,

It’s been a while and today I was stuck on an older machine trying to upgrade a broken mysql update.

I had this error during the sudo apt upgrade command:

mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server

After trying different solutions posted on StackOverflow, I was able to fix it with this combination of commands:
Read more

If you encounter this error try running this command in your terminal:

npm config set strict-ssl false

Good luck!

Hello,

Every time I share a folder to a VirtualBox machine I forgot to add the virtual machine ubuntu user to the VirtualBox group.

From the terminal run:

sudo adduser yourusername vboxsf

where yourusername is the Ubuntu user name you are logged in with.

Then reboot the machine.

Have a good emulation!

Hello,

I would like to share a script I found quite useful, it’s very basic bash scripting but it still can help the unexperienced ones.

1. First create a import.sh script
2. Add the following content to the script:

   #!/bin/bash
   db=$1
   user=$2
   passwd=$3
   if [ "$db" = "" ]; then
     echo "Usage: $0 db_name user password"
     exit 1
   fi
   clear
   for sql_file in *.sql; do
     echo "Importing $sql_file";
     mysql --user=$user --password=$passwd $db < $sql_file;
   done

3. Run the script with the following terminal command:

   bash import.sh yourTargetDatabaseName yourMySQLUser yourMySQLPassword

The script will simply run sequentially all the imports you dumped beforehand.

PS: If you get some Foreign Key errors, you can disable them changing the “for” cycle mysql command with the following:
echo "SET FOREIGN_KEY_CHECKS=0" | mysql --user=$user --password=$passwd $db < $sql_file

Have a good import!

Hello all,

This error occurred to me when trying to install npm modules with npm install. I tried with Yarn but the error was similar:

error Couldn't find package "..." on the "npm" registry.

The solution was into the .npmrc file.

Read more