mysql

Discussion in 'Installation/Configuration' started by guidovanh, Mar 21, 2006.

  1. guidovanh

    guidovanh Member

    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 #
     
    Last edited: Mar 21, 2006
  2. falko

    falko Super Moderator ISPConfig Developer

    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
     
  3. guidovanh

    guidovanh Member

    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!
     

Share This Page