login to mysql

[eileen1017]

One of our dba has left the company. He used to be responsible for the mysql database. I don't have much experience with mysql. I did get to login to the server. However, when I issued mysql -u=root -p, the messages -bash: mysql: command not found returned. I issued ps -ef|more, it returned mysql 7475 7451 0 Jul12 ? 00:00:00 /usr/local/mysql/libexec/mysqld. I assume mysql is running on this server? How can I find the version of mysql on this server? Is it possible that the newer version of mysql does not have these commands anymore? Please help. Thank you very much.

 

[feherke]

Hi

What operating system are you using ?

In some Linux distributions the server and the client part of MySQL are in separate packages, so is possible that only one of them to be installed. So first of all, ask your package manager.


Feherke.

http://free.rootshell.be/~feherke/

 

[eileen1017]

Hi Feherke:

I found the server that I have trouble to get any of the mysql command to work is the client part. However, when I try to login to the server part. I am still having trouble.
mysql -u root -p
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

How should I solve this problem? Gurus? Thanks.

 

[guelphdad]

That isn't the server part that you are logging in to, it is the client.

the error message means you are using a password but you are not using the correct password.

if you are unsure of the password for root then see the manual for RESET ROOT PASSWORD. it allows you to start mysql without any permissions. you can then edit the root user with a new password. Flush privileges after you do so and then restart the server normally.