Mysql problem with password

Discussion in 'Server Operation' started by kokeroulis, Nov 11, 2008.

  1. kokeroulis

    kokeroulis New Member

    Hello. I am using ubuntu 8.04

    i have follow the instructions of this page

    Code:
    http://www.howtoforge.com/ubuntu_lamp_for_newbies
    and in the step in which i must press

    Code:
    mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
    it came up the following error

    Code:
    ERROR 1045: Access denied for user: 'root@localhost' (Using 
    password: NO)
    i read this page and i do everything but when i am pressing the comand

    Code:
    /usr/bin/mysqld --skip-grant-tables --user=root
    the terminal stucks (the above command doesn't work).

    What should i do to fix it?

    Also i want my mysql to be local.So should i change the?
    Code:
    bind-address = 127.0.0.1
    And finaly how can i run the phpmyadmin.I have install it but i don't know how to run it.

    Please help me
     
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Please try
    Code:
    mysqladmin -u root password yourpassword
    instead.

    No, don't change it.

    Try
    http://1.2.3.4/phpmyadmin/ (replace 1.2.3.4 with the server's IP address or hostname).
     
  3. kokeroulis

    kokeroulis New Member

    ok.thanks.
     

Share This Page