What's the purpose of the entry in the user table where it has
host='localhost' and user='' (blank) and all of the permissions set to N?
In other words, is this some sort of security safety net and it would be
dangerous to delete it? Or is it an example of setting up an anonymous
locahost user
ocs I read that mysqldump *may* be required when
jumping to a new release series. Is that definitely the case for
3.23 -> 4.0.18? I have a large data set and I want to avoid the
downtime for mysqldump.
TIA.
--rusty
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Date: Wed, 25 Aug 2004 19:30:04 +0300
To: [EMAIL PROTECTED]
From: Egor Egorov <[EMAIL PROTECTED]>
Subject: Re: anonymous localhost user in mysql user grant table
"rusty" <[EMAIL PROTECTED]> wrote:
> What's the purpose of the entry in the user
Creating a database is a separate thing from adding permissions for a
database to the grant tables. When you create a database it's a "free
floating" database that nobody (except root) has permission to access
until you issue the grant statements to make someone "own" it. But
nobody actually owns
I have a user who unfortunately named one of his tables "order". He also
has table names with a dash in them. mysqldump is unable to dump the
"order" table and I'm unable to use the ALTER command on it and the tables
with the dashes in their names to rename them. Is there any way to quote
the ta
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
Not sure if this is what you're looking for but try
http://www.freetds.org
I use it with php to talk to an MS SQL server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Try doing a web search for the program geneweb. It's done by someone in
France but there are English versions as well. It's freeware. It's a
web based genealogy program and has a built-in database. No need to
reinvent the wheel.
--
MySQL General Mailing List
For list archives: http://lists.my
Our backup software can run a shell script before it starts the
backups (and another script when they're finished); I use a script
that shuts mysql down and runs myisamchk. Originally it was using
myisamchk --safe-recover */*.MYI
Then I was eyeballing the online documentation for myisamchk an
Our backup software can run a shell script before it starts the
backups (and another script when they're finished); I use a script
that shuts mysql down and runs myisamchk. Originally it was using
myisamchk --safe-recover */*.MYI
Then I was eyeballing the online documentation for myisamchk an
I'm trying to set it up so that I have only 1 entry per user in my
mysql user table. My users will have the same privileges regardless
of what host they come in from. There's only 1 database they'll be
working with. There are 2 users, user "dentry" can add and edit
information in the database n
o the server. If they were to somehow know the user name
(for example, a disgruntled former employee) they could use this to do
a brute-force password search.
From: "Jason Brooke" <[EMAIL PROTECTED]>
To: "Rusty Wright" <[EMAIL PROTECTED]>, <[EMAIL PROT
Also note that they could use this to do a brute-force search for the
root user's password. E.g., mysql -p -u root -h hishost (or the
equivalent in a c, perl, etc. program).
Date: 10 Apr 2001 16:57:41 -0700
From: Rusty Wright <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
What I want is there to just be 1 password entry for each user,
ignoring the host. As it is now the password is tied to both the user
and host. I would also like to be able to globally specify the hosts
that can connect to the server, ignoring the user, password, and
databases.
Duh, ignore this message; I had my head misthreaded when I screwed it
on this morning.
Date: 10 Apr 2001 17:01:48 -0700
From: Rusty Wright <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: only 1 entry per user in user table?
90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 460531001, file name
./mish02-bin.046
040517 9:32:14 InnoDB: Flushing modified pages from the buffer pool...
040517 9:32:14 InnoDB: Started
/usr/local/mysql-4.0.18/bin/mysqld: ready
16 matches
Mail list logo
