mysql instal in linux os

Discussion in 'MySQL' started by nandhakumar, Oct 4, 2012.

  1. #1
    mysql instal in linux os. mysql successfully instal. But not Connected database;current_user: root@localhostError Affect: Password mismatch..
     
    nandhakumar, Oct 4, 2012 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    What OS are you installing on and what steps did you take to install it?
     
    jestep, Oct 4, 2012 IP
  3. Web Solutions

    Web Solutions Peon

    Messages:
    64
    Likes Received:
    1
    Best Answers:
    5
    Trophy Points:
    0
    #3
    Have you set root password ? If so, please try changing it and see what happens then.

    mysqladmin -u root password PASSWORD
    Code (markup):
     
    Web Solutions, Oct 4, 2012 IP
  4. RoseHosting

    RoseHosting Well-Known Member

    Messages:
    230
    Likes Received:
    11
    Best Answers:
    11
    Trophy Points:
    138
    #4
    You can also run 'mysql_secure_installation' and set your MySQL 'root' password there. If that still doesn't help you, then please provide more information about your setup, such as what linux distro you are running on, how are you trying to connect to your database etc....
     
    RoseHosting, Oct 4, 2012 IP
  5. sahabcse

    sahabcse Well-Known Member

    Messages:
    272
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    140
    #5
    However, if you want to change (or update) a root password, then you need to use following command

    $ mysqladmin -u root -p'oldpassword' password newpass
     
    sahabcse, Oct 4, 2012 IP
  6. nandhakumar

    nandhakumar Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    when i install MySQL-server-5.5.28.1.rhel5.i386.rpmls:/var/lib/mysql/*.err: no such file or directoryls:/var/lib/mysql/*.err: no such file or directory
     
    nandhakumar, Oct 4, 2012 IP
  7. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #7
    I would uninstall it and use Yum to install the whole package. Assuming you're using RHEL or CentOS, there's no reason to install by RPM if you don't have to.
     
    jestep, Oct 5, 2012 IP
  8. nandhakumar

    nandhakumar Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Error : access denied for user 'root'@localhost(using password :yes)
     
    nandhakumar, Oct 5, 2012 IP
  9. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #9
    Did you run: mysqladmin -u root password PASSWORD

    after the install?
     
    jestep, Oct 5, 2012 IP