mysql: access denied messages

If none of the more specific forums is the right place to ask

mysql: access denied messages

Postby phrozen » 2005-10-19 04:30

Hi!

I've just installed mysql ver. 4.0.24_Debian-10-log. After running the daemon, I get 2 times the same access denied message. As I could found out, debian uses it's own /etc/mysql/debian.cnf file for the mysql client, so I tried to change the default 'debian-sys-maint' user to root, changed password and then i tried again. Without luck. The messages still appear.

Code: Select all
root@phils:/etc/init.d# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
root@phils:/etc/init.d# /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'


Note that the daemon is still running..

Code: Select all
root      9952  1.8  0.3   2800  1372 pts/1    S    06:11   0:00 /bin/sh /usr/bin/mysqld_safe
root      9988  0.0  0.3   2800  1376 pts/1    S    06:11   0:00 /bin/sh /usr/bin/mysqld_safe
mysql     9989  1.6  3.4 115980 13488 pts/1    Sl   06:11   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
root      9990  0.0  0.1   1792   556 pts/1    S    06:11   0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld


After that, I've tried localy to connect to mysqld with user root and password, with success.

Code: Select all
root@phils:/etc/mysql# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.0.24_Debian-10-log

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

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.01 sec)


While I stopped the mysqld, I became this output (again)..

Code: Select all
root@phils:/etc/mysql# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Killing MySQL database server by signal: mysqld.


Any suggestions how to fix that?
Thank you for all incomming info!
Best regards,
phrozen
User avatar
phrozen
 
Posts: 10
Joined: 2005-10-19 03:43

Return to General Questions

Who is online

Users browsing this forum: No registered users and 19 guests

fashionable