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 table where it has
host='localhost'
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
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:
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]
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 table
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
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
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
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
to 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 PROTECTED]
Subject: Re: o
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]
CC: [EMAIL
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?
Also
13 matches
Mail list logo