MySQL Forums
Forum List  »  Install & Repo

Step-by-step solution
Posted by: tom tom
Date: November 02, 2005 07:38AM

Ok, 4get about MyAdmin. Here's a simple solution for this bloody problem:
Say, you have created a database and its prviligese:
password: password
your username: username
and host: localhost

1)
Click on start
2)
Programs
3)
MySQL---MySQL server
4)
Command line
5)
Log in with your root password (in my case: tom)
6)
type this:
SET PASSWORD FOR username@localhost = OLD_PASSWORD('password');

(obviously use your details that you had set up as PRIVILEGES, and yes!, you simply rewrite the original password see step 0 above, wraped in the function OLD_PASSWORD()).
7)
try PHP connecting script
8)
It works!!!!
9)
If not
10)
close MySQL
11)
reopen it
12)
Retry with your PHP script.
13)
WORKS!!!
===============================
Someone asked there how to set this up so you don't have to be repeating this procedure each time u want to connect to MySQL. You will not have to! It is enough to do this once.
If it still doesn't work, mail me on tom26pr@yahoo.com

Later.


Thank you folks around for the HINTS!!! I was about to bang the hell out of my walls using my head!!!

Options: ReplyQuote


Subject
Written By
Posted
December 31, 2005 12:02AM
December 31, 2005 02:28AM
March 29, 2006 03:12AM
March 24, 2007 02:58PM
January 03, 2006 07:48AM
March 16, 2006 10:03AM
Step-by-step solution
November 02, 2005 07:38AM
January 16, 2006 03:46PM
July 24, 2006 07:40AM
March 28, 2006 11:18PM
August 23, 2006 01:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.