My Computer Tips

My Computer Tips was launched in 2015 and provides information for common tasks in various Linux distributions and other computer related subjects.

My Computer tips has over 290 tutorials and tips.

If you found the information on My Computer Tips useful, please consider sharing our site details.

Valid CSS!

Categories

Amazon+Associates Amazon Associates (1)

Android Android (8)

Apps Apps (1)

Bash+Scripts Bash Scripts (4)

C%2B%2B C++ (4)

Cachyos Cachyos (2)

Caja+File+Manager Caja File Manager (2)

Cinnamon+Desktop Cinnamon Desktop (1)

Computer+Ramblings Computer Ramblings (17)

CPanel CPanel (1)

CSS CSS (7)

Cups+%28Common+UNIX+Printing+System%29 Cups (Common UNIX Printing System) (3)

Debian Debian (1)

Emulators Emulators (15)

Facebook Facebook (1)

Firefox Firefox (5)

Gnome3 Gnome3 (2)

Google Google (3)

Google+Chrome Google Chrome (2)

HTML HTML (5)

Image+Editors Image Editors (2)

Java Java (5)

Kubuntu Kubuntu (5)

Libre+Office+Draw Libre Office Draw (2)

Linux Linux (3)

Linux+Mint Linux Mint (4)

Linux+Terminal Linux Terminal (47)

Lubuntu Lubuntu (4)

MariaDB+Database MariaDB Database (10)

MySQL+Database MySQL Database (2)

PC+Components+%26+Maintenance PC Components & Maintenance (8)

PHP7 PHP7 (12)

Python3 Python3 (5)

Retro+Software%2C+Magazines+%26+Games Retro Software, Magazines & Games (12)

Search+Engines+%28SEO%29 Search Engines (SEO) (2)

SQlite SQlite (1)

Steam Steam (1)

Thunderbird+Email+Client Thunderbird Email Client (6)

Ubuntu Ubuntu (32)

Ubuntu+Mate Ubuntu Mate (15)

Vanilla+Javascript Vanilla Javascript (9)

Virtualization Virtualization (5)

Windows Windows (1)

Wine Wine (5)

Xubuntu Xubuntu (10)

Show Categories

Amazon+Associates Amazon Associates (1)

Android Android (8)

Apps Apps (1)

Bash+Scripts Bash Scripts (4)

C%2B%2B C++ (4)

Cachyos Cachyos (2)

Caja+File+Manager Caja File Manager (2)

Cinnamon+Desktop Cinnamon Desktop (1)

Computer+Ramblings Computer Ramblings (17)

CPanel CPanel (1)

CSS CSS (7)

Cups+%28Common+UNIX+Printing+System%29 Cups (Common UNIX Printing System) (3)

Debian Debian (1)

Emulators Emulators (15)

Facebook Facebook (1)

Firefox Firefox (5)

Gnome3 Gnome3 (2)

Google Google (3)

Google+Chrome Google Chrome (2)

HTML HTML (5)

Image+Editors Image Editors (2)

Java Java (5)

Kubuntu Kubuntu (5)

Libre+Office+Draw Libre Office Draw (2)

Linux Linux (3)

Linux+Mint Linux Mint (4)

Linux+Terminal Linux Terminal (47)

Lubuntu Lubuntu (4)

MariaDB+Database MariaDB Database (10)

MySQL+Database MySQL Database (2)

PC+Components+%26+Maintenance PC Components & Maintenance (8)

PHP7 PHP7 (12)

Python3 Python3 (5)

Retro+Software%2C+Magazines+%26+Games Retro Software, Magazines & Games (12)

Search+Engines+%28SEO%29 Search Engines (SEO) (2)

SQlite SQlite (1)

Steam Steam (1)

Thunderbird+Email+Client Thunderbird Email Client (6)

Ubuntu Ubuntu (32)

Ubuntu+Mate Ubuntu Mate (15)

Vanilla+Javascript Vanilla Javascript (9)

Virtualization Virtualization (5)

Windows Windows (1)

Wine Wine (5)

Xubuntu Xubuntu (10)

Unable to connect to MariaDB remotely. Socket fail to connect to host on IP address, port

ID: 336

Category: MariaDB Database

Added: 16th of January 2023

Views: 2,323

Related Tips & Tutorials

➔ Unable to connect to MariaDB remotely, Host ip_address is not allowed to connect to MariaDB server

If you are having trouble connecting to MariaDB remotely, then you need to check bind-address in the MariaDB configuration file.

The MariaDB configuration file can be found under the following directory /etc/mysql/mariadb.conf.d/50-server.cnf

To open and start editing the file using nano enter the following in the terminal

nano /etc/mysql/mariadb.conf.d/50-server.cnf


Scroll until you find bind-address = 127.0.0.1
Then comment out the line #bind-address = 127.0.0.1

Add a new line for bind-address and set this to bind-address = 0.0.0.0




Save the file by pressing ctrl + o and hit enter




Then exit nano by pressing ctrl + x

Then restart MariaDB
systemctl restart mariadb

Computer Parts For Sale.

Links

Linux Forums

Arch Linux Forums Arch Linux Forums

Fedora Forums Fedora Forums

Linux Mint Forums Linux Mint Forums

Linux Questions Forum Linux Questions Forum

Ubuntu Forums Ubuntu Forums

Linux Gaming

Gaming on Linux Gaming on Linux

ProtonDB ProtonDB

Steam Download Steam Download

Other Linux / Computer Sites

Big Box Collection Big Box Collection

Phoronix Phoronix

OMG Ubuntu OMG Ubuntu

Other Sites / Shopping

Amazon Computer Parts For Sale (UK Only)

Amazon Buy Google Play Vouchers (UK Only)

Amazon Amazon (UK Only)

Latest Linux News

Latest Linux News Linux 6.18 Will Be A Big Improvement For Servers Encountering DDoS Attacks - Phoronix
Published: October 3, 2025, 6:55 pm

Latest Linux News 7 unusual Linux distros built for one purpose (and why you should try them) - XDA
Published: October 4, 2025, 8:00 pm

Latest Linux News Wii-Linux - Hackaday
Published: October 3, 2025, 5:05 am

Latest Linux News Linux App Release Roundup (September 2025) - OMG! Ubuntu
Published: October 4, 2025, 5:15 am

Latest Linux News Arch Linux's AUR Wasted My Time Until I Did This - How-To Geek
Published: October 4, 2025, 6:00 pm

Latest Linux News Intel NPU Linux Driver 1.24 released with Android support, hints at Android for PC - VideoCardz.com
Published: October 4, 2025, 9:33 am

Latest Linux News I borrowed these habits from Linux and my Windows setup is better for it - MakeUseOf
Published: October 2, 2025, 9:00 pm

Latest Linux News FOSS Weekly #25.40: Fedora 43 Features, Kernel 6.17, Zorin OS 18, Retro Gaming Setup and More Linux Stuff - It's FOSS
Published: October 2, 2025, 4:49 am

Latest Linux News Cairo-Dock 3.6 Released with Wayland and HiDPI Support, systemd Integration - 9to5Linux
Published: October 1, 2025, 6:49 pm

Latest Linux News Linux 6.18 Device Tree Prepares For Arm C1 Nano / Pro / Premium / Ultra CPUs - Phoronix
Published: October 3, 2025, 1:47 pm