0

I am experiencing some difficulties to configure MySQL Server and allow remote connections. I am currently using Ubuntu Server 16.04 and the latest MySQL version.

This is the error Workbench throws me when I try to connect:

enter image description here

I have been following and reading tutorials to configure it at this point. So, the relevant things i have done for this are:

  1. Install the latest version of MySQL

  2. Create a user granting full privileges for local and outsiders.

    CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
    CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
    GRANT ALL ON *.* TO 'myuser'@'localhost';
    GRANT ALL ON *.* TO 'myuser'@'%';
    
  3. I modified the MySQL configuration file /etc/mysql/mysql.conf.d/mysqld.cnf using nano. The change i made was replacing this:

    bind-address = 127.0.0.1
    

    For this:

    bind-address = 0.0.0.0
    

    To allow remote connections.

  4. Using UFW I am allowing the port 3306 and 3306/tcp. Using the command sudo ufw status I am getting this (i am showing only the relevant):

    3306 (v6)                  ALLOW       Anywhere (v6)
    3306/tcp (v6)              ALLOW       Anywhere (v6)
    

Which as far I know is all I need to connect remotely right?

The way I am connecting:

enter image description here

MySQL users:

enter image description here

  • Oh, one more thing, inside the mysqlid.cnf there was suppose to be a line like this: "skip-networking" ... I was suppose to comment it or remove it, but i did not saw any line like that. – Kaba Apr 2 '18 at 22:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.