Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2008
    Posts
    263

    Mysql Root Password

    Hello,

    How can change mysql root password with ssh access?

    Thank You
    Need More Power?!
    PersianWhois.Com

  2. #2
    Join Date
    Jan 2008
    Posts
    64
    Login to SSH as root then type the following:

    mysqladmin -u root -p oldpassword newpass

    Replace oldpassword with the current mysql root password

    Replace newpass with your new mysql root password.

  3. #3
    1. Or you can login via SSH to your server

    2. After that, login to your MySQL service

    mysql -u root -p
    (enter old password) if you do not have password, just press ENTER

    and after that in your MySQL execute the following command

    set password = password("newpassword")


    Quote Originally Posted by persianwhois View Post
    Hello,

    How can change mysql root password with ssh access?

    Thank You
    ---=== RoseHosting.com Admin ===---
    Linux Cloud Hosting - linuxcloudvps.com
    Linux VPS Hosting - rosehosting.com
    High Quality Linux virtual servers with lots of Guaranteed RAM and HDD space, Impeccable Service.

  4. #4
    Join Date
    Apr 2005
    Location
    Cochin
    Posts
    2,446
    http://www.mydigitallife.info/2006/0...root-password/

    try that if you donno your existing pass
    Sam
    Supportlobby.com - Expertise in Windows/Linux server support, IaaS and PaaS Management
    Spiralbean.com - Custom Software Development
    Email: exec @ activelobby.net | Skype: unni_active

  5. #5
    Join Date
    Jan 2008
    Posts
    34

    mysql root password resetting

    If you don't know the passowrd of mysql root. You can reset it with following steps.

    # /etc/init.d/mysql stop

    # mysqld_safe --skip-grant-tables &

    # mysql -u root

    # use mysql;

    # update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

    # mysql> flush privileges;

    # mysql> quit

    # /etc/init.d/mysql stop

    # /etc/init.d/mysql start
    If you know the mysql root password, you can change the password with below command.

    # mysqladmin -u root -p oldpassword newpass

  6. #6
    Join Date
    May 2008
    Location
    Sweden
    Posts
    152
    Every post is nice.....and suited for every scenario :-)
    Linux, C, Perl, Bash, PHP
    MySQL, PostgreSQL
    Postfix, Qmail
    Bind

  7. #7
    Join Date
    Apr 2005
    Location
    Cochin
    Posts
    2,446
    Quote Originally Posted by helpyoulinux View Post
    Every post is nice.....and suited for every scenario :-)
    Absolutely
    Sam
    Supportlobby.com - Expertise in Windows/Linux server support, IaaS and PaaS Management
    Spiralbean.com - Custom Software Development
    Email: exec @ activelobby.net | Skype: unni_active

Posting Permissions

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