unable to login remotely in MYSQL

Question

I am very new to mysql and I want to use remote login I followed this stack process but the command gives me nothing on the screen as listed on that link

$ lsof -i -P | grep :3306
$

this is the output.

What I did so far: I edited the file /etc/mysql/my.cnf to make change and looks like this

skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address        = 0.0.0.0

What I want basically that I want remote login.But I am unable to that. I run following command on my terminal

$ mysql -h 127.6.110.2 -u adminTwz5PWn -p
$ enter password:
ERROR 1045 (28000): Access denied for user 'adminTwz5PWn'@'localhost' (using password: YES)

For sake of information needed I got this username and password from Openshift My concern is that how @'localhost' comes into the picture If I am providing the host ip in the command

I have user log in to mysql as follows

+------------------+---------------+
| user             | host          |
+------------------+---------------+
| root             | %             |
| root             | 127.0.0.1     |
| adminvKbP1kf     | 127.3.138.130 |
| adminTwz5PWn     | 127.6.110.2   |
| root             | ::1           |
| user             | hostname      |
| debian-sys-maint | localhost     |
| phpmyadmin       | localhost     |
| phpmyadmin_suraj | localhost     |
| root             | localhost     |
| suraj            | localhost     |
+------------------+---------------+

Please correct me if I am wrong anywhere. And what steps are needed to make this successfull

`using password: YES` suggests the password is incorrect. Do you have separate users for `127.0.0.1` and `%` hosts with different passwords? — ʰᵈˑ, Mar 02 '15 at 17:32
Is lsof even installed? Stupid question, but you never know. — Orpheus, Mar 02 '15 at 17:34
@Orpheus Yes I having lsof I did by sudo apt-get install lsof — Suraj Palwe, Mar 02 '15 at 17:35
@ʰᵈˑ I have ..Please see the edited question.I added users list — Suraj Palwe, Mar 02 '15 at 18:01
possible duplicate of [OpenShift: How to connect to postgresql from my PC](http://stackoverflow.com/questions/20960407/openshift-how-to-connect-to-postgresql-from-my-pc) — , Mar 02 '15 at 20:27

score 1 · Answer 1 · edited May 23 '17 at 11:56

1

If you are running this on OpenShift, and trying to connect from your local workstation, you need to use the rhc port-forward command. Check the answer to a very similar question, but it was using postgresql, you can adapt it very easily to use mysql: OpenShift: How to connect to postgresql from my PC

edited May 23 '17 at 11:56

Community

1
1

answered Mar 02 '15 at 20:27

You would use the rhc port-forward command, and connect to the mysql port for your application instead of the postgresql one. – Mar 03 '15 at 01:12

royki · Answer 2 · 2015-03-11T18:28:02.853

0

You should first restart the MySQL server

/etc/init.d/mysqld restart

edited Mar 11 '15 at 18:28

answered Mar 02 '15 at 17:34

royki

1,593
3
25
45

It gives me like this ::: Checking for tables which need an upgrade, are corrupt or were not closed cleanly. – Suraj Palwe Mar 02 '15 at 17:37
Now you try to log in mysql -h 127.6.110.2 -u XXX -p – royki Mar 02 '15 at 17:39
Then kill the mysql service and start it again. Do first /etc/init.d/mysql restart – royki Mar 02 '15 at 17:42
I followed same as you said but still same – Suraj Palwe Mar 02 '15 at 17:47
are you sure that mysql process stopped properly , Use kill -9 mysql_process_ID Then check the status . Do those steps. It should work. – royki Mar 02 '15 at 18:03
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/72080/discussion-between-learner-and-altius). – Suraj Palwe Mar 02 '15 at 18:08

bluecollarcoder · Answer 3 · 2015-03-02T23:05:47.370

0

It looks like Mysql is not able to resolve your host so it is defaulting to localhost. So when looking up permissions for your login, it evaluates 'adminTwz5PWn'@'localhost' instead of 'adminTwz5PWn'@IP. I suspect that problem has something to do with the bind address 0.0.0.0. Try changing the bind address to 127.0.0.1 or localhost and see what happens.

edited Mar 02 '15 at 23:05

answered Mar 02 '15 at 22:58

bluecollarcoder

14,339
4
22
18

unable to login remotely in MYSQL

3 Answers3