forgotten the MySQL root password

[Jack_Sparrow]

forgotten the MySQL root password

den kohomada recover karaganne MYSQL un-install karala install kalata wedak neee

​

http://www.cyberciti.biz/faq/mysql-change-root-password/
google eke mee tiyana recover karana widi karannat beee metanin ehata ethulata yanna beri nisa


den mokada karanne???

 

[lord88]

hmm

try 123

 

[Jack_Sparrow]

try 123

123 weda nee kollo
machan kalin demma pass eka mataka ne ban

 

[Mal Baba]

HIkz Moko Une
Reset Password

 

[Jack_Sparrow]

HIkz Moko Une
Reset Password

hungak kalin dapu pass ekak tiyanaw amataka ne machan RESET karaganna widiya tamai matath denaganna oni

 

[kosandpol]

hungak kalin dapu pass ekak tiyanaw amataka ne machan RESET karaganna widiya tamai matath denaganna oni

Read my Blog here at EK : http://www.elakiri.com/forum/blog.php?b=251

 

[Jack_Sparrow]

Read my Blog here at EK : http://www.elakiri.com/forum/blog.php?b=251

thanks mate

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
bt machan mee commands koheda gahanne, mama windows xp use karanne

 

[RuwinRTY]

uninstall karala registry eka delete karoth barida ?

 

[Jack_Sparrow]

uninstall karala registry eka delete karoth barida ?

be ban mama ehemat kala

 

[kosandpol]

thanks mate

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &
bt machan mee commands koheda gahanne, mama windows xp use karanne

D'uh! on the command line!
If you're on windows, stop the mysql service and from the command line run the second command.

 

[JAASBandara]

Machan oyage MySQL version eka dala naaaa.....Man hitanne MySQL 4.1 wenda atii...

1.) Add/Remove Programs gihin MySQL uninstall karanda.

2.) Dan "C:\ProgramFiles\MySQL 4.1\Data" folder ekata gihin oya hadapu database name walin tiyana folder tika wena tanakata copy karaganda. dan "MySQL 4.1" folder eka remove karanda. (Kalin configure karapu files uninstall karaddi remove wenne naa....api manually remove karanda one)

3.) Itapasse aye MySQL install karala server eka configure karanda

 

[kosandpol]

Machan oyage MySQL version eka dala naaaa.....Man hitanne MySQL 4.1 wenda atii...

1.) Add/Remove Programs gihin MySQL uninstall karanda.

2.) Dan C:\ProgramFiles gihin "MySQL 4.1" folder eka remove karanda. (Kalin configure karapu files uninstall karaddi remove wenne naa....api manually remove karanda one)

3.) Itapasse aye MySQL install karala server eka configure karanda

එතකොට මැකිල යන databases අයෙත් දෙන්නෙ ආණ්ඩුවෙන ද ?

 

[gudaya]

How to Reset a MySQL Password in 5 Easy Steps

1. Stop the mysqld daemon process.
2. Start the mysqld daemon process with the --skip-grant-tables option.
3. Start the
   
   mysql client with the -u
   
   root option.
4. Execute the UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
5. Execute the FLUSH PRIVILEGES; command.

 

[lord88]

umba mokakda use karapu language eka apllication eka haddanna

 

[Jack_Sparrow]

D'uh! on the command line!
If you're on windows, stop the mysql service and from the command line run the second command.

MYSQL command Line or cmd
MYSQL command Line eka etulata yanna beene

 

[JAASBandara]

එතකොට මැකිල යන databases අයෙත් දෙන්නෙ ආණ්ඩුවෙන ද ?

Hari Hari remove karanda kalin database tike copy ekak ganda......

thanks matak kalata.....eka amataka unaaa....onna waradda niwaradii kala

habai jack kiyala tiyanawa danatamat eyaa MySQL unistall kalata wadak unee naa kiyala....ekai mama kalin widihata damme

 

[lord88]

ok

umba application eka hadapu project eke connection srting eke user name password thiynawane ban monawada kale vb da

 

[kosandpol]

MYSQL command Line or cmd
MYSQL command Line eka etulata yanna beene

from cmd.
if you can post the contents of the bin folder of mysql I can give the exact commands for windows

 

[kosandpol]

umba application eka hadapu project eke connection srting eke user name password thiynawane ban monawada kale vb da

this is not the root password. It'll be the user and password for that database only.

 

[Jack_Sparrow]

from cmd.
if you can post the contents of the bin folder of mysql I can give the exact commands for windows

machan meeka mysqld.exe -u root --skip-grant-tables kalaaama mehema enawane