iDoumo Projects

Home

Forum

Wednesday, 27 August 2008

Main Menu

Workday Devil Mountain Run draws 1,800+ runners, walkers

A pack of lean and muscular runners of many ages bolted from the starting line in downtown Danville this morning just as the sun broke through the fog.

Behind the competitive runners followed those of varying levels of proficiency, some running with strollers, others walking dogs, holding hands, or listening to music.

Threatened with cancellation just weeks ago for lack of a title sponsor, today's Workday Devil Mountain Run attracted about as many people as last year's run and likely raised even more money for Children's Hospital Oakland, organizers said.

iDoumo Projects

Database Administration

MySql

Recovering / Changing Your MySQL Root Password

Quick Jump To:

MySql	Threads List - Search Forum
Moderated by: abukta	Subscribe to this Thread
Recovering / Changing Your MySQL Root Password

20 Jan 2006 14:25

# 1

abukta
super admin

profile

Join Date: 29 Mar 2005 21:03
Posts:

Recovering / Changing Your MySQL Root Password

Sometimes you may have to recover the MySQL root password because it was either forgotten or misplaced. The steps you need are:

1. Stop MySQL

[root@idoumo tmp]# service mysqld stop

Stopping MySQL: [ OK ]

[root@idoumo tmp]#

2. Start MySQL in Safe mode with the safe_mysqld command and tell it not to read the grant tables with all the MySQL database passwords.

[root@idoumo tmp]# safe_mysqld --skip-grant-tables &

[1] 4815

[root@idoumo tmp]# Starting mysqld daemon with databases from /var/lib/mysql

[root@idoumo tmp]#

3. Use the mysqladmin command to reset the root password. In this case, you are setting it to ack33nsaltf1sh.

[root@idoumo tmp]# mysqladmin -u root flush-privileges \\

password "ack33nsaltf1sh"

[root@idoumo tmp]#

4. Restart MySQL normally.

[root@idoumo tmp]# service mysqld restart

Stopping MySQL: 040517 09:39:38 mysqld ended

[ OK ]

Starting MySQL: [ OK ]

[1]+ Done safe_mysqld --skip-grant-tables

[root@idoumo tmp]#

The MySQL root user will now be able to manage MySQL using this new password.

message edited by abukta (20 Jan 2006 14:27)

<< Start < Prev 1 Next > End >>
Results 1 - 1 of 1

Help iDoumo

Help support "iDoumo" and free software by donating now!

Donate

Once

Monthly

Latest Events
There are no upcoming events currently scheduled. View Full Calendar

Project Calendar

August 2008

Su	Mo	Tu	We	Th	Fr	Sa
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30
31

Media Gallery
Last update: 27 Sep, 11:53 Workday random: PeopleSoft

top of page