MySQL: Difference between revisions

From miki
Jump to navigation Jump to search
Line 36: Line 36:
sudo mysqld_safe --skip-grant-tables & # Restart it with option not to ask for passwords
sudo mysqld_safe --skip-grant-tables & # Restart it with option not to ask for passwords
sudo mysql -u root mysql # Connect to MySQL, table mysql
sudo mysql -u root mysql # Connect to MySQL, table mysql
<source>
</source>
Apply the MySQL script above, and restart the server:
Apply the MySQL script above, and restart the server:
<source lang="bash">
<source lang="bash">

Revision as of 21:33, 15 March 2011

References

Passwords

Change

Using mysqladmin:

mysqladmin -u USERNAME password NEWPWD               # Assumes no password set - use user=root for admin pwd
mysqladmin -u USERNAME -p'OLDPWD' password NEWPWD

!!! SECURITY HOLE !!! — don't forget to DELETE YOUR BASH HISTORY FILE !!!

rm ~/.bash_history


Using MySQL commands. First we connect to MySQL server and select table mysql (don't forget to DISABLE HISTORY FILE !!!):

% MYSQL_HISTFILE=/dev/null mysql -u root -p mysql

Here the script:

update user set password=PASSWORD("NEWPWD") where User='USERNAME';
flush privileges;
quit

Recover root password

If the MySQL root password is lost, the same script can be used to define a new password, but it requires to restart the MySQL server with option --skip-grant-tables:

sudo /etc/init.d/mysql stop                   # Stop MySQL server
sudo mysqld_safe --skip-grant-tables &        # Restart it with option not to ask for passwords
sudo mysql -u root mysql                      # Connect to MySQL, table mysql

Apply the MySQL script above, and restart the server:

sudo /etc/init.d/mysql restart