SSH Login works for root but not named user account

digit1001's profile image digit1001 posted 9 years ago in General Permalink
I am moving to a new server and was able to export/import the database, create and create a new test user w/ all privileges. With a user of "demo" and password "test", I can do the following from the cli...

# mysql -u demo -p
Enter password: test

This lets me in no problem. I've tried it when logged in as my named account on the server and after doing

# sudo su -

Both work.

In heidi, I started with a copy of a previous working SSH tunnel and Settings:

Network type: MySQL (SSH Tunnel)
Host/IP: 127.0.0.1
checked prompt for credentials
Port: 3306
Checked Compressed client

In SSH Tunnel:
plink location: my local location
SSH Host: IP of new server
Username: my named login account
Pass: my pass on the server
Timeout: 4
Private key file: PuTTy private key
Local Port: 3307

When I try to login if I use "demo/test" I get the "Access denied for user 'demo'@'127.0.0.1' (using password" YES) error.

If I do the same but instead of "demo/test" I enter "root/mysqlrootpwd" it will let me in.

The demo account has been granted all permissions on *.* so I don't understand why it wouldn't be recognized. Any help or ideas to check would be appreciated.
ansgar's profile image ansgar posted 9 years ago Permalink
The demo user is probably restricted to some hostname. You can check that with HeidiSQL's user manager. If that's set to "localhost", try to change it to 127.0.0.1

Please login to leave a reply, or register at first.