mysql setup

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • devikacs
    New Member
    • Jun 2007
    • 96

    mysql setup

    i am trying to set up a mysql server on my system.
    i yum installed mysql and mysql-server
    i also ran mysql_install_d b
    but when i try mysqladmin -u root password 'xxxx', i get error
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localho st' (using password: NO)'
    can someone pls help me
  • Atli
    Recognized Expert Expert
    • Nov 2006
    • 5062

    #2
    That would indicate that the root password has already been set.
    You could try creating a new password.

    Login as root and do the following:
    Code:
    $ mysql -u root
    
    mysql> SET PASSWORD FOR root@localhost=PASSWORD('newPwd');
    
    mysql> FLUSH PRIVILEGES;

    Comment

    Working...