How to access a remote mysql host on Ubuntu inside VMware?

I am running Ubuntu 10.10 inside a VMware merge on Mac OSX Snow Leopard. Inside ubuntu, I am trying to use the mysql command line to connect to a database hosted on a separate web server. For some reason, mysql does not correctly interpret the remote host name as a local address and cannot connect to the database.

Steps: (from ubuntu inside VMware)

mysql -u <my-username> -h mysql-2.sandbox.wrkng.net -p

Enter Password: <my password>

Expected: to login to mysql

got:

ERROR 1045 (28000): Access denied for user '<my-username>'@'c-71-233-98-90.hds1.ma.comcast.net' (using password: YES)

Note that the host name provided in the error message is different from the name I entered in the mysql command.

In addition, executing the same command from a Mac (virtual machine host) successfully connects to the database.

VMware Linux, - - , - ubuntu VM . , ubuntu .

. !

+3
2
0

, , , , , phpmyadmin permssions,

oh, mysql, :

/etc/mysql/my.cnf

: bind-address = 127.0.0.1  to: # bind-address = 127.0.0.1 mysql:

sudo service mysql restart .

0

Source: https://habr.com/ru/post/1783021/


All Articles