Welcome, Guest: Join Kenyans247 Log In!

Stats: 296 Members, 14,138 topics and 65 posts Date:  Tuesday 01 December 2020 at 08:12 AM
Popular & Trending NewestFeatured Links ClassifiedDirectoryLivescoresLive Kenyan TVLive Kenyan Radio Follow Us Like Us

About Us Terms & Conditions Privacy Policy FAQ's Disclaimer Copyright Contact Us Advertise With Us Download K247 APP Marketplace Moderator Policy We Are Hiring Kenya Radio and TV Stations Listen and Watch Live Letter From the C.E.O Kenya Radio Stations Live Kenya TV Stations Live Kenya - Newspapers and News Sites and popular blog Forum Rules

Change or Set the MySQL Root password

Kenyans247 / Science/Technology / Programing / Change or Set the MySQL Root password

99 people viewed

How To Change The Language In Microsoft Word No Change Lyrics Khaligraph Jones How To Change The Mouse Pointer Color And Size On Windows 10 How Do I Change My Whatsapp Bubble Color?
(Go Down) (» Reply topic)
Change or Set the MySQL Root password by Kenyans247(1): Sun 22, March, 2020 08:47am
For every database, you should set the root or sa passwords to something other than the default, unless you want to get hacked. For mysql, the system administrator user is called root. You will use the mysqladmin utility from a command line to set the new password. Notice that there are two commands to be run.

Syntax:

mysqladmin -u root password “newpassword”

mysqladmin -u root -h host_name password “newpassword”

Example:

mysqladmin -u root password ws8dr8as3

mysqladmin -u root -h localhost password ws8dr8as3

You will also want to restart the database server after running this command

sudo /etc/init.d/mysql restart

0 Shares 0 Like •

(» Go Up)

You must Sign in or Sign Up to post content

For you to post content on this website you have to log in or register, it only take few minute to create account

Go Up

Recommended for you

William Ruto's Ally Oscar Sudi Backs Punguza Mizigo Bill To Change Constitution How To Apply For Change Of Name In Kenya How Do You Change The Text Color On Whatsapp? Mobile Lenders Now Change Tack In Collection Of Debt

Currently: 1 guest(s) reading this article

Sections: Career, Diaspora, Family, Politics, Homepage, Art, Graphics & Video, Phones, Technology Market, Webmasters, Computers, Fashion, Music/Radio, Gaming, Forum Games, Photography, Rwanda Forum, Tanzania Forum, Somalia Forum, Ugandan Forum, South Sudan Forum,

About Us | Terms & Conditions | Privacy Policy | FAQ's | Disclaimer | Copyright | Contact Us | Advertise With Us | Download K247 APP | Marketplace | Moderator Policy | We Are Hiring | Kenya Radio and TV Stations Listen and Watch Live | Letter From the C.E.O | Kenya Radio Stations Live | Kenya TV Stations Live | Kenya - Newspapers and News Sites and popular blog | Forum Rules | Featured LinksFollow Us on TwitterLike Us on Facebook

Kenyans247 - Copyright © 2019 - 2020 Sande Kennedy. All rights reserved. See How To Advertise.
Disclaimer: Every Kenyans247 member is solely responsible for anything that he/she posts or uploads on Kenyans247.