Thanks for the tips, all. Looks like we've got it restored
via --skip-grant-tables and restoring some missing user rows
(which caused me not to be able to see DBs in 'show databases').
I was also confused about being able to load an empty string ''
into the non-null
Aug 26, 2009 at 2:33 AM, Joe wrote:
> I'm trying to get back to an earlier state where we started
> mysqld withOUT --skip-grant-tables but the root user had no
> password. Yes, insecure, but we're in restoration mode here.
>
> How do I reset/revert the root password to no pas
where we started
> mysqld withOUT --skip-grant-tables but the root user had no
> password. Yes, insecure, but we're in restoration mode here.
>
> How do I reset/revert the root password to no password without
> running with --skip-grant-tables?
>
> Thanks in advance.
>
&g
I'm trying to get back to an earlier state where we started
mysqld withOUT --skip-grant-tables but the root user had no
password. Yes, insecure, but we're in restoration mode here.
How do I reset/revert the root password to no password without
running with --skip-grant-tables?
ev identified by 'pass';
Query OK, 0 rows affected (0.00 sec)
mysql> Bye
server312# mysql -udev -ppass
ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password:
YES)
2
mysql> use authdaemon;
Database changed
mysql> show tables;
Empty set (0.02
-ppass
ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password:
YES)
2
mysql> use authdaemon;
Database changed
mysql> show tables;
Empty set (0.02 sec)
Is authdaemon the database that has the grant tables? What gives? How do I add
users that I ca
Michael Stassen wrote:
Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as
per the instructions in the manual.
My
Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as per
the instructions in the manual.
My problem is when I issue the
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as per
the instructions in the manual.
My problem is when I issue the command
./mysqladmin
An earlier versions of 4.1.12 rmps had some problems, I saw this in some
messages in list. But this could be caused by other reasons. SELinux for
example. Are you able to create grant tables running mysql_install_db
manually?
"Laser, Mary" <[EMAIL PROTECTED]> wrote
>Description:
rpm install of MySQL-server-standard-4.1.12-0.rhel4.x86_64.rpm on RHEL4
does
not create the MySQL grant tables.
>How-To-Repeat:
install with rpm -ivh MySQL-server-standard-4.1.12-0.rhel4.x86_64.rpm on
x86-64 RHEL4 system. Post installation attempts to start mysqld but
fails
off my other servers and I copied the websites and db's
> > to this new server. (old server was mysql 3). After that the mysql
> > server didn't startup anymore. I then chown'ed the data dir to
> > mysql:mysql. After that I was able to start the server with
> &
7;s
> to this new server. (old server was mysql 3). After that the mysql
> server didn't startup anymore. I then chown'ed the data dir to
> mysql:mysql. After that I was able to start the server with
> "--skip-grant-tables &". But it didn't start with ou
s new server. (old server was mysql
3). After that the mysql server didn't startup anymore. I then chown'ed the
data dir to mysql:mysql. After that I was able to start the server with
"--skip-grant-tables &". But it didn't start with out the --skip-grant-tabl
[EMAIL PROTECTED] wrote:
> I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is
> this: after I run the script to upgrade the grant tables to support the new
> privilgeges, can I then revert back to 3.23.58 seamlessly or will I need to readjust
> the
ric
>
>
>
> On Fri, 3 Sep 2004 09:43:28 -0700 (GMT-07:00), [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> > Hi there,
> >
> > I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is
> > this: after I run the script to u
everybody know. :)
-Eric
On Fri, 3 Sep 2004 09:43:28 -0700 (GMT-07:00), [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is
> this: after I run the script to upgrade the grant tables
Hi there,
I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is
this: after I run the script to upgrade the grant tables to support the new
privilgeges, can I then revert back to 3.23.58 seamlessly or will I need to readjust
the grant tables. Thanks in advance
On Wednesday, May 5, 2004, at 11:48 US/Pacific, Atle wrote:
What versions are you seeing this on? We've seen it exclusively on
3.23.58, with or without LinuxThreads enabled.
Various versions of 4.0.xx.
We don't run 3.23.xx much of anywhere anymore.
Jeremy
--
MySQL General Mailing List
For list
L PROTECTED]
> > Subject: Re: mysqld too busy to check its grant tables?
> >
> > On Mon, Apr 26, 2004 at 01:27:08PM -0700, MySQL wrote:
> > >
> > > On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
> > >
> > > > > > Yeah, we've been seeing th
We just had another machine that this weird bug introduced itself onto.
However, I just noticed something interesting; they're both running
mysql-3.23.58. Most of our production servers are 3.23.57 or below. Also,
there was a specific change to 3.23.58 dealing with password handling:
"Fixed buffe
Sent: Monday, April 26, 2004 4:21 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'MySQL'
> Subject: Re: mysqld too busy to check its grant tables?
>
> On Mon, Apr 26, 2004 at 04:11:37PM -0500, Donny Simonton wrote:
> > We have tried the same thing, flush hosts and
On Mon, Apr 26, 2004 at 04:11:37PM -0500, Donny Simonton wrote:
> We have tried the same thing, flush hosts and flush privileges did nothing.
> Refresh reload did nothing. Once the load went down the problem normally
> went away. We have tried shutting down mysql and starting it back up, that
> h
age-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 26, 2004 3:49 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'MySQL'
> Subject: Re: mysqld too busy to check its grant tables?
>
> On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote
On Mon, Apr 26, 2004 at 01:56:22PM -0700, Atle wrote:
>
> On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
>
> > On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote:
> > > Jeremy,
> > >
> > > We have also seen the problem on linux a while back; we haven't had the
> > > problem lately though.
On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
> On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote:
> > Jeremy,
> >
> > We have also seen the problem on linux a while back; we haven't had the
> > problem lately though.
>
> In our case, we've found that neither FLUSH HOSTS or FLUSH PRIVIE
On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote:
> Jeremy,
>
> We have also seen the problem on linux a while back; we haven't had the
> problem lately though.
In our case, we've found that neither FLUSH HOSTS or FLUSH PRIVIELGES
have any effect.
Was that the case for you folks as
Re: mysqld too busy to check its grant tables?
>
> On Mon, Apr 26, 2004 at 01:27:08PM -0700, MySQL wrote:
> >
> > On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
> >
> > > > > Yeah, we've been seeing this bug a bit too. I'm trying to isolate
> it
&
On Mon, Apr 26, 2004 at 01:27:08PM -0700, MySQL wrote:
>
> On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
>
> > > > Yeah, we've been seeing this bug a bit too. I'm trying to isolate it
> > > > and figure out if it's a FreeBSD related problem or something more
> > > > MySQL specific.
> > > >
> > > >
On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
> > > Yeah, we've been seeing this bug a bit too. I'm trying to isolate it
> > > and figure out if it's a FreeBSD related problem or something more
> > > MySQL specific.
> > >
> > > Are you using FreeBSD's native threads or LinuxThreads?
> >
> > FreeBSD
On Mon, Apr 26, 2004 at 12:21:47PM -0700, MySQL wrote:
>
> On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
>
> > On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote:
> > >
> > > Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been
> > > a daily occurrence that mysqld gets so bu
On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
> On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote:
> >
> > Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been
> > a daily occurrence that mysqld gets so busy that it's unable to authorize
> > connections properly. Our monito
On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote:
>
> Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been
> a daily occurrence that mysqld gets so busy that it's unable to authorize
> connections properly. Our monitoring system will report something like
> this: "Access
Saturday, March 13, 2004 10:37 AM
> To: Chris Sanchez; [EMAIL PROTECTED]
> Subject: Re: mysql error grant tables, help
>
>
>
> Hi!
>
> try to look at your my.cnf you haven't config it correctly!
>
>
> At 05:
-Original Message-
From: Victor Medina [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 13, 2004 10:37 AM
To: Chris Sanchez; [EMAIL PROTECTED]
Subject: Re: mysql error grant tables, help
Hi!
try to look at your my.cnf you haven't config it correctly!
At 05:54 p.m. 12/03/2004, Chris Sa
Hi!
try to look at your my.cnf you haven't config it correctly!
At 05:54 p.m. 12/03/2004, Chris Sanchez wrote:
get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant
and got the same thing. how do i fix?
mysql-standard-4.0.18-sun-solaris2.8-sparc binary on SunOS ipdev1 5.8
G
ng value '@MYSQL_TCP_PORT@' to 'port'
Installation of grant tables failed!
Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
You can use the command line tool
./bin/mysql to connect to the mysql
data
hi,
what's about http://bugs.mysql.com/bug.php?id=2915 [Bug: Installation of
Grant Tables failed!] ??
I have the same problem, how it described in this bug report. but nobody
could say me if this is a bug or merely a mistake on my part.
I would be really great if anybody could answer, beca
hi,
I have the same problem with executing mysql_install_db in mysql 4.1 after
compiling it on debian 3.0, lust like Bug #2915 installation of grant tables
failed!
after sucessfully configure (./configure --prefix=/usr/local/mysql
--with-innodb) & make & make install and e
On 8 Feb 2004, at 1:33, Marty Ray wrote:
I am new to mysql and I am having trouble getting started. I am using
a Macintosh G5 running OS 10.3.2. I got mysql installed and it would
run, however when I tried to create a database, I got an error saying
permission denied. I tried running the script
I am new to mysql and I am having trouble getting started. I am using a
Macintosh G5 running OS 10.3.2. I got mysql installed and it would run,
however when I tried to create a database, I got an error saying
permission denied. I tried running the scripts/install_mysql_db, and I
had to change p
m: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "Scott Haneda" <[EMAIL PROTECTED]>; "MySql" <[EMAIL PROTECTED]>
Sent: Monday, January 12, 2004 2:43 PM
Subject: Re: New grant tables
> Check the User `table` of the `mysql` database
> If
: Sunday, January 04, 2004 03:37
Subject: New grant tables
> I just updated from 3.x to 4.x. I moved my data files from one server to
> another. Srated mysql, and ran the permissions fixer script, which seemed
> to have worked just fine. However, I am not sure what it changed, how can
I
I just updated from 3.x to 4.x. I moved my data files from one server to
another. Srated mysql, and ran the permissions fixer script, which seemed
to have worked just fine. However, I am not sure what it changed, how can I
be sure that it did in fact update the tables?
--
--
The mysql_install_db script shipped with 4.1.1-alpha seems to leave
the mysql/* (user,host,etc.) tables owned root.root on my Debian
system; this makes mysqld fail to start after the grant tables are
installed.
It looks like this is because mysql_install_db calls mysqld with
--bootstrap and
At 18:06 -0700 9/29/03, Rusty Wright wrote:
Is it possible, desirable, etc. to convert the mysql grant, system,
etc. tables to innodb? I.e.,
use mysql;
alter table columns_priv type = innodb;
alter table db type = innodb;
alter table func type = innodb;
alter table host type = innodb;
alter table
On Mon, Sep 29, 2003 at 06:06:56PM -0700, Rusty Wright wrote:
> Is it possible, desirable, etc. to convert the mysql grant, system,
> etc. tables to innodb? I.e.,
>
> use mysql;
> alter table columns_priv type = innodb;
> alter table db type = innodb;
> alter table func type = innodb;
> alter tab
Is it possible, desirable, etc. to convert the mysql grant, system,
etc. tables to innodb? I.e.,
use mysql;
alter table columns_priv type = innodb;
alter table db type = innodb;
alter table func type = innodb;
alter table host type = innodb;
alter table tables_priv type = innodb;
alter table user
"Gronquist, Jim M" <[EMAIL PROTECTED]> wrote:
>
> I can log into mysql using
>
> safe_mysqld --skip-grant-tables &
>
> mysql -u root -mysql
>
> The directions say that from mysql I should be able to manually execute
> the SQL commands in mysq
I can log into mysql using
safe_mysqld --skip-grant-tables &
mysql -u root -mysql
The directions say that from mysql I should be able to manually execute
the SQL commands in mysql_install_db
and then run mysqladmin flush-privileges afterword.
It is not apparent to me how to manu
[EMAIL PROTECTED] wrote:
>
> I've installed 4.0.13 on a WinXP system. The service starts and stops just fine,
> but I cannot connect to the server, nor can I ping the 3306 port. I think the
> problem may be failure to complete the post-installation processing. The doc says
> to run installd
Hi,
I've installed 4.0.13 on a WinXP system. The service starts and stops just fine, but
I cannot connect to the server, nor can I ping the 3306 port. I think the problem may
be failure to complete the post-installation processing. The doc says to run
installdir\scripts\mysql_install_db. H
have look at http://www.mysql.com/doc/en/mysql_install_db.html
[EMAIL PROTECTED] wrote:
Description:
When I tried to start MySQL server with
shell>/usr/bin/safe_mysqld &
it gave me the error:
-
Starting m
>Description:
When I tried to start MySQL server with
shell>/usr/bin/safe_mysqld &
it gave me the error:
-
Starting mysqld daemon with databases from /var/lib/mysql
030128 08:56:42 mysqld ended
Robert,
Saturday, November 09, 2002, 10:23:03 PM, you wrote:
RJ> I tried using the instructions I found in the MySQL manual and got hung
RJ> up on starting the MySQL server in an unsecured state. The instructions
RJ> say to start mysqld with the --skip-grant-tables option. When I do I
OK, I lost my password. Snicker away.
I tried using the instructions I found in the MySQL manual and got hung
up on starting the MySQL server in an unsecured state. The instructions
say to start mysqld with the --skip-grant-tables option. When I do I
get a "Fatal Error: Please read &quo
I have installed MySQL on a PC with Windows NT. As the
MySQL dir is not on c:, I have copied the 'my.cnf'
file to c:, and I have edited it to MySQL work with
InnoDB tables. All has been working fine, but
suddendly, without change any, when I have tried to
start up MySQL with the command "mysqld-ma
Hi!
> "Glenn" == Glenn Hancock <[EMAIL PROTECTED]> writes:
Glenn> I also have had trouble with the script that creates my user access tables.
Glenn> I am assuming those tables should get created in the ./var/mysql folder.
Glenn> Its my fault but I removed those tables just to see if they h
Glenn,
Thursday, May 23, 2002, 1:11:25 AM, you wrote:
GH> I have had trouble with the script that creates my user access tables.
GH> I am assuming those tables should get created in the ./var/mysql folder.
They are created in the MySQL data dir. So, if you data dir is
/var/mysql they will be cr
I have had trouble with the script that creates my user access tables.
I am assuming those tables should get created in the ./var/mysql folder.
Its my fault but I removed those tables just to see if they had anything to
do with me not being able to use the mysql database server. I figured it
was
Hi!
>>>>> "vi" == vi nan <[EMAIL PROTECTED]> writes:
vi> Dear all,
vi> I can't install mysql on my computer (HP_UX model 715, 10.20) it occured memory
fault install grant tables failed
vi> pleased help on Attachments
vi> chamnan.v
The pro
rease number of open files to more
than 60
011121 20:15:29 Warning: Changed limits: max_connections: 50 table_cache: 64
./scripts/mysql_install_db[292]: 15249 Memory fault(coredump)
Installation of grant tables failed!
Submitter-Id: <[EMAIL PROTECTED]>
Originator:
Organization:
>Description:
I've tried to install MySQL-2.23.37 on LinuxPPC dr4 (not a recent
distribution, I know that...), from the source code (mysql-3.23.37.tar.gz).
unzip of the file was successfull, configuration and compilation seem to
have worked fine, but the installation of the grant table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ld.so.1: ./bin/mysqld: fatal: libcrypt_i.so.1: open failed: No such file or
dire
ctory
Killed
Installation of grant tables failed!
Examine the logs in ./data for more information.
You can also try to start the mysqld
>Hi, I need to know how to install the grant tables and
>start the server on windows platform in mysql.
>Someone please
>let me know. It's much appreciated.
The grant tables are preinstalled as part of the Windows distribution.
You don't need to install them. As for st
Hi, I need to know how to install the grant tables and
start the server on windows platform in mysql.
Someone please
let me know. It's much appreciated.
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
ing execution.
% Reason: stkGet: (4) nxm_stack_create (0,5251072,16384,8192)
% Running on OSF1 V4.0(1091) on , 512Mb; 1 CPUs, pid 10588
Installation of grant tables failed!
Starting mysqld daemon with databases from
/usr/local/mysql-3.23.31-dec-osf5.1-alphaev6/data
010122 13:05:31 mysqld ended
&
67 matches
Mail list logo
