Geekpedia Tutorials Home

Building a C# Chat Client and Server

Building a C# Chat Client and ServerA step by step tutorial teaching you how to create your own chat client and chat server easily in C#, for local networks or the Internet.

in C# Programming Tutorials

Getting Hard Drive Information

Getting Hard Drive InformationA C# tutorial showing you how to make use of WMI to extract information on disk drives, such as model, capacity, sectors and serial number.

in C# Programming Tutorials

UPS Shipping Calculator

UPS Shipping CalculatorThis tutorial will teach you how to calculate the shipping cost based on the weight, height, length and depth of the box, the distance and the UPS service type.

in PHP Programming Tutorials

Create Your Own Rich Text Editor

Create Your Own Rich Text EditorCreating a Rich Text Editor using JavaScript is easier to do than you might think, thanks to the support of modern browsers; this tutorial will walk you through it.

in JavaScript Programming Tutorials
Search
Tutorials
Programming Tutorials
IT Jobs
From CareerBuilder

How to reset your MySQL root password under Windows

On Saturday, September 2nd 2006 at 10:10 PM
By Andrew Pociu (View Profile)
*****   (Rated 4.7 with 77 votes)
Advertisement
More MySQL Resources
In case you forgot the root password for your MySQL database server running under Microsoft Windows, you can still access your database and even reset your password using the command prompt. However, first you should check your my.cnf file where your password is stored.

If you are using a new version of MySQL Server, such as 5.0, the methods here might not work for you, or slightly different actions may need to be applied.

1. Stop your MySQL server completely. This can be done by accessing the Services window inside Windows XP and Windows Server 2003, where you can stop the MySQL service.

2. Open your MS-DOS command prompt using "cmd" inside the Run window. Inside it navigate to your MySQL bin folder, such as C:\MySQL\bin using the cd command.

3. Execute the following command in the command prompt: mysqld.exe -u root --skip-grant-tables

4. Leave the current MS-DOS command prompt as it is, and open a new MS-DOS command prompt window.

5. Navigate to your MySQL bin folder, such as C:\MySQL\bin using the cd command.

6. Enter "mysql" and press enter.

7. You should now have the MySQL command prompt working. Type "use mysql;" so that we switch to the "mysql" database.

8. Execute the following command to update the password:

UPDATE user SET Password = PASSWORD('NEW_PASSWORD') WHERE User = 'root';

However, you can now run any SQL command that you wish.

After you are finished close the first command prompt and type "exit;" in the second command prompt windows to disconnect successfully. You can now start the MySQL service.

Please note that the 8 step process above can differ depending on the MySQL version you are using, how you configured your server, etc. However, many times you can still easily work around a problem that you experience in any of the steps.
Digg Digg It!     Del.icio.us Del.icio.us     Reddit Reddit     StumbleUpon StumbleIt     Newsvine Newsvine     Furl Furl     BlinkList BlinkList

Rate Rate this Knowledge Base article
Comment Current Comments
by vikram \' on Tuesday, February 13th 2007 at 05:28 AM

please give me some information about ms dos copy and paste other drive
quickly

by OldManRiver on Tuesday, March 6th 2007 at 11:37 PM

In some versions the mysqld.exe is replaced with mysqld-nt.exe.

Check to see which configuration you have!

by OldManRiver on Tuesday, March 6th 2007 at 11:51 PM

I was running WAMP and found that for this to work I had to do the following:

1. In the WAMP control panel "STOP' mysql before running the -skip-grant-tables command on either mysqld or mysqld-nt.

2. Run the rest of this reset procedure, then close all open mysql sessions and/or command line windows.

3. In the WAMP control run "Restart All Services"

by theneedy on Monday, April 16th 2007 at 10:05 AM

in step 6 i tried to run mysql and i got

ERROR 1045 (28000): Access denied for user \'ODBC\'@\'localhost\' (using password: NO)

several times

by mayamaya on Monday, June 4th 2007 at 03:01 AM

the second DOS page just doesnot exit. neither it quit nor exit works

by Vanessa on Monday, July 16th 2007 at 07:51 AM

This worked perfectly for me (platform Windows XP SP2)! Thanks so much Andrei for this useful article!

by dinesh on Thursday, July 26th 2007 at 03:51 AM

error 1067: The process terminated unexpetedly, while restarting mysql

by Ray on Sunday, December 2nd 2007 at 07:15 AM

Thank you soooo much!! I found many similiar articles, but this was the only one that worked prefectly, due to an excellent description. Thanks alot!!

by clive on Wednesday, December 5th 2007 at 05:48 AM

Process works perfectly thank you

by nimesh on Tuesday, January 29th 2008 at 01:42 PM

thanks a lot andrei...

keep up the good effort :)

by jap on Monday, March 3rd 2008 at 02:39 PM

If you get error 1067 when trying to restart, make sure the cmd prompts are closed and make sure windows task mgr does not have mysql running as a local user app.

by theder on Thursday, March 20th 2008 at 05:39 PM

thanks andrei for your info, worked for me!

by jackie on Friday, March 21st 2008 at 08:06 PM

Hello,

I just want to let you know that you told us just bullshit and C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld.exe -u root --skip-grant-tabl
es
'mysqld.exe' is not recognized as an internal or external command,
operable program or batch file.

by Ervie on Monday, March 24th 2008 at 12:43 PM

Thank you so much, Andrei.
Been figuring this out for a night and your posting just came out today.
It\'s really very helpful!

by Ervie on Monday, March 24th 2008 at 12:45 PM

Jackie, do you really not have the mysqld.exe under your C:\Program Files\MySQL\MySQL Server 5.0\bin ?
Do you have version 6.0, instead?
It might be resided in C:\Program Files\MySQL\MySQL Server 6.0\bin.

by Limberg on Monday, March 31st 2008 at 02:34 PM

ERROR 1045 (28000): Access denied for user\'ODBC\'@\ 'Local host\' (using password: NO)
Please how do I Log in tp my Database Query

by Mnaoj on Friday, April 11th 2008 at 08:26 AM

hi guys, i m trying to run this command:
Python manage.py sql
then, i m getting this error:
_mysql_exceptions.OperationalError: (1045, \"Access denied for user \'ODBC\'@\'local
host\' (using password: NO)\")

How, can i avoid thid error.

by eric on Saturday, April 19th 2008 at 11:55 AM

jackie, instead of getting obnoxious, you can see in the bin folder that the logical answer is to use mysqld-nt.exe. Andrei pointed out that the process may be different for newer versions.

by Gabe on Monday, April 21st 2008 at 12:00 AM

Worked perfectly fine thx dude u save me a lot of time

by subba on Tuesday, May 6th 2008 at 04:00 AM

use \'mysqld-nt.exe\' if ur using windows 2003 server

by hakem on Sunday, September 7th 2008 at 05:48 AM

Thank you very much. This is the only way it worked easy for me.

Other posts make life so complicated !

Thank you once again

by Louw on Thursday, September 25th 2008 at 07:36 AM

Thanks! This saved the day for me!

by Anil Shah on Thursday, October 9th 2008 at 06:40 PM

it worked for me,thanx alot

by migboy on Sunday, November 9th 2008 at 06:50 PM

using 5.0 when i get to
7. You should now have the MySQL command prompt working. Type "use mysql;" so that we switch to the "mysql" database.
the ''use'' command doesnt' work..so what next

by me8work on Monday, January 5th 2009 at 07:11 PM

Hello !!

My Problem is the same as the problem for migboy.

I cannot even see any response to migboys query yet !!

Please any information on wat to do when use command doesnt work for mysql server5.0.

I looked into the manual where it says "USE db_name" wud be the way to go !! Nothing WORKS,.,. Please HELP ........M STUCK !!

by Alongbar on Tuesday, January 6th 2009 at 10:45 PM

Thank for Guide.

by Alongbar on Tuesday, January 6th 2009 at 10:45 PM

Thank for Guide.

by ed on Wednesday, January 7th 2009 at 06:41 PM

This worked like a charm! Yes, there were small variations but easy to find and work with.

Thanks so much! This will be a classic solution.

by Alexandra on Friday, January 16th 2009 at 12:20 PM

This was great! I spent 'centuries' trying to find my.cnf, I didn't find it, and then I tried the next steps. It works with MySql 5.1., too.

by Christiaan on Sunday, January 18th 2009 at 02:04 PM

The original 8 step plan worked.
Much better than that sh*t advice you get on the sun website.
If you were my neighbour I'd buy you brandy.
After 5 hours... finally! Thanks.

by Christiaan on Sunday, January 18th 2009 at 02:05 PM

The original 8 step plan worked.
Much better than that sh*t advice you get on the sun website.
If you were my neighbour I'd buy you brandy.
After 5 hours... finally! Thanks.

by TracingGamers Community on Sunday, February 8th 2009 at 09:03 AM

U Know How I Can Get My Pass ID Back From :
SQL Server Management Studio Express!

by Kalimulla on Tuesday, March 3rd 2009 at 12:25 AM

In sql for running iReports when i click on new connection i asks me the Database Password as there is no password for Sql Server. I am getting error:

SQL problems: Access denied for user 'root'@'localhost' (using password: YES)
jdbc:mysql://localhost/mysql

also i gave IP ddress and tried out yet showning error:
SQL problems: null, message from server: "Host 'kalimulla' is not allowed to connect to this MySQL server"
jdbc:mysql://192.168.0.17/mysql

and at last i created passwrod fro root and then also it is coming error:

SQL problems: Access denied for user 'root'@'localhost' (using password: YES)
jdbc:mysql://localhost/mysql

by Kalimulla on Tuesday, March 3rd 2009 at 03:21 AM

In sql for running iReports when i click on new connection i asks me the Database Password as there is no password for Sql Server. I am getting error:

SQL problems: Access denied for user 'root'@'localhost' (using password: YES)
jdbc:mysql://localhost/mysql

also i gave IP ddress and tried out yet showning error:
SQL problems: null, message from server: "Host 'kalimulla' is not allowed to connect to this MySQL server"
jdbc:mysql://192.168.0.17/mysql

and at last i created passwrod fro root and then also it is coming error:

SQL problems: Access denied for user 'root'@'localhost' (using password: YES)
jdbc:mysql://localhost/mysql

by Kalimulla on Tuesday, March 3rd 2009 at 03:21 AM

In sql for running iReports when i click on new connection i asks me the Database Password as there is no password for Sql Server. I am getting error:

SQL problems: Access denied for user 'root'@'localhost' (using password: YES)
jdbc:mysql://localhost/mysql

also i gave IP ddress and tried out yet showning error:
SQL problems: null, message from server: "Host 'kalimulla' is not allowed to connect to this MySQL server"
jdbc:mysql://192.168.0.17/mysql

and at last i created passwrod fro root and then also it is coming error:

SQL problems: Access denied for user 'root'@'localhost' (using password: YES)
jdbc:mysql://localhost/mysql

by Kalimulla on Tuesday, March 3rd 2009 at 03:21 AM

In sql for running iReports when i click on new connection i asks me the Database Password as there is no password for Sql Server. I am getting error:

SQL problems: Access denied for user 'root'@'localhost' (using password: YES)
jdbc:mysql://localhost/mysql

also i gave IP ddress and tried out yet showning error:
SQL problems: null, message from server: "Host 'kalimulla' is not allowed to connect to this MySQL server"
jdbc:mysql://192.168.0.17/mysql

and at last i created passwrod fro root and then also it is coming error:

SQL problems: Access denied for user 'root'@'localhost' (using password: YES)
jdbc:mysql://localhost/mysql

by Ryan on Thursday, March 19th 2009 at 08:48 PM

I cant get the use command to work can someone help I need to get my dedicated host up and running plz help.

by TracingGunZ on Friday, March 20th 2009 at 06:54 AM

Hey, can any 1 helping me whit MSSQL Connecting...

If i go connect he says this (click link)
Picture :
http://img19.imageshack.us/img19/4204/error011001.png

Who can help me whit this problem ?
Any 1 ?
p.s. i searching full internet inc Google,Yahoo enz... but still there is nothing that i can find .

Thanx if u can help me ;P
MSN : RICKNO@LIVE.NL (ONLY ADD IF U KNOW TO FIX)

by lewis on Tuesday, April 21st 2009 at 12:47 PM

thank you, this works

by vusal on Wednesday, May 20th 2009 at 02:52 AM

thanks to whom (as i undersoot Andrei) wrote this useful information
i did and worked

i want to show time when i checked (to whom say that it is not useful)

20.05.2009

by Jeffrey on Thursday, May 21st 2009 at 08:24 AM

Thanks for the guide. Worked better than the guide in MySQL Reference Manual.

by Gopinath on Friday, May 22nd 2009 at 04:22 AM

Hi Andrei,

I struggled to solve this issue for more than 4 hrs losing my sleep. Finally, I got this and this worked perfectly.

Thanks for posting such a step by step guide!!

Will refer to your posts when I need related info.

Gopinath.

by emma on Monday, August 17th 2009 at 12:58 PM

thanks for the all for giving more and more supports

best of luck for all help full people

by emma on Monday, August 17th 2009 at 12:59 PM

thanks for the all for giving more and more supports

best of luck for all help full people

by Jim on Thursday, August 20th 2009 at 11:01 AM

Line 7 was the key step that was missing from all the other procedures I tried.

Thanx, after MANY hours, I'm reconnected to MySQL.

Jim

by Elzooi on Sunday, August 30th 2009 at 02:20 PM

You sir, are my hero.

by Prashant on Tuesday, September 1st 2009 at 11:16 PM

Thanks so much.. it really worked..

by Vlad - Redhot on Thursday, October 22nd 2009 at 09:08 PM

This work great for me! Thanks!

by saeed on Saturday, October 24th 2009 at 02:55 AM

It worked perfectly. Thank you a lot.

by mauro on Thursday, October 29th 2009 at 01:23 PM

Hi,

it all seems to have worked, but after step 3 the first command prompt was completely unresponsive.

And after completing step 8 the only way to exit mysqld was to use End Process in Windows Task Manager. Has anyone else encountered this problem?

Mauro

by Tuyen Nguyen on Friday, November 6th 2009 at 06:54 PM

You guys may want to try this tutorial, it works for me:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

by mui on Saturday, November 7th 2009 at 11:37 AM

For me, it works perfectly (windows xp 32, mysql5)

by Moogie1947 on Monday, November 23rd 2009 at 01:28 PM

I have the same problem as Mauro and am using a WAMP server.
I had set passwords in the priveleges section of PHPMYADMIN then it would not talk to me:-(

I turned on the console using --console after the command to see the error messages.

There was a repeating error message to the effect that something else was using InnoDB files

It then says shut down the program that is using the files.
Whatever that means. I shut down all the firewalls and virus software but it made no difference.

by Another Mauro on Thursday, November 26th 2009 at 09:41 PM

Thanks man, your article saved my homework :-) ... Thanks a lot

by amitesh on Thursday, December 10th 2009 at 09:07 AM

Thanks a lot dude :)

by Rishikeshan on Saturday, January 2nd 2010 at 02:57 AM

The best article in resetting password in mysql. others are waste shit idiot fools.

by annie on Tuesday, January 26th 2010 at 01:06 AM

thanks this worked for me!

by annie on Tuesday, January 26th 2010 at 01:13 AM

thanks this worked for me!

by NizamSys on Monday, March 1st 2010 at 05:09 PM

Nice article. Its help me! Thx alot Pociu

by Rajni on Wednesday, March 3rd 2010 at 10:16 AM

Its working well first time. I close my cmd properly but when I restart my computer then its not working!!! Please give me solution.

by Rajni on Wednesday, March 3rd 2010 at 10:16 AM

Its working well first time. I close my cmd properly but when I restart my computer then its not working!!! Please give me solution.

by Rajni on Wednesday, March 3rd 2010 at 10:16 AM

Its working well first time. I close my cmd properly but when I restart my computer then its not working!!! Please give me solution.

by lawrence karthauser on Saturday, March 20th 2010 at 01:58 PM

it looks as if this will work - at least the commands did. I did not close the dos mysqld before trying to restart the service and the i realised that i could stop the processes in task manager, now i can connect to the databases.

yours was the article that worked - you knew what to do.

Thanks

Lawrence

by Hristo Torbov on Sunday, March 21st 2010 at 11:02 AM

OK, I stopped my MySQL server and then when I go to MySQL/bin folder via MS-DOS and enter "mysql" I get this error:
Can't connect to MySQL server on 'localhost' (10061)

.. so WHAT the FUCK is GOING on HERE?

by madhushan on Wednesday, March 31st 2010 at 07:53 AM

I want to know, how to change the admin password of Mysql server in wamp server. And where is mysql datbase files are stored.
Thanks

by rerr on Saturday, April 3rd 2010 at 03:12 AM

Remove all datafiles. uninstall wamp. (this will erase all data!). stop instance. remove mysql directory. that's all, you can reinstall

by Richard on Thursday, April 8th 2010 at 02:19 AM

My XP Pro sp3 hangs with XAMPP on line 3 of your instructions....
3. Execute the following command in the command prompt: mysqld.exe -u root --skip-grant-tables

any help is always appreciated

by David on Friday, April 23rd 2010 at 10:29 AM

I am a true beginner with PHP

by madhavi on Thursday, May 27th 2010 at 01:06 AM

hi,thanking you for providing this information
it really helped me alot
once again thank you

by saygley on Saturday, June 5th 2010 at 09:36 AM

works like a gear. this is great! thank you so much.

by Faithless on Saturday, June 12th 2010 at 08:53 AM

Works perfecly thank you very much! read it carefully and you'll figure it out!

by PabloInNZ on Monday, July 12th 2010 at 11:33 PM

Thanks for that.
I couldnlt get it to work with the information on the MySQL Site, but this worked fine. The only problem I had was that MySQL wouldn't restart, but a reboot of the machine fixed it.
Using Windows XP SP3 and MySQL 5.1.11

by Hristo Torbov on Tuesday, July 13th 2010 at 04:17 AM

WAMP is so bugged BULL SH!T use EasyPHP it's so much more simple and flexible!

by PabloInNZ on Tuesday, July 13th 2010 at 05:09 AM

Well,EasyPHP wouldn't really help, seeing as how my client is running MySQL on Windows XP....

by andy on Thursday, July 29th 2010 at 04:24 PM

worked a treat. great stuff thanks

by andy on Thursday, July 29th 2010 at 04:24 PM

worked a treat. great stuff thanks

by Guest on Sunday, August 15th 2010 at 05:59 PM

My god tnx for this

by rcmz on Wednesday, August 18th 2010 at 09:30 PM

Well,i think it can bring you some help: http://password-genius.com/

by JohnBR on Wednesday, September 15th 2010 at 06:21 PM

Thank you! That saved my day!

by ashesh shah on Thursday, September 16th 2010 at 01:31 AM

For Windows Operating System,
1. Firstly, create a text file and name it as resetpassword.txt and you may save it to C drive.
2. Enter the following word to your text file.

1.
UPDATE mysql.user SET Password=PASSWORD('root') WHERE User='root';
2.
FLUSH PRIVILEGES;

3. Stop your MySQL services as step below.
Run -> services.msc -> MySQL -> Stop
4. Open Command Prompt(cmd) and run the command as below to start the MySQL services.

1.
C:\mysql\bin\mysqld.exe --init-file=C:\\resetpassword.txt

5. Delete the file named resetpassword.txt.

by Rishikeshan on Thursday, September 16th 2010 at 07:48 AM

MySQL sucks. Maybe postgresql?

by Antonio on Thursday, September 16th 2010 at 11:30 PM

Damn Andrew, this worked perfect. Thanks a lot.

by Neerou on Thursday, September 23rd 2010 at 02:50 AM

Thanks Andrew! Saved me hours of struggle!!!!

by Carol on Tuesday, September 28th 2010 at 01:20 PM

Thank you, Thank you, Thank you!! You saved me many hours of headaches! Best explaination out there for windows....trust me! :)

by Laurie on Thursday, November 25th 2010 at 02:38 PM

Thank You So Much I wish I had found this discription first...
I have been beating my head against this on and off for quite a while using different methods.
The Absolute Best explanation I have tried 3 or 4 different answers at different times and using slightly different syntax, nothing worked. This one Worked First Try!

by LM on Tuesday, November 30th 2010 at 06:01 AM

Tried stuffs which said they were easy but didn't work.

Tried this which looked a little long but worked!

Really glad and thank you so much! Bookmarking this!

by Ravindra on Thursday, March 10th 2011 at 04:34 PM

it worked for me,
when i did
I was running WAMP and found that for this to work I had to do the following:

1. In the WAMP control panel "STOP' mysql before running the -skip-grant-tables command on either mysqld or mysqld-nt.

2. Run the rest of this reset procedure, then close all open mysql sessions and/or command line windows.

3. In the WAMP control run "Restart All Services"

by paullstanley on Tuesday, June 21st 2011 at 11:10 AM

This article is incomplete and could lock people out of their own phpMyAdmin panel as root user. If this is the case check out my tutorial here: http://www.itutorblog.com/2011/06/how-to-change-root-password-on-wamp/

by Paul on Thursday, June 30th 2011 at 02:36 PM

Thanks for an excellent tutorial. Everything worked great for me until I tried Step 8. After I typed in the information for step 8 I got the following error message: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

any help would be appreciated

thanks in advance

by paullstanley on Thursday, June 30th 2011 at 04:01 PM

You have to edit the config.inc file. The second part of this tutorial: http://www.itutorblog.com/2011/06/how-to-change-root-password-on-wamp/ will explain where the config.inc file is and how to edit it. Good Luck!

by Jeffrey on Thursday, June 30th 2011 at 04:04 PM

How do I unsubscribe from the future replies?

by Chieu on Friday, July 1st 2011 at 09:16 PM

Thanks so much! It really works.

by Jose on Tuesday, July 12th 2011 at 12:01 PM

Hey men thanks,

Definetely you are the dolphin of mysql

by Jose on Tuesday, July 12th 2011 at 12:02 PM

Hey men thanks,

Definetely you are the dolphin of mysql

by Anish Ghosh on Saturday, September 3rd 2011 at 09:13 AM

hi
i've installed mysql-essential 5.1.33-win 32 on my PC and when i try to run the program
it asks for a password!!!
pls give me suggestions as i've not put up any password during the setup!!!!!!!

by vijay on Tuesday, September 20th 2011 at 06:18 AM

I am getting
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
when execute mysql

by Jaffar on Thursday, October 20th 2011 at 05:34 AM

Thanks its working...
but in update command
update mysql.user .......

by Sulaiman on Tuesday, November 1st 2011 at 06:42 AM

It was a great help.. no problem it worked like nice. Great Thanks for the help.

by free online dating on Sunday, November 20th 2011 at 06:35 AM

Time of one hour an hour later. Wen Qi Yue Ting and Xuenv found the body appeared to change, he has been practicing the whole day. And now has gone a full seven days time

by abhimanyu on Wednesday, November 30th 2011 at 03:39 AM

thanks a lot!! amazing article.

by link building services on Saturday, December 10th 2011 at 08:34 AM

I got he thing for getting the The height of the content area of a browser(ie viewport), but how do i get the height of the entire browser in ie8 including menubar,toolbar etc.For browser's other than ie8 this one works but for ie8 this one do not works. and I introduce your website perfect for my needs. It contains wonderful and helpful posts. I mortal listing most of them and got a lot from them. To me, you are doing the eager set. Fuddle on this. ingest at locating In the end, I would same to give you for making given a very website. Or where I could also gain several of my ranches for marketing substance for you all budy who come up here

by Saim on Wednesday, January 18th 2012 at 02:14 AM

Great Post. Worked flawlessly.

by manu dev on Friday, January 27th 2012 at 12:38 PM

Thanx sir
simply excellent

by Casper on Saturday, January 28th 2012 at 09:48 AM

Once you have recreated the problem and captured these steps, you can save them to a file and send it to your support person, who can then open it up and view

by Rice Crispy Treats on Sunday, January 29th 2012 at 03:58 PM

I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts.

by casino on Saturday, February 4th 2012 at 06:48 AM

I need to say that you are doing a fantastic job. Please keep up the great work.

by ForeclosureHelp on Saturday, February 4th 2012 at 08:54 PM

Informative and interesting which we share with you so i think so it is very useful and knowledgeable. I would like to thank you for the efforts. <a href="http://www.grant-applications.org">Grant Applications

by Fitness Produkte und Bodybuilding Produkte zur Sportnahrung für Bodybuilding und Fitness on Tuesday, February 14th 2012 at 08:14 AM

I have really enjoyed reading your blog posts.

by Janet Ward on Tuesday, February 14th 2012 at 11:36 AM

I followed your 8 steps without any problems.
However, on the pages concerned I am syill getting the following message:
Access denied for user 'xyz_4_r'@'11.11.11.11' (using password: YES)

Can you advise?

by Janet Ward on Tuesday, February 14th 2012 at 11:36 AM

I followed your 8 steps without any problems.
However, on the pages concerned I am syill getting the following message:
Access denied for user 'xyz_4_r'@'11.11.11.11' (using password: YES)

Can you advise?

by counter strike 1.6 download on Thursday, February 16th 2012 at 02:22 PM

You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand.

by ram on Tuesday, February 21st 2012 at 01:10 AM

Thanks dudeeeeeeeee.. it worked

by free dating on Saturday, March 17th 2012 at 12:07 AM

Nice. This was exactly what I needed, clear, precise, and practical. Perfect!

by free dating on Saturday, March 17th 2012 at 12:12 AM

I forgot. I wanted to point out that step 8 above was a great heads up for me - thanks!

by Offshore Company In UAE on Saturday, March 17th 2012 at 03:11 AM

Offshore Company In UAE.
It was fun reading it. Keep going in the good work.

by icomfort mattress vs tempurpedic on Friday, March 23rd 2012 at 12:42 AM

They are working in all kind of project servers , Microsoft EPM , Microsot programs and Microsoft EPM
and Microsoft project 2010 , project server , project server 2010 and many more.
I hope if yo need any thing then you must contact them. Thanks

by Invoice Template Free on Sunday, April 8th 2012 at 04:11 PM

Security issues can occur anywhere, so this should come as no surprise to all the people using the operating systems you brought to discussion up here. The thing is, I choose wisely every app that I want to download, every tool, every invoice template, by checking some general info on them. Sometimes you can get to see how reliable they are in terms of security just by reading some reviews about them first.

by private cloud on Sunday, April 8th 2012 at 04:16 PM

In any review I read about operating systems, with my professional perks on MySQL, people use to show more trust to higher versions when it comes to security aspects. Some people I worked with, though, believe that the recent MySQL changes bring further advantages to database composition and structure, but the older versions were highly more reliable on security.

by Tagesgeld Vergleich on Thursday, April 12th 2012 at 01:54 AM

Passwords should be changed from time to time. This can increase computer security and of the data stored on it.

by remedios caseros hemorroides on Saturday, April 28th 2012 at 12:17 AM

you can still access your database and even reset your password using the command prompt.

by latex mattresses on Tuesday, May 1st 2012 at 11:53 AM

you can still access your database and even reset your password using the command prompt.This can increase computer security and of the data stored on it.

by Granny Pussy on Tuesday, May 29th 2012 at 06:51 PM

nice one i like it very much please keep posting thank you .

by Hugo on Thursday, May 31st 2012 at 06:16 AM

Thanks a lot, it works!

by www.loanforu.co.uk on Thursday, June 28th 2012 at 09:50 AM

The thing is, I choose wisely every app that I want to download, every tool, every invoice template <a href="http://www.loanforu.co.uk">www.loanforu.co.uk</a>

by Kade on Tuesday, July 10th 2012 at 08:14 PM

Thank you so much!

by james on Tuesday, August 7th 2012 at 02:52 PM

just an amend :
this works for a default installation. If you have customized your installation : a different db directory or/and my.ini > it fails.

i tried to use the initial command mysqld -u root --defaults-file=.. --skip-grant-tables but it doesnt work for me.

So.. using the original solution then copying the mysql db into my customized folder.

comments welcome

james

by james on Tuesday, August 7th 2012 at 02:52 PM

just an amend :
this works for a default installation. If you have customized your installation : a different db directory or/and my.ini > it fails.

i tried to use the initial command mysqld -u root --defaults-file=.. --skip-grant-tables but it doesnt work for me.

So.. using the original solution then copying the mysql db into my customized folder.

comments welcome

james

by mari on Tuesday, September 11th 2012 at 11:34 AM

Thanks a lot. Your post has been very precious to me.

by mari on Tuesday, September 11th 2012 at 11:34 AM

Thanks a lot. Your post has been very precious to me.

by mari on Tuesday, September 11th 2012 at 11:34 AM

Thanks a lot. Your post has been very precious to me.

by mari on Tuesday, September 11th 2012 at 11:35 AM

Thanks a lot. Your post has been very precious to me.

by mari on Tuesday, September 11th 2012 at 11:35 AM

Thanks a lot. Your post has been very precious to me.

by car insurance online on Tuesday, September 25th 2012 at 08:07 AM

Your post has been very precious to me.

by Saiyed Jahangir Bakhtawar on Friday, October 19th 2012 at 08:58 AM

just wow buddy

very nice and supportive share, it saved plenty of my time :)

thanks again

by Saiyed Jahangir Bakhtawar on Friday, October 19th 2012 at 08:58 AM

just wow buddy

very nice and supportive share, it saved plenty of my time :)

thanks again

by free dating sites on Wednesday, October 31st 2012 at 04:10 AM

This worked perfectly for me (platform Windows XP SP2)! Thanks so much Andrei for this useful article!

by free dating sites on Wednesday, October 31st 2012 at 04:12 AM

This worked perfectly for me (platform Windows XP SP2)! Thanks so much Andrei for this useful article!

by water storage bladders on Thursday, November 1st 2012 at 05:36 AM

perfectly for me (platform Windows XP SP2)! Thanks so much Andrei for this useful article!

by Priyadarshan on Friday, November 9th 2012 at 12:10 AM

Thanks worked perfectly for me.

by Priyadarshan on Friday, November 9th 2012 at 12:10 AM

Thanks worked perfectly for me.

by Adnan on Monday, November 26th 2012 at 02:15 PM

Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

by Adnan on Monday, November 26th 2012 at 02:15 PM

Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

by Adnan on Monday, November 26th 2012 at 02:15 PM

Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

by Adnan on Monday, November 26th 2012 at 02:15 PM

Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

by Wallace on Wednesday, December 12th 2012 at 03:22 PM

Great solution,

Work very nice for me.

Thanks

by Wallace on Wednesday, December 12th 2012 at 03:22 PM

Great solution,

Work very nice for me.

Thanks

by Sree Bhuvan on Wednesday, January 16th 2013 at 02:02 AM

Works only in some systems.....

by Sree Bhuvan on Wednesday, January 16th 2013 at 02:02 AM

Works only in some systems.....

by Sree Bhuvan on Wednesday, January 16th 2013 at 02:02 AM

Works only in some systems.....

by Sree Bhuvan on Wednesday, January 16th 2013 at 02:02 AM

Works only in some systems.....

by Sree Bhuvan on Wednesday, January 16th 2013 at 02:02 AM

Works only in some systems.....

by Interactive Response System on Saturday, February 2nd 2013 at 02:58 AM

Hiya, I am really glad I've found this info. Today bloggers publish just about gossip and this is really frustrating.

by Interactive Response System on Saturday, February 2nd 2013 at 02:58 AM

Hiya, I am really glad I've found this info. Today bloggers publish just about gossip and this is really frustrating.

by sandeep on Thursday, February 14th 2013 at 12:20 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:20 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:20 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:20 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:20 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:20 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:21 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:22 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:22 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:22 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:22 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:22 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:23 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:23 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:23 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:23 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:23 AM

this is perfect and eassy solution Thanks.........

by sandeep on Thursday, February 14th 2013 at 12:23 AM

this is perfect and eassy solution Thanks.........

by Powercom Response Keypad on Monday, February 25th 2013 at 10:23 PM

I fully support all efforts to conserve, reuse and recycle – and it should be something that the whole nation should be doing – NOW!

by The Body Project on Thursday, April 11th 2013 at 09:03 AM


by The Body Project on Thursday, April 11th 2013 at 09:03 AM


by qwerty on Monday, May 6th 2013 at 08:36 AM

After executing update with new password as described here, I get result message: 0 rows affected.
And after I close the server, command line client still doesn't accept new password.
Anybody have any clue?

by Power Click on Friday, June 28th 2013 at 12:06 PM

The post is written in very a good manner and it entails many useful information for me. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post.

by MOB on Thursday, August 1st 2013 at 09:13 AM

thank you very much

by MOB on Thursday, August 1st 2013 at 09:13 AM

thank you very much

by MOB on Thursday, August 1st 2013 at 09:13 AM

thank you very much

by MOB on Thursday, August 1st 2013 at 09:13 AM

thank you very much

by MOB on Thursday, August 1st 2013 at 09:13 AM

thank you very much

by MOB on Thursday, August 1st 2013 at 09:13 AM

thank you very much

by MOB on Thursday, August 1st 2013 at 09:13 AM

thank you very much

by MOB on Thursday, August 1st 2013 at 09:13 AM

thank you very much

by audience response software on Thursday, August 29th 2013 at 02:25 AM

I am unable to quite see it through your eyes in all my honesty. maybe it is because i am very new in this field but I will keep reading and shoot an email when I’ve one or two doubts if you do not have anything agains this?


Comment Comment on this Knowledge Base article
Name: Email:
Message:
Knowledge Base Related Knowledge Base Articles
There are no related KB articles.

Comment Related Source Code
There is no related code.

Comment Related Tutorials
There are no related tutorials.

Jobs MySQL Job Search
My skills include:

Enter a City:

Select a State:


Advanced Search >>
Ads

From the creators of Geekpedia, a revolutionary new coupon website!

BargainEZ has coupons codes, printable coupons, bargains and it is the leading source of Passbook coupons for iPhone and iPod touch devices.

Coupons
Discover Geekpedia
Other Resources