Results 1 to 4 of 4

Thread: mysql root account password

  1. #1
    Join Date
    Jul 2009
    Posts
    19

    mysql root account password

    I am trying to install mysql on an older box. I want to try out the XOOPS features on this old distribution. I have this machine running with Fedora 6. When i try to log into my sql buy this command :
    Code:
    mysqladmin -u mysql -p create xoops4
    I get a password prompt. But i have not password protected it. How did the password prompt come? Can anyone help me get through it? Thanks in advance...

  2. #2
    Join Date
    May 2008
    Posts
    4,088

    Re: mysql root account password

    Try to login with root by entering this command at console :
    Code:
    mysql -u root -p
    If you are prompted for a password then you will need to add a password. Use this command :
    Code:
    mysqladmin -u root password 'enter-pass-here'
    Then again try to login as root :
    Code:
    mysql -u root -p
    Then enter the new pass and create database and add users...

  3. #3
    Join Date
    Jul 2009
    Posts
    19

    Re: mysql root account password

    Still on the same problem. I cannot get through mysql :
    Code:
    # mysqladmin -u root -p status
    Enter password:
    mysqladmin: connect to server
    at 'localhost' failed
    error: 'Can't connect to local MySQL server
    through socket '/var/lib/mysql/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

  4. #4
    Join Date
    Apr 2008
    Posts
    3,526

    Re: mysql root account password

    Go to console and enter the following command :
    Code:
    mysql -u root -p -h localhost
    This will get you through... The mysql server takes some assumptions if you do not provide correct parameters.. Hope this works for you..

Similar Threads

  1. Replies: 3
    Last Post: 07-11-2009, 08:36 PM
  2. What is the mysql default password ?
    By avit in forum Software Development
    Replies: 3
    Last Post: 11-09-2009, 05:42 PM
  3. How to reset mysql password?
    By Yarn in forum Software Development
    Replies: 2
    Last Post: 23-05-2009, 06:04 PM
  4. How to change password in MySQL?
    By Tweaker in forum Software Development
    Replies: 2
    Last Post: 20-10-2008, 04:47 PM
  5. Change password/disable account - password cached?
    By gbug in forum Active Directory
    Replies: 3
    Last Post: 25-04-2008, 05:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •