R-J
Verified User
I'm having this strange problem, when connected to my own server using SSH I'm trying to connect to the mysql deamon without any succes so far.
these commands give the desired results
> mysql -u root -p *****
> mysql -h localhost -u root -p *****
> mysql -u root -p ***** test
> mysql -h localhost -u root -p ***** test
> mysqladmin -u root -p *****
> mysqladmin -h localhost -u root -p *****
> mysqladmin -u root -p ***** ver
> mysqladmin -h localhost -u root -p ***** ver
have tried it with a couple of other db accounts too that are listed in the mysql users table.
The weird thing that keeps happening, after the above commands are entered and I press enter, I'm asked to enter my password (makes sense). But when I enter the correct password the response is "command not understood" or "the database ***** could not be found", where ***** is exactly the same as the password I've entered.
When I enter an incorrect password, the response from the mysql server is that the password is incorrect
Is there somekind of config setting that doesn't allow me to login from the shell?
I'm using MySQL 4.0.14, Red Hat Linux 7.3 and the latest version of DA.
these commands give the desired results
> mysql -u root -p *****
> mysql -h localhost -u root -p *****
> mysql -u root -p ***** test
> mysql -h localhost -u root -p ***** test
> mysqladmin -u root -p *****
> mysqladmin -h localhost -u root -p *****
> mysqladmin -u root -p ***** ver
> mysqladmin -h localhost -u root -p ***** ver
have tried it with a couple of other db accounts too that are listed in the mysql users table.
The weird thing that keeps happening, after the above commands are entered and I press enter, I'm asked to enter my password (makes sense). But when I enter the correct password the response is "command not understood" or "the database ***** could not be found", where ***** is exactly the same as the password I've entered.
When I enter an incorrect password, the response from the mysql server is that the password is incorrect
Is there somekind of config setting that doesn't allow me to login from the shell?
I'm using MySQL 4.0.14, Red Hat Linux 7.3 and the latest version of DA.