How to Update or Change Password for a Single User in MySQL and Reload PrivilegesJanuary 17th, 2009 MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly update a password using the following method to update or change passwords:
1) Login to the MySQL server, type the following command at the shell prompt:
$ mysql -u root -p
2) Use the mysql database (type commands at the mysql> prompt):
mysql> use mysql;
3) Change password for a user:
mysql> update user set password=PASSWORD("newpass") where User='YOUR-USER-NAME';
4) Reload privileges:
mysql> flush privileges;
mysql> quit
[P.S.
Mambo / Joomla Password - How to Reset / RecoverMarch 2nd, 2006 Mambo / Joomla passwords cannot be recovered as they are set using a one-way hash function (MD5). However they can be reset to new values.
How to Recover MySQL Root PasswordJanuary 17th, 2009 Do you want to recover the MySQL root password. its by no means, easy.
How To Migrate Mantis Defect Tracking System From Windows To Linux / Fedora Core 6May 12th, 2007 Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux.
How To Recover Openfire admin Password October 22nd, 2007 Openfire is a cross-platform java based free Instant Messaging server which implements the XAMPP (Jabber) protocol with extensions. It is very well suited as corporate instant messaging solution.
How do I Enable Remote Access To MySQL Database?April 27th, 2009 Suppose you want to change and enable the remote access to MySQL DB on your linux server (Debian). By default, you don't get such privileges so you will have to work your way through this.
How To Quickly Analyze All Tables in MySQL DatabaseJune 12th, 2007 ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query.
How to Backup & Restore MySQL DatabaseMay 13th, 2005 Note: My WordPress database name is wordpress. I will use it in the example below.
How To Change MySQL PasswordApril 20th, 2008 Let's look at all the ways to change MySQL password, for root and other users:
In MySQL the default password is empty. This is inherently unsafe and should be immediately changed.
MySQL: Creating Users & Granting Access SimplifiedNovember 23rd, 2007 In MySQL you can use the GRANT statement to create users and assign privileges to them at the same time. It is extremely convenient and beats create user or directly hacking the mysql.user table.
Security Vulnerability: Firewall Site Exposes Sensitive Data Through phpMyAdminSeptember 9th, 2007 I was looking for the wiki of a popular Linux based firewall site. The main url was 404, so I went up one level hoping to find a new url.
6 MySQL Database Replication TipsNovember 18th, 2007 Replicating on two or more MySQL master database servers
1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master
2.
How to Set Up Root Password for Your MySQL ServerJanuary 17th, 2009 If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To set up a root password for the first time, use the mysqladmin command at the shell prompt as follows:
$ mysqladmin -u root password newpass
If you want to change (or update) a root password, then you need to use the following command:
$ mysqladmin -u root -p oldpassword newpass
I hope this will work for you perfectly.
Tip: How To Find MySQL VersionSeptember 1st, 2007 Try:
mysql -e status|grep 'Server version'
If that doesn't work then use:
mysql -u root -p -e status|grep 'Server version'
Provide root password when prompted. Default root password for MySQL is empty string, so just pressing enter when prompted for password will suffice by default.
How to Change MySQL Password for Other UsersJanuary 17th, 2009 Do you get this error message when you try to change the root password?
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Or may be you need to change the MySQL password for other users. So what do you do then?
To change a normal user password you need to type:
$ mysqladmin -u user-name -p oldpassword newpass
Comment Below | 
Email this Article
Loading ...