Kenyans247 Forum

Welcome, Guest: Join Kenyans247 LOGIN!

Stats: 223 Members, 11,345 topics and 65 posts Date: Friday 03 April 2020 at 10:01 AM
TrendingRecentNewestClassifiedDirectoryLivescoresLive Kenyan TVLive Kenyan Radio

Change or Set the MySQL Root password

Kenyans247 / Science/Technology / Programing / Change or Set the MySQL Root password (15 View's)

Change Of Non-governmental Organization Officials In Kenya How To Change A Microsoft Word Document To A Csv File Is Africa An Example Of How Economic Corridors Can Change Development Concepts? How To Obtain Securities Exchange License In Kenya
(Go Down) (» Reply topic)
Change or Set the MySQL Root password by Kenyans247(m): 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

(» Reply topic) (» Go Up)

Recommended for you

» Change Amotekun’s Name To ‘oduduwa Guards’ – Muric » How To Change Your Facebook Email » How To Change Your Apple Id Email Address » How To Change Information On Your Nssf Card In Kenya
Viewing this topic:
1 guest(s) viewing this topic

Sections: International Forum, Homepage, Investment, Environment, Autos, Art, Graphics & Video, Phones, Webmasters, Computers, Innovation, Gossip, Sports, Music/Radio, Literature, Celebrities, Tanzania Forum, Rwanda Forum, South Sudan Forum, Somalia Forum, Burundi Forum,

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.