Hi. First of all thanx for reading this posting. I read all the posting about the same error posted before. I just installed mysql and:

/# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO

but when :

root@jakub:/# mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 to server version: 3.23.55

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

it goes on with out even promting for a password. When I tried to change passw. for user root or mysql I get follwing:

root@jakub:/# mysqladmin -u root -p test
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

when tried to change password for user mysql:


root@jakub:/# mysqladmin -u mysql -p test
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'mysql@localhost' (Using password: YES)'

Well thats why I am so confused because I can go to mysql with user mysql with out beeing prompted for a passwd. and I can assign a passwd to that user or change it. I did run script mysql_install_db as a user mysql. went through just fine.

Jakub

AFTER YOU SEE

"Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 to server version: 3.23.55

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
"
DO THIS!!!

mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD('mynewpassword') WHERE User='root';
mysql> FLUSH PRIVILEGES;


And you may refer to this thread for more info:

http://www.linuxquestions.org/questi...&postid=226503

Then if you want to see how many users there are:

mysql shell> use mysql;
mysql shell> select user from user;

I alway do this one:


mysql shell> select user from user were password='';

If you see any users with no pass like root, then change em!! or delete them, most times you will see two root users, one with a pass and one with not! This can be a real security hazzard.

werd'

root@jakub:/# mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.55

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

Just tried it.

No pun intended but you messed it up:

root@jakub:/# mysql -u mysql

"-u" is user so your trying to log in to mysql with the user "mysql".

It's

root@jakub:/# mysql -u root

"ERROR 1044: Access denied for user: '@localhost' to database 'mysql'"

says your not logged is as a user. If you were it would say, "denied for user: 'root@localhost' ". If this is the case you need to reset the root pass.

root@jakub:/home/jakublgz# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

mysql@jakub:/home/jakublgz$ mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

I can log int to mysql from any user account with out even beeing asked for password. I can not log in from root though. I also can not change the passwd using mysqladmin.
I am new to it so I am not to sure. Should I just reinstall it ? I compiled it myself.
Jakub

erased double post>

root@jakub:/home/jakublgz# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

it saz 'root@localhost'
and when
root@jakub:/home/jakublgz# mysqladmin -u root password
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)

:>
?

My Bad, try:

root@jakub:/home/jakublgz# mysql -u root -p

When it promts for a password just hit enter'

root@jakub:/home/jakublgz# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)


see but the think is I never did set one for any of users because I didnt let me . When using mysqladmin I get:
root@jakub:/home/jakublgz# mysqladmin -u root password
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
(((

My last idea is that you shut it down and start the mysql server with "--skip-grant-tables" option. And then go in like before "mysql -u root -p" and set the pass as I described above.

Look here:

http://www.linuxquestions.org/questi...threadid=45551

too bad you can't use the mysql DB then you can see if root is really there! We now know that there is a user "mysql" that has no priviledge to use the database "mysql".

I gues you didnt see me login as user mysql to mysql,,, well neverming I am reinstalling it now.
Thanx for help/
jakub