Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides

FAQ

It is currently Sun Dec 10, 2023 5:09 am

ROOT ‹ Website Development and Databases ‹ Mysql ‹ Mysql change root password

Mysql Application & Query Optimization, Questions, Indexes, Bugs.

Post a reply

1 post • Page 1 of 1

Mysql change root password

« Previous topic | Next topic »

Author

Message

mandrei99

Post subject: Mysql change root password | Posted: Tue Feb 10, 2015 6:50 pm

Joined: Tue Aug 04, 2009 9:16 am
Posts: 250

Mysql change root password

Mysql administrator account is the "root" account. As in Linux this account has all privileges, writing and reading all the databases in MySql server, changing running parameters of the server and so on. It is a security safeguard to keep this password as long and complex as possible (to include upper and lower characters, digits and SHIFT+Numerical keys.

Changing MySql root account password:

To change mysql root password, use administrator account, usually root, and run the following queries:

Code:

mysql> update mysql.user set password=password(’NEW PASSWORD’) where user=‘root’;
mysql> flush privileges;

The first mysql query will update the password field in the "user" table in "mysql" database belonging to "root" row and the second query will make the mysql server aware of the change immediately, instead of restarting the server.
Source: https://vpsie.com/securing-mysql-database-shared-hosting-environment/

			Tweet
Follow @IvordeCom

You might also be interested in:
Mysql change column's default value. Mysql - Change position of a column after another column. MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13). Mysql: add column to table. Rename MySql table. MySql rename table. How to use a mysql stored procedure. Mysql: Cleaning binary logs. Mysql drop (remove) unique key. Mysql add Unique index to a table column.

Top

Post a reply

1 post • Page 1 of 1

Topics		Author	Replies	Views	Last post
Topics related to - "Mysql change root password"
	Mysql change column's default value	debuser	0	2794	Thu Aug 12, 2010 3:43 am debuser
	Mysql - Change position of a column after another column	admin	1	4422	Fri Oct 08, 2010 1:41 am sonee4
	MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)	debuser	0	3220	Mon Feb 22, 2010 1:43 pm debuser
	Mysql: add column to table	debuser	1	4265	Fri Oct 08, 2010 1:38 am sonee4
	Rename MySql table	debuser	1	2373	Fri Oct 08, 2010 1:36 am sonee4
	MySql rename table	admin	2	2857	Mon Nov 28, 2011 3:39 am Darwin
	How to use a mysql stored procedure	debuser	1	2350	Tue Nov 22, 2011 1:23 am Darwin
	Mysql: Cleaning binary logs	debuser	1	2772	Tue May 18, 2010 9:45 am designeru
	Mysql drop (remove) unique key	mandrei99	0	2722	Wed Jan 14, 2015 7:53 pm mandrei99
	Mysql add Unique index to a table column	debuser	0	3306	Fri Aug 06, 2010 10:01 am debuser

Who is online

Users browsing this forum: No registered users and 0 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:

Channel list

ROOT ‹ Website Development and Databases ‹ Mysql

Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]