changing mysql root password

November 7, 2006 at 7:30 am 3 comments

mysqladmin -u root password yournew password

#changing root password

login as root to mysql
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
Advertisements

Entry filed under: MySQL.

installing Gnome Desktop on CentOs/RH/FC Server installation Open Sourcing Java

3 Comments Add your own

  • 1. Ituloy AngSulong  |  November 9, 2006 at 5:31 am

    Malimit ko ring malimutan yang command na yan. Advantage of keeping blogs, repository ng iba’t ibang ginagawa na nalilimutan minsan.

    Reply
  • 2. Dim  |  November 15, 2006 at 2:40 pm

    I cant see root user at MySQL Administrator.
    When i try to add a new user i see this message:

    Could not Fetch Usernames
    Access denied for ‘root’@%’ to database ‘mysql’

    any suggestions???

    Reply
  • 3. mmg007  |  December 21, 2006 at 3:26 am

    maybe… u didn’t set your root password yet?

    Reply

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


November 2006
M T W T F S S
    Mar »
 12345
6789101112
13141516171819
20212223242526
27282930  

%d bloggers like this: