If you are desperate, you can also start mysqld with --skip-grant-tables
option.
Then use mysql, update root password using the update statement that Jim
wrote about.
-Paul
On Mon, 2008-08-18 at 17:25 +0100, Andy Shellam wrote:
> FYI,
>
> I don't think this was sent to the list, forgive me if i
FYI,
I don't think this was sent to the list, forgive me if it was and I
didn't see it.
Andy
--
You probably don't have to reinstall it. If you never gave root a
password, just login as Andy says below and, when prompted for the
password, just press the ENTER key. Unless you gave root a
Alternatively you can try this if the box is unix/linux :
sudo mysqld_safe --skip-grant-tables --user=root &
mysql -u root
Change your root password
Restart mysql after this.
Cheers
Sharad
Andy Shellam wrote:
> Hi Andrew,
>
> I think he means re-install MySQL and provide a root password
Hi Andrew,
I think he means re-install MySQL and provide a root password (you
said when you originally installed it that you didn't give it a
password.)
After you've done this, try mysql from the command-line explicitly
telling it to use the user "root":
mysql --user=root --password
Th
How does one done this?
At 08:41 AM 8/17/2008, Sreekanth CHAVA wrote:
Hi Andrew
As per your Question , you can test with the below solution :-
Try to reconfigure MySQL by providing the root password and then
try to run the
administer GUI. This should solve the problem.
C
Hi Andrew
As per your Question , you can test with the below solution :-
Try to reconfigure MySQL by providing the root password and then
try to run the
administer GUI. This should solve the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney <[EMAIL PROTECTED]
