Ubunutu 6.06 mysql setup problems

Discussion in 'Installation/Configuration' started by badgerbox76, Jun 8, 2006.

  1. badgerbox76

    badgerbox76 New Member

    I am geting error message, could some one tell me how to fix it. Thanks much


    admin@admin-desktop:~$ mysqladmin -u root password mysqlpassword
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    admin@admin-desktop:~$ mysqladmin -h monitorwaves.no-ip.org -u root password mysqlpassword
    admin@admin-desktop:~$ mysqladmin -h monitorwaves.no-ip.org -u root password mysqlpassword
    mysqladmin: connect to server at 'monitorwaves.no-ip.org' failed
    error: 'Access denied for user 'root'@'admin-desktop' (using password: NO)'
    admin@admin-desktop:~$

    hosts
    <CODE>
    192.168.0.105 admin-desktop monitorwaves.no-ip.org
    127.0.0.1 localhost admin-desktop

    # The following lines are desirable for IPv6 capable hosts
    ::1 ip6-localhost ip6-loopback
    fe00::0 ip6-localnet
    ff00::0 ip6-mcastprefix
    ff02::1 ip6-allnodes
    ff02::2 ip6-allrouters
    ff02::3 ip6-allhosts
    </CODE>
     
    Last edited: Jun 9, 2006
  2. till

    till Super Moderator

    Have you set any root mysql password before?
     
  3. badgerbox76

    badgerbox76 New Member

    yes i have set the root password for the mysql server and was entering.
     
  4. falko

    falko Super Moderator

    If you have set a password before, then you must use

    Code:
    mysqladmin -u root -pcurrentpassword password newpassword
    (there's no space between -p and currentpassword!).
     
  5. badgerbox76

    badgerbox76 New Member

    I am still having problems connecting to my sql server.

    admin@monitorwaves:~/Desktop$ mysqladmin -u root -psqladmin007 password bondsql007
    admin@monitorwaves:~/Desktop$ mysqladmin -h monitorwaves.no-ip.org -u root password bondsql007
    mysqladmin: connect to server at 'monitorwaves.no-ip.org' failed
    error: 'Host 'monitorwaves.no-ip.org' is not allowed to connect to this MySQL server'
    admin@monitorwaves:~/Desktop$ hostname
    monitorwaves.no-ip.org
    admin@monitorwaves:~/Desktop$ hostname -f
    monitorwaves.no-ip.org
    admin@monitorwaves:~/Desktop$

    what els can i do to fix this? Thanks
     
  6. falko

    falko Super Moderator

  7. badgerbox76

    badgerbox76 New Member

    Way does mysql not have a host name? and how can i give it one.

    admin@monitorwaves:~$ netstat -tap
    (No info could be read for "-p": geteuid()=1000 but you should be root.)
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
    tcp 0 0 localhost.localdo:36233 *:* LISTEN -
    tcp 0 0 *:mysql *:* LISTEN -
    tcp 0 0 monitorwaves.no-:domain *:* LISTEN -
    tcp 0 0 localhost.locald:domain *:* LISTEN -
    tcp 0 0 localhost.localdoma:ipp *:* LISTEN -
    tcp 0 0 localhost.localdoma:953 *:* LISTEN -
    tcp 0 0 localhost.localdo:43423 *:* LISTEN -
    tcp 0 0 localhost.localdo:60349 localhost.localdo:36233 ESTABLISHED-
    tcp 0 0 localhost.localdo:36233 localhost.localdo:60349 ESTABLISHED-
    tcp6 0 0 *:ssh *:* LISTEN -
    tcp6 0 0 ip6-localhost:953 *:* LISTEN -
    tcp6 0 1036 monitorwaves.no-ip.:ssh ::ffff:192.168.0.1:3327 ESTABLISHED-
     
  8. falko

    falko Super Moderator

    It does have a hostname. Go to the mysql.users table in your MySQL database, and you'll see your hostname there.
     

Share This Page