Dan,
A thousand times thanks for the fast reply, I just reset my password
with MySQL Administrator now, everything is back the way it was!
On a sidenote: I also saw this as the version "MySQL 5.0.17-max via
socket". The version 3 was through phpinfo(). My php install and
other MySQL do al
Kevin -
You can start up the MySQL server without password protection using the
--skip-grant-tables option. Note that will leave your server wide open,
so you may also want to use the --skip-networking option and access it
through the socket on the same machine.
Something like this I think:
Hi all,
I've been using MySQL for over a year now and I didn't install
anything special recently, yet I suddenly find myself locked out of
MySQL.
I'm using version 3.23.49 and I'm running Mac OS 10.4.6 fully up-to-
date. I normally connect using the root-user but this afternoon I
first
Hi
Did you remember to flush???
- Original Message -
From: "Adam Fortuno KOVICK" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: July 31, 2003 4:33 PM
Subject: ARGGH! - User password problems
> All,
>
> I've been attempting to assign a p
All,
I've been attempting to assign a password to a user with the following
statement:
UPDATE mysql.user SET password=PASSWORD('foo') WHERE user = 'acc_name';
I get the typical:
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
However, when the user attempts the lo
Lee,
Tuesday, April 02, 2002, 8:54:44 PM, you wrote:
LPR> I just installed MySQL 3.23.49 on NT and executed the following
LPR> commands:
LPR> UPDATE USER SET password=password("test1") WHERE host="localhost";
LPR> UPDATE USER SET password=password("test1") WHERE host="%";
LPR> Now, after do
Hi,
I just installed MySQL 3.23.49 on NT and executed the following
commands:
UPDATE USER SET password=password("test1") WHERE host="localhost";
UPDATE USER SET password=password("test1") WHERE host="%";
Now, after doing 'mysqladmin reload', I cannot connect...
> mysql -p
> Enter password:
Hi All,
I've done a fool thing and changed the root password to mysql server, and
evidently miss typed, because now it will not let me in. How can I get back
into mysql to change this?? Please help as this is a production server!!
Thanks,
Gary
Gary Wheeler wrote:
> I've done a fool thing and changed the root password to mysql server, and
> evidently miss typed, because now it will not let me in. How can I get back
> into mysql to change this?? Please help as this is a production server!!
See the standard documentation page at
htt
At 16:57 15/12/2001 -0500, Gary Wheeler wrote:
Hi,
shell> BINDIR/safe_mysqld --skip-grant-tables &
shell> BINDIR/mysql -u root mysql
Make sure you run mysqladmin flush-privileges or mysqladmin reload
afterward to tell the server to reload the grant tables.
Regards,
Miguel
>Hi All,
>
>I've done
ECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, February 11, 2001 9:59
Subject: RE: Password problems
> It looks like MySQL is working fine, phpMyAdmin just needs to know your
new
> password so that it can connect to the database. Just edit the
> "config.inc.php&q
--Original Message-
From: Eddie Rhodes [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 10, 2001 8:38 PM
To: [EMAIL PROTECTED]
Subject: Password problems
Hi all,
The resolution to my problem is probably simple for many of you.
However, I'm new to MySQL and php and am having difficult
Hi all,
The resolution to my problem is probably simple for many of you.
However, I'm new to MySQL and php and am having difficulties. However,
I'm ignorant, not stupid, and can follow directions.
My setup is as follow: I had My SQL, php4 (with Zend) and phpMyAdmin
installed on my Red Hat Linu
13 matches
Mail list logo
