Find the answer to your Linux question:
Results 1 to 6 of 6
I've installed the MySQL RPMs from the MySQL site, but when I try to change the root pass, I get and error that the mysqladmin command does not exist. I've ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Oct 2004
    Posts
    5

    Unknown command: Mysqladmin


    I've installed the MySQL RPMs from the MySQL site, but when I try to change the root pass, I get and error that the mysqladmin command does not exist.

    I've installed the server, client, devel, and shaired RPMs. Is there a spacific order of install? Is this a common problem?

  2. #2
    Linux Engineer jledhead's Avatar
    Join Date
    Oct 2004
    Location
    North Carolina
    Posts
    1,077
    can you #su mysql
    and then mysqladmin??

    what happens when you type mysql and then <TAB key twice>, does it give you other mysql options.

  3. #3
    Just Joined!
    Join Date
    Oct 2004
    Posts
    5
    Quote Originally Posted by jledhead
    can you #su mysql
    and then mysqladmin??
    Are you talking about logging into mysql as root? No, because I have no root password.

    That's why I need to run the

    $>mysqladmin -u root password 'newpass' command.

    what happens when you type mysql and then <TAB key twice>, does it give you other mysql options.
    Hmm. from the command line? Nope haven't tried it. What should I see?

  4. $spacer_open
    $spacer_close
  5. #4
    Linux Engineer jledhead's Avatar
    Join Date
    Oct 2004
    Location
    North Carolina
    Posts
    1,077
    Quote Originally Posted by Jake_B
    Quote Originally Posted by jledhead
    can you #su mysql
    and then mysqladmin??
    Are you talking about logging into mysql as root? No, because I have no root password.
    no, that would be logging into the system (or changing users) to the mysql user and then issuing the mysql commands from there

  6. #5
    Just Joined!
    Join Date
    Oct 2004
    Posts
    5
    Quote Originally Posted by jledhead
    Quote Originally Posted by Jake_B
    Quote Originally Posted by jledhead
    can you #su mysql
    and then mysqladmin??
    Are you talking about logging into mysql as root? No, because I have no root password.
    no, that would be logging into the system (or changing users) to the mysql user and then issuing the mysql commands from there
    Well, when you first install MySQL, there is no root pass? I mean, normally I would install and do this first thing:

    $> mysqladmin -u root password 'some_new_password'

    But what if I install and do this:

    $> mysql -u root -p

    It will ask for a password.

    Are you saying that after a fresh install, I should be able to log in without a user or pass:

    $> mysql

    ???

  7. #6
    Linux Guru kkubasik's Avatar
    Join Date
    Mar 2004
    Location
    Lat: 39:03:51N Lon: 77:14:37W
    Posts
    2,396
    mysql has no default password, you need to be logged in as root on the local machine to execute the mysqladmin command, this is done by typing root and your root password at the login prompt, or by typing

    su -
    *root password*

    then the command. Also try the absolute filepath, probably something like

    /sbin/mysqladmin

    see if that helps
    Avoid the Gates of Hell. Use Linux
    A Penny for your Thoughts

    Formerly Known as qub333

Posting Permissions

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