I follow the instructions on http://howtoforge.com/perfect_setup_suse_10.0 On page 4 is described how to install and configure MySQL. Code: linux:~ # mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) linux:~ # mysqladmin -u root password ********* mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' linux:~ # What is going wrong? (only in this message my password is replaced by *********) For your info: Code: linux:/home # netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:mysql *:* LISTEN 5650/mysqld tcp 0 0 *:sunrpc *:* LISTEN 4119/portmap tcp 0 0 *:ftp *:* LISTEN 4594/proftpd: (acce tcp 0 0 192.168.2.100:domain *:* LISTEN 4434/named tcp 0 0 localhost:domain *:* LISTEN 4434/named tcp 0 0 *:ipp *:* LISTEN 4643/cupsd tcp 0 0 *:smtp *:* LISTEN 4815/master tcp 0 0 localhost:1017 *:* LISTEN 4657/fam tcp 0 0 localhost:953 *:* LISTEN 4434/named tcp 0 0 *:pop3 *:* LISTEN 4228/couriertcpd tcp 0 0 *:imap *:* LISTEN 4221/couriertcpd tcp 0 0 *:www-http *:* LISTEN 4891/httpd2-prefork tcp 0 0 *:domain *:* LISTEN 4434/named tcp 0 0 *:ssh *:* LISTEN 4592/sshd tcp 0 0 *:smtp *:* LISTEN 4815/master tcp 0 0 localhost:953 *:* LISTEN 4434/named tcp 0 0 *:https *:* LISTEN 4891/httpd2-prefork linux:/home #
Have you set a MySQL password, as described in the tutorial? Code: mysqladmin -u root password yourrootsqlpassword If you don't have a password, then you connect to MySQL like this: Code: mysql -u root If you have a password, you do it like this: Code: mysql -u root -p
As described in my initial message, I have a password, so when I enter Code: mysql -u root -p I will login correctly. it was my mistake to try to login with: Code: mysql Thanks for your help!
