mysql problem

dsgdevil · 02-08-2003, 08:29 PM

when i try to connect to my mysql,terminal gives me this error:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists!

i checked in the /var/lib/mysql/ directory and realized that mysql.sock dosnt exist but in the handbook "redhat linux 8 unleashed" it said that mysql.sock should be in that dir

.anyone know why this is happening?

dsgdevil · 02-08-2003, 11:29 PM

ok,i got that working but now i have this error:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
what does that mean?

Crashed_Again · 02-08-2003, 11:31 PM

how are you trying to log in? Did you create a password for root? If so type:

mysql -u root -p <enter>

You will then be prompted for a password.

dsgdevil · 02-08-2003, 11:47 PM

i coudnt set a password for root because of the error

Crashed_Again · 02-09-2003, 12:26 AM

mysqladmin -p

dsgdevil · 02-09-2003, 01:32 AM

still that error

markus1982 · 02-09-2003, 03:18 AM

First of all check that mysqld is up and running by doing a ps auxw | grep mysqld if so, the mysql socket should exists in for instance /var/lib/mysql/mysql.sock ... if not the socket path has been changed, etc. In that case check /etc/my.cnf

dsgdevil · 02-09-2003, 11:23 AM

mysqld is running but i still get the error
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
and i cant change my password because of that error

dsgdevil · 02-09-2003, 11:29 AM

and when i try /usr/bin/mysqladmin -u root password 'mypassword'
it gives me this error
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
and i'm sure mysql is running