Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2008
    Posts
    148

    MySQL Database Server in Webmin

    Hello

    I forgot the Password for the MySQL Database Server , How to recover it or change it without Known the old one ..

    i have access to the SSH and webmin..

  2. #2
    I have never needed to do it, but, a quick search gave me this (the info looks correct):

    http://www.howtoforge.com/reset-forg...-root-password

    or, more official:

    http://dev.mysql.com/doc/refman/5.0/...rmissions.html

    I hope this helps,

    Ildefonso Camargo

  3. #3
    Join Date
    Sep 2008
    Posts
    148
    i messed every thing up .. i do not know .. i will re-build

  4. #4
    Quote Originally Posted by onasre View Post
    i messed every thing up .. i do not know .. i will re-build
    Eh.... can you elaborate? almost everything can be fixed.

    Before rebuilding (unless you have absolutely no important info), you must create a backup of the database files, they can be used to restore data, as long as you keep the same mysql version and same config (my.cnf).

  5. #5
    Join Date
    Sep 2008
    Posts
    148
    How to start and stop the mysql daemon . that been said in the link u sent me

  6. #6
    Join Date
    Sep 2008
    Posts
    148
    Got it Thx.

    1- from webmin stop mysqld
    2-go to shh tyep this
    mysqld_safe --skip-grant-tables

    keep SSH Open .

    3- go back to webmin and change mysql password.

  7. #7
    Quote Originally Posted by onasre View Post
    Got it Thx.

    1- from webmin stop mysqld
    2-go to shh tyep this
    mysqld_safe --skip-grant-tables

    keep SSH Open .

    3- go back to webmin and change mysql password.
    Nice, did it worked as expected? (as I said, I have never needed to do that).

  8. #8
    Join Date
    Nov 2009
    Posts
    70
    The process is actually quite simple if you have SSH access..

    1. Stop mysqld and restart it with the --skip-grant-tables option.
    2. Connect to the mysqld server with this command:

    shell> mysql

    3. Issue the following statements in the mysql client. Replace the password with the password that you want to use.

    mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

    mysql> FLUSH PRIVILEGES;

    You should now be able to connect to MySQL as root using the new password.

Similar Threads

  1. How to import database through webmin?
    By Ruriko in forum Hosting Security and Technology
    Replies: 8
    Last Post: 04-16-2014, 02:34 PM
  2. Linux Server within 24hrs (MySQL,Apache,Mail,PHP,Webmin)
    By olddocks in forum Hosting Security and Technology Tutorials
    Replies: 23
    Last Post: 05-16-2009, 05:42 AM
  3. importing MySql 5.0.16 database into a server running MySql 4.1.18?
    By fantasian in forum Hosting Security and Technology
    Replies: 3
    Last Post: 04-18-2006, 01:40 PM
  4. MySQL Database Server or MaxDB by MySQL
    By linda7255 in forum Programming Discussion
    Replies: 1
    Last Post: 06-08-2004, 01:40 AM
  5. Installing Webmin / Webmin MySQL
    By inoverse in forum Dedicated Server
    Replies: 3
    Last Post: 07-30-2001, 03:59 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
  •