On Fri, 22 Apr 2005 22:44:44 +0300
Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
> Make a bug or feature report at http://bugs.mysql.com.
Already did - 10098 - it was recently closed, guess it was already
fixed in 5.0.5.
Josh
--
MySQL General Mailing List
For list archives: http:
Hello.
Make a bug or feature report at http://bugs.mysql.com.
Josh Trutwin <[EMAIL PROTECTED]> wrote:
> Would it be possible to add:
>
> ENGINE=MyISAM
>
> To all the CREATE TABLE statements in the mysql_fix_privilege_tables
> script? The server (tes
Would it be possible to add:
ENGINE=MyISAM
To all the CREATE TABLE statements in the mysql_fix_privilege_tables
script? The server (tested with 5.0.3 and 5.0.4) crashes when
creating/altering these tables if the following is in /etc/my.cnf:
default-table-type=innodb
I had to drop all the
Steve,
Below is output from the mysql_fix_privilege_tables script:
"You can safely ignore all 'Duplicate column' and 'Unknown column' errors
because these just mean that your tables are already up to date."
I would not worry about the "Duplicate Key" erro
When I run mysql_fix_privilege_tables it tells me to ignore a lot of
errors. But it doesn't tell me about this error:
ERROR 1061 at line 5: Duplicate key name 'Grantor'
Can I ignore this? What is it from?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://
On Sat, Oct 02, 2004 at 08:25:49PM -0500, Paul DuBois wrote:
> At 16:31 -0600 10/2/04, "Dave Shariff Yadallee - System
> Administrator a.k.a. The Root wrote:
> >New error WITH password implemented:
>
> Apparently the ownership of the mysql database and/or the files in
> it is not set such that t
At 16:31 -0600 10/2/04, "Dave Shariff Yadallee - System
Administrator a.k.a. The Root wrote:
New error WITH password implemented:
Apparently the ownership of the mysql database and/or the files in
it is not set such that the files are accessible to the Unix account
that you're using to run mysqld
New error WITH password implemented:
Script started on Sat Oct 2 16:28:59 2004
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the
I have upgraded MySQL from version 3.32 to 4.0 and am trying to upgrade
the privilege tables by running the subject script.
Regardless of what I set in the "bindir=" line of the script file I get
errors from lines 100, 115, 132, and others that either %bindir%/mysql:
No such file or directory or %
I get an error when trying to reset password.
I start the db using:
mysqld_safe --skip-grant-tables &
and reset the pwd using the mysqladmin command...
below is the error message.
mysqladmin: unable to change password; error: 'Can't find any matching row in the user
table'
thanks,
--
MySQL Ge
Rusma Mulyadi <[EMAIL PROTECTED]> wrote:
> While trying to fix some problems with the user access privileges on
> mysql4.0 alpha, I run the mysql_fix_privilege_tables script.
> http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html
>
> As the result, I can't
While trying to fix some problems with the user access privileges on
mysql4.0 alpha, I run the mysql_fix_privilege_tables script.
http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html
As the result, I can't get to the database, even using the root login.
I tried to recover
OTECTED]>
Sent: Friday, November 21, 2003 19:42
Subject: Re: mysql_fix_privilege_tables script
> At 10:18 -0200 11/21/03, Fernando Gomes Bernardino wrote:
> > > At 10:00 -0200 11/19/03, Fernando Gomes Bernardino wrote:
> >> >Hi eveybody,
> >> >
> >&g
At 10:18 -0200 11/21/03, Fernando Gomes Bernardino wrote:
> At 10:00 -0200 11/19/03, Fernando Gomes Bernardino wrote:
>Hi eveybody,
>
>The mysql_fix_privilege tables can be undone? I have already
>re-install mysql server and nothing
Why do you want to undo it?
You can undo it by restori
At 10:00 -0200 11/19/03, Fernando Gomes Bernardino wrote:
Hi eveybody,
The mysql_fix_privilege tables can be undone? I have already
re-install mysql server and nothing
Why do you want to undo it?
You can undo it by restoring the grant tables from your most recent
backup. But without knowing
"Fernando Gomes Bernardino" <[EMAIL PROTECTED]> wrote:
>
> The mysql_fix_privilege tables can be undone? I have already re-install mysql server
> and nothing
>
Why do you want to do it?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
Hi eveybody,
The mysql_fix_privilege tables can be undone? I have already re-install mysql server
and nothing
Thanks a lot.
Fernando Bernardino
>Description:
When I start up mysqld (4.1.0-alpha), I get the message in the
error log:
mysql.user table is not updated to new password format: Disabling new password
usage until mysql_fix_privilege_tables is run
I *HAVE* run mysql_fix_privilege_tables. At le
-"
echo $root_password
echo "--"
Then if you try
sh mysql_fix_privilege_tables -p somepassword
Guess what you get...
--
-p somepassword
--
So i
At 10:50 -0500 11/28/02, Gary Huntress wrote:
I have upgraded from 3.23 to 4.0 and I have read over
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Up
grading-from-3.23. I have not yet run mysql_fix_privilege_tables yet and I
really want to since I intend to implement
I have upgraded from 3.23 to 4.0 and I have read over
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Up
grading-from-3.23. I have not yet run mysql_fix_privilege_tables yet and I
really want to since I intend to implement query quotas.
Since this is a production
DANIEL,
Monday, September 23, 2002, 10:43:15 PM, you wrote:
DG> I downloaded MySQL 4.0.3beta on my XP system. I didn't find
DG> mysql_fix_privilege_tables after installing. Am I suppose to pull it
DG> from the unix download and do by hand?
There is no mysql_fix_privilege_tables
22 matches
Mail list logo
