Failed to configure remote connections. MYSQL Ubuntu

Question

I am having trouble opening my MYSQL server for ALL remote connections. I followed many online guides and there seems to be something wrong. Perhaps SO can provide guidance? The details of my server are as follows:

• Ubuntu Server 12.04,
• MYSQL Ver 14.14 Distribution 5.5.34 for debian-linux-gnu (x86_64) using readline 6.2

/etc/mysql/my.cnf: Other things too, but the binding address is important ...

bind-address = 0.0.0.0

my.conf has the following permissions: -rw-r--r-- 1 root root 3516 Jan 31 17:12 my.cnf

The server is not blocked because: it telnet myDomain.com 3306  asks for my own mysql password.

MYSQL Queries

CREATE USER 'myUser' @ '%' IDENTIFIED 'myPASSWORD';

GRANT INSERT ON db.table_v TO 'myUser' @ '%' IDENTIFIED "myPASSWORD";

PRIVILEGES OF FLUSH;

Permissions from show grants for 'myUser'@'%';

USE OF GRANT. TO 'myUser' @ '%' IDENTIFIED BY PASSWORD '****************'

GRANT INSERT ON db. table_vIn 'myUser' @ '%'

I also restarted my server

Problem:

mysql -h myDomain.com -u myUser -p

Enter password:

ERROR 1045 (28000): Access denied for user 'myDomain' @ '*** MYIPADDRESS ***' (using password: YES)

I also cannot log in locally with any user where the host is not local, for example "%" or my home IP address.

Answer 1

, :

Access denied for user 'myDomain' 

? myUser myDomain, myUser.

:

mysql -h myDomain.com -u myUser -p

-h , mysql, . - , "localhost", , , , , . , mysql ; myDomain.com myUser , . , , , .

Answer 2

, .cnf, bind-address. , /etc/mysql/my.cnf, , mysqld.cnf mysqld.

bind-address. , , "netstat -lt" , mysql 0.0.0.0:3306.

yor

Answer 3

CREATE USER 'myUser'@'localhost' IDENTIFIED BY 'myPASSWORD';

MySQL |

I ,

GRANT ALL ON *.* TO 'myuser'@'%';

, . .

Answer 4

, MySQL? MySQL localhost, SSH.

Windows, Putty SSH , 3306 localhost .

, , SQLyog, SSH MySQL, ( VPN).

IP-?

Answer 5

,

nmap ***MYIPADDRESS***

nmap localhost

nmap MyDomain

nmap, apt, .