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.
SSH Login works for root but not named user account
Please login to leave a reply, or register at first.