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
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
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 all
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
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 password to a user with the following
statement
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 doing
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: *
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 a
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
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
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
es [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 difficulties. However,
I'm ignorant, not stupid, and
MAIL 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" file in the phpMyAdmin directory.
Find the
13 matches
Mail list logo