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

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


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

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

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

Offline
 

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/





Top
Display posts from previous:  Sort by  
E-mail friendPrint view

Topics related to - "Mysql change root password"
 Topics   Author   Replies   Views   Last post 
There are no new unread posts for this topic. Mysql change column's default value

debuser

0

2794

Thu Aug 12, 2010 3:43 am

debuser View the latest post

There are no new unread posts for this topic. Mysql - Change position of a column after another column

admin

1

4422

Fri Oct 08, 2010 1:41 am

sonee4 View the latest post

There are no new unread posts for this topic. 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 View the latest post

There are no new unread posts for this topic. Mysql: add column to table

debuser

1

4265

Fri Oct 08, 2010 1:38 am

sonee4 View the latest post

There are no new unread posts for this topic. Rename MySql table

debuser

1

2373

Fri Oct 08, 2010 1:36 am

sonee4 View the latest post

There are no new unread posts for this topic. MySql rename table

admin

2

2857

Mon Nov 28, 2011 3:39 am

Darwin View the latest post

There are no new unread posts for this topic. How to use a mysql stored procedure

debuser

1

2350

Tue Nov 22, 2011 1:23 am

Darwin View the latest post

There are no new unread posts for this topic. Mysql: Cleaning binary logs

debuser

1

2772

Tue May 18, 2010 9:45 am

designeru View the latest post

There are no new unread posts for this topic. Mysql drop (remove) unique key

mandrei99

0

2722

Wed Jan 14, 2015 7:53 pm

mandrei99 View the latest post

There are no new unread posts for this topic. Mysql add Unique index to a table column

debuser

0

3306

Fri Aug 06, 2010 10:01 am

debuser View the latest post

 

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:  
News News Site map Site map SitemapIndex SitemapIndex RSS Feed RSS Feed Channel list Channel list


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



phpBB SEO