Hi there,
In MySQL 8, how can you figure out if an entry in the mysql.user table is a
role or a user?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and F
> Date: Wed, 4 Mar 2015 14:04:55 +0100
> From: vegiv...@tuxera.be
> To: lu...@lambrate.inaf.it
> CC: mysql@lists.mysql.com
> Subject: Re: Users and Groups
>
>
> That reminds me, this may be of interest:
> http://www.percona.com/blog/2015/03/02/emulating-roles-per
That reminds me, this may be of interest:
http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/
- Original Message -
> From: "Lucio Chiappetti"
> To: "MySql"
> Sent: Wednesday, 4 March, 2015 12:39:01
> Subject: Re:
On Sun, 1 Mar 2015, Reindl Harald wrote:
Am 01.03.2015 um 20:07 schrieb Steffan A. Cline:
Has anyone seen a plugin for MySQL that will allow you to set up users and
groups for access
but it has all features for privileges like for tables, views and even
colums, you can even restrict the
- Original Message -
> From: "Reindl Harald"
> Subject: Re: Users and Groups
> Am 01.03.2015 um 20:07 schrieb Steffan A. Cline:
>> Has anyone seen a plugin for MySQL that will allow you to set up users and
>> groups for access where you can have a user w
Am 01.03.2015 um 20:07 schrieb Steffan A. Cline:
Has anyone seen a plugin for MySQL that will allow you to set up users and
groups for access where you can have a user who can login, create db etc but
ONLY see the stuff that belongs to them?
I'm speaking of a shared server where mul
Has anyone seen a plugin for MySQL that will allow you to set up users and
groups for access where you can have a user who can login, create db etc but
ONLY see the stuff that belongs to them?
I'm speaking of a shared server where multiple people can use the same
instance but be fully sepa
By default, the mysql users/privileges tables are MyISAM, not ndbcluster.
ndb_mgm backup won't backup anything other than ndbcluster tables. The
--restore-privilege-tables only works if you've converted those user and
privileges tables to ndbcluster.
>From the manual:
>http
Hi,
I was able to backup my cluster using ndb_mgm and also restore using
ndb_restore. However, when everything looks fine after restore, I see that
users and grants are not restored. So, does ndb_restore restore all
databases including information_schema and mysql databases, plus users and
grants
- Original Message -
> From: "Johan De Meersman"
> The particular symptoms I'm seeing, is that I've lost all my archives
> from no-longer existing hosts. All hosts that are still being backed
> up are fine, but the old archives are irrevocably lost, with the
> exception of the one host t
Yo,
Just a little heads-up in case anyone on the list uses Zmanda ZRM for MySQL:
There seems to be a bug in the cleanup script - I suspect it ignores the
per-backupset retention time and always uses the default one (but that is to be
confirmed yet by support).
The particular symptoms I'm see
On 23 May 12, at 03:15, Walter Heck wrote:
> Also, have you looked at MariaDB 5.5?
I've been playing with it a bit. Their "virtual columns" enhancement is pretty
cool -- something I miss from my FileMaker days.
Economics is extremely useful as a form of employment for economist
On Tue, May 22, 2012 at 12:02 AM, Marc Zampetti wrote:
> Is Puppet Labs saying they are ending support of MySQL and instead will only
> support PostgreSQL? That is going to be a big problems for shops that do not
> support PostgresSQL, or are only allowed to run DB systems on an approved
> list. W
al Message -
> From: "John Daisley"
> To: "mysql"
> Sent: Friday, 3 June, 2011 1:32:35 PM
> Subject: Re: Allowing all users to access a specified database
>
> You could easily write a script which queries the mysql grant tables
> and
> grants the required
You could easily write a script which queries the mysql grant tables and
grants the required permissions to every user on your system. Granting
access the way you were suggesting gives the whole world access not just
users of the system.
That said as that is a shared database which all users are
s to those databases then you would want security to be far tighter.
Allowing that sort of access is about as secure as publishing the data on
facebook.
That's not a problem in this case - the data is *intended* to be shared
between all users of the system. It's data required by the s
While it does not support wildcards, it does support an empty username field. A
subtle distinction :-) Simply grant access to ''@'%'.
- Original Message -
> From: "Mark Goodge"
> To: mysql@lists.mysql.com
> Sent: Friday, 3 June, 2011 12:03:56 PM
&g
t security to be far tighter.
Allowing that sort of access is about as secure as publishing the data on
facebook.
What version of MySQL are you using?
On 3 June 2011 11:03, Mark Goodge wrote:
> Hi,
>
> I have a database server with multiple users and multiple databases. I have
> a sit
Hi,
I have a database server with multiple users and multiple databases. I
have a situation where I want to allow any user to connect to a
specified database.
Unfortunately, the documentation has this to say:
"MySQL does not support wildcards in user names."
Which means, that,
On 12/16/2010 03:53, Tim Thorburn wrote:
On 12/16/2010 3:42 AM, Tim Thorburn wrote:
I should mention this is Windows 7 Ultimate 64-bit. After rebooting I
installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once
MySQL was installed, I downloaded and installed the current version of
Wor
On 12/16/2010 3:42 AM, Tim Thorburn wrote:
I should mention this is Windows 7 Ultimate 64-bit. After rebooting I
installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once
MySQL was installed, I downloaded and installed the current version of
Workbench (5.2.31a). When I run Workbenc
- As Administrator, I ran DOS prompt and entered NET STOP MYSQL
- Ran MySQL Instance Configuration Wizard to remove the current instance
- Uninstalled MySQL Server 5.1.51 from Control Panel
- Went through my Users, ProgramData, and Program Files folders to
delete any references to MySQL.
- Reboot comput
Hi all, I have upgraded a few test boxes and everything seems to work fine BUT
I
wanted to verify with the gurus if my syntax is correct so as to avoid any
future problems ;-)
The purpose is to dump all databases and users / user privileges from our
4.1.20
server and import it into our
I'm looking to implement a new website, which will have on average around
100 approx users at any one time. Is there anything I need to be aware of
when setting up MySQL in terms of the server configuration ?
Regards
Neil
Hello Stewart,
Stewart Smith a écrit, Le 24.05.2010 11:38:
On Mon, 24 May 2010 10:45:30 +0200, Guilhem Bichot wrote:
bzr branch lp:mysql-server/trunk mysql-trunk
Download was 200MB.
~20minutes on ADSL from Australia
bzr using 100% CPU
bzr using ~600MB RAM
Thanks for the numbers. Does
On Mon, 24 May 2010 10:45:30 +0200, Guilhem Bichot wrote:
> bzr branch lp:mysql-server/trunk mysql-trunk
Download was 200MB.
~20minutes on ADSL from Australia
bzr using 100% CPU
bzr using ~600MB RAM
--
Stewart Smith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Hello,
Please, read this email if you are using Bazaar branches of MySQL Server
code located on Launchpad (at https://code.launchpad.net/mysql-server ).
Continuation of my email of yesterday sent to the same lists.
It seems that Launchpad has finished converting at least the main
branches (m
Hello,
Please, read this email if you are using Bazaar branches of MySQL Server
code located on Launchpad (at https://code.launchpad.net/mysql-server ).
I just converted our Oracle-internal Bazaar shared repository to "Bazaar
format 2a" (it used to be in format 1.9). This is a new format wher
alikrishna g
> wrote:
>
> > i am working on my pc with mysql-5.0.27-community-nt
> > i have created users by using create user and i given some privileges,
> but
> > i
> > dont know how to switch between users on mysql command line, please help
> me
> > re
Hi Murali,
We can switch to another user only by a new connection and not possible in
mysql prompt.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:24 PM, muralikrishna g
wrote:
> i am working on my pc with mysql-5.0.27-community-nt
> i have created users by using create user and i
i am working on my pc with mysql-5.0.27-community-nt
i have created users by using create user and i given some privileges, but i
dont know how to switch between users on mysql command line, please help me
regarding this..
thanks in advance
Hi Eric,
>> At least with Maatkit, you get transparency. We make a concerted
>> effort to update the RISKS section of each tool with each release, so
> there
>> is full disclosure.
>
> Fair enough, but I still found the warnings a little too scary. A more
> complete explanation of the exact natur
Hi Baron,
> I'm the primary author of Maatkit.
Awkward... :-)
> What can I say -- you could go buy a commercial off-the-shelf tool
> and believe the song and dance they feed you about the tool
> being perfect.
There's not a single commercial software solution in our toolbox. We're
big fan
Eric,
>> There are ways to resync data that don't involve all
>> this as well: Maatkit has some tools
>
> I've looked with great interest at Maatkit, but their tools are replete
> with warnings about dangers, bugs, and crashes. They certainly do not
> inspire confidence.
I'm the primary author o
>> I would never have any confidence that the replication
>> is solid enough to use the slave server for backup purposes.
> I agree completely there. That's the other reason I like filesystem
> snapshots is that it allows you to take a backup from
> the master relatively painlessly.
I've thou
---Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Friday, December 04, 2009 1:24 PM
To: Gavin Towey; Tom Worster; mysql@lists.mysql.com
Subject: RE: Here's an Idea for Re-Syncing Master and Slave During Production
Hours without Interrupting Users (Much)
> I
confidence that the replication is solid
enough to use the slave server for backup purposes. (Which, by the way,
is the real reason I'm doing this. In the middle of the night, when
there are few users on the system, I want to backup the slave, but first
I want to make sure I have a 100% reli
On 12/4/09 3:14 PM, "Gavin Towey" wrote:
> I would say that it's very important to know why data is getting out of sync
> between your master and slave. Fixing those root causes would eliminate the
> need for this.
i very much agree. the only instances of slaves getting out of whack that
i've e
9:00 AM
To: Tom Worster; mysql@lists.mysql.com
Subject: RE: Here's an Idea for Re-Syncing Master and Slave During Production
Hours without Interrupting Users (Much)
> (1) innodb?
It's an off-the-shelf application that uses MyISAM tables. It is
possible to convert to innodb, but I h
On 12/4/09 11:59 AM, "Robinson, Eric" wrote:
>> (2) why delete slave logs when you can
>> restart the slave with --skip-slave and
>> then use CHANGE MASTER TO?
>
> Well... I guess mainly because I didn't know about that option! I
> thought I needed to "fake out" mysql on this, but it sounds like
> (1) innodb?
It's an off-the-shelf application that uses MyISAM tables. It is
possible to convert to innodb, but I have not been sold on innodb in
terms of its performance characteristics for this particular
application. Maybe I've been reading the wrong stuff. Do you have
general thoughts on t
lave.
>
> When you're done, you have a 100% binary duplicate of the master
> database on the slave, with no worries that some queries got missed
> somewhere. The master was never stopped and users were not severely
> impacted. (Mileage may vary, of course.)
>
> We've tri
have a 100% binary duplicate of the master
database on the slave, with no worries that some queries got missed
somewhere. The master was never stopped and users were not severely
impacted. (Mileage may vary, of course.)
We've tried this a few times and it has seemed to work well in most
cas
er wrote:
>
> Now I'm wondering if I can use this query in an update to set a variable in
> a second table
>
> Users
> --
> User_id VARCHAR(50)
> . . .
> User_active BITINT(1)
>
> I want to set user_active to 0 where the user_id is in the query below.
>
> se
et a variable
>> in
>> a second table
>>
>> Users
>> --
>> User_id VARCHAR(50)
>> . . .
>> User_active BITINT(1)
>>
>> I want to set user_active to 0 where the user_id is in the query below.
>>
>> select user_id, max(tweet
At 12:13 PM 11/8/2009, John Meyer wrote:
Now I'm wondering if I can use this query in an update to set a variable in
a second table
Users
--
User_id VARCHAR(50)
. . .
User_active BITINT(1)
I want to set user_active to 0 where the user_id is in the query below.
select user_id
Now I'm wondering if I can use this query in an update to set a variable in
a second table
Users
--
User_id VARCHAR(50)
. . .
User_active BITINT(1)
I want to set user_active to 0 where the user_id is in the query below.
select user_id, max(tweet_createdat) from tweets group by us
l Dykman [mailto:mdyk...@gmail.com]
Sent: Sunday, November 08, 2009 8:35 AM
To: John Meyer
Cc: mysql@lists.mysql.com
Subject: Re: Finding users who haven't posted in a week
the function max(), among others, makes no sense in the absence of a
GROUP BY clause.
try adding "GROUP BY user_id&q
the function max(), among others, makes no sense in the absence of a
GROUP BY clause.
try adding "GROUP BY user_id"
- michael dykman
On Sun, Nov 8, 2009 at 9:40 AM, John Meyer
wrote:
> I want to get a list of all users who haven't posted in a week. But when I
> use t
I want to get a list of all users who haven't posted in a week. But when I
use the following function.
select user_id, max(tweet_createdat) from tweets where
datediff(now(),max(tweet_createdat)) > 7;
Is producing the error:
Invalid use of group function
India
http://www.synapse.in
I.T. Outsourcing @ Peace of Mind
- Original Message -
From: "Bruce Ferrell"
To: "Jeetendra Ranjan"
Cc:
Sent: Tuesday, October 20, 2009 9:27 PM
Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily
this error indi
is script
>
>
> Thanks & Regards
> Jeetendra Ranjan
>
> - Original Message -
> From: "Bruce Ferrell"
> To:
> Cc:
> Sent: Thursday, October 15, 2009 12:20 PM
> Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily
>
>
>&g
me how can i run this script
Thanks & Regards
Jeetendra Ranjan
- Original Message -
From: "Bruce Ferrell"
To:
Cc:
Sent: Thursday, October 15, 2009 12:20 PM
Subject: Re: Req. suitable .cnf file for Server used by 2000 users daily
>
> Have a look at mysqltuner. It
ysql-indexes.html
>
>
> Regards,
> Gavin Towey
>
>
> -Original Message-
> From: jeetendra.ran...@sampatti.com [mailto:jeetendra.ran...@sampatti.com]
> Sent: Wednesday, October 14, 2009 3:21 AM
> To: mysql@lists.mysql.com
> Subject: Req. suitable .cnf file fo
aunch one website whose database is in MySQL. I am very
> exited about the server setting specially about .cnf file.
> I have below hardware and .cnf details. Will you please guide me is the .cnf
> file details sufficient to support current hardware.
> Initially 2000 users will vis
.cnf file for Server used by 2000 users daily
Hi,
Will you plesae guide me ?
We are about to launch one website whose database is in MySQL. I am very exited
about the server setting specially about .cnf file.
I have below hardware and .cnf details. Will you please guide me is the .cnf
file
sufficient to support current hardware.
Initially 2000 users will visit this site everyday.
Hardware and OS
*
... snip ...
Unfortunately, you have not asked us an answerable question. There are
too many unknowns in your setup for us to estimate how much database
usage per customer
.
Initially 2000 users will visit this site everyday.
Hardware and OS
*
Operating System : Red Hat Fedora Core 8
Processor : Intel Core 2 Quad - 2.83 GHz,
RAM : 4 GB
Total Disk Space : 600 GB (300 GB usable)
RAID : RAID1
Disk Drive(s) : 300 GB (Drive #1), 300 GB (Drive #2
I would like to prevent users from changing their passwords unless they have
grant permission. Is this possible?
We have an set of stored procedures for managing users/databases for a single
signon project that we are working on. The problem is if a user connects
directly to the database
Check your rights ;)
-Ursprüngliche Nachricht-
Von: jinava [mailto:jin...@gmail.com]
Gesendet: Mittwoch, 1. Juli 2009 14:52
An: mysql@lists.mysql.com
Betreff: Re: why different users get different count(*) from same table?
Hi experts,
Something strange here, use root and mysql (root
Hi experts,
Something strange here, use root and mysql (root and mysql are user
accounts) to select count(*) from same table, but the result is different.
login as root:
mysql -uroot -p information_schema
mysql> select * from tables where table_name='tb_staff'\G
*** 1. r
Hi experts,
something strange here, use root and mysql (root and mysql are user
accounts) to select count(*) from same table, but the result is different.
login as root:
mysql -uroot -p information_schema
mysql> select * from tables where table_name='tb_staff'\G
*** 1. r
Carlos,
1) To list the users having access to a database,
mysql> SELECT user,host from mysql.db where db = "**";
In your case that would be
mysql> SELECT user,host from mysql.db where db = "*cal*";
2) To grant access to a *NEW *user, you can use GRANT statement along
On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams wrote:
>> Now I did create that new database called 'forums' and would like to
>> create a new user who has access only to that specific database from
>> localhost. I can't seem to find the
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams wrote:
> Now I did create that new database called 'forums' and would like to
> create a new user who has access only to that specific database from
> localhost. I can't seem to find the command via Google on how I create
> the user and grant access
On Wed, Apr 22, 2009 at 2:45 PM, George Larson
wrote:
>>> Is this what you mean?
>
> SELECT * FROM user;
Yes. That was exactly what I was looking for. Thank you for that info.
Still learning these commands so pardon my ignorance.
Now I did create that new database called 'forums' and would like
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
>> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley wrote:
>>> All user information is stored in the mysql database. If you want to
>>> see a list of u
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley wrote:
>> All user information is stored in the mysql database. If you want to
>> see a list of users that have been created, query the user information
>> table.
>
This seems to be a simple beginer question for MySQL and I have
searched online but I wanted to ask before I really confuse myself.
I have MySQL running on Linux and right now I have created a 2nd
production database:
mysql> show databases;
+-+
| Database
Hi
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
Be careful if you use this option (logging to a table) - while it's an
extremely att
like to register this
>> information, and be able to analyze it later.
>>
>> Thanks,
>> Shuly,
>>
>
> Shuly,
> Try show status where variable_name like "%connections%". This will
> tell you the number of connections, not the number o
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
On Sun, Dec 21, 2008 at 2:32 PM, Avraham, Shuly wrote:
>
> Hi,
>
> Is there any way to figure
, and be able to analyze it later.
Thanks,
Shuly,
Shuly,
Try show status where variable_name like "%connections%". This will
tell you the number of connections, not the number of users. I don't think
you can find the number of connected users unless you build it into yo
Hi,
Is there any way to figure out how many, if any, people are accessing and using
our MySQL server?
I am aware of the SHOW PROCESSLIST command, but this one only shows how many
processes are currently running. I would like to register this information, and
be able to analyze it later.
Than
> Date: Sat, 19 Apr 2008 20:06:49 +0200
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: mysql@lists.mysql.com
> Subject: Re: Granting users localhost access
>
> Hi Pam,
>
> If you want to grant a specific user remote access i.e. from a shell or
> from an
e change made to the users account and allow them to
access the database from a remote host.
If you do not want to allow access from any host but for example
localhost and a specific IP then you can do:
update mysql.user set host = 'localhost, 69.89.2.231' where user =
'AUse
> > I am sorry I do not understand you.> > > > If I Flush privilages, will this
> > flush all privilages for the user?> > If so, I can not do that because
> > these users> > are already used to log into an existing database via a
> > functioning
sec)> > Rows
> > matched: 1 Changed: 0 Warnings: 0> > > > and I tried to login and could not
> > log in remotely via a remote terminal,> > which is what I am trying to do.>
> > > FLUSH PRIVILEGES;
I am sorry I do not understand you.
If I Flush pr
> This should do the trick:
> update mysql.user set host = 'locahost' where user = 'username'
>
Hi Thanks,
OK I tried running:
update mysql.user set host = 'locahost' where user = 'AUserName';
Substituting AUserName for a real username,
got the return:
Query OK, 0 rows affected (0.00 sec)
Ro
Hi there Pam,
This should do the trick:
update mysql.user set host = 'locahost' where user = 'username'
Regards,
Schalk
Pam Astor wrote:
How do I grant users, who already have a password, localhost
access? I don’t want to change their pa
How do I grant users, who already have a password, localhost
access? I don’t want to change their passwords at this time.
_
Use video conversation to talk face-to-face with Windows Live Messenger.
http://www.windowslive.com
1)the user you have connected with does not have permissions to the table
2)you have not yet connected to the DB containing users table easily solved
by connect mysql and rerun query
Viel Gluck/Buena Suerte
Martin--
- Original Message -
Wrom: LYRWTQTIPWIGYOKSTTZRCLBDXRQBGJSNBOHMKHJYFMY
Garris, Nicole wrote:
> I'm a new MySQL DBA taking over admin duties for an existing MySQL
> nonclustered 4.1 installation. It has 6 small user databases. So in the
> mysql database, I run the query
>
> Select host, user, password from user;
>
> Which returns the following:
>
>
>
> +-
to log in from localhost, but
> a password has been specified?
>
> 4. Line 10 above: User "one-user" can be used to log in from IP address
> y with a blank password?
Blank password means "no password." Blank username means "anonymous
user." I would get
I'm a new MySQL DBA taking over admin duties for an existing MySQL
nonclustered 4.1 installation. It has 6 small user databases. So in the
mysql database, I run the query
Select host, user, password from user;
Which returns the following:
+-+-+-
Hi!
Just wanted to bring up an old topic - the situation with mysql web
clients is the same as last year or is there any new good software?
Something that would be easy to use and look nice to the users? I'm
also looking for something quite simple yet enough customizable.
Thanks!
Ma
t the user had
> > prior to the renaming. This applies to tables, views, stored routines,
> > triggers, and events. "
> >
> > Is there some kind of shortcut to a privilege swap, or am I better off
> > just deleting users and recreating them with the new name.
ase objects that
the user created, nor does it migrate any privileges that the user had
prior to the renaming. This applies to tables, views, stored routines,
triggers, and events. "
Is there some kind of shortcut to a privilege swap, or am I better off
just deleting users and recreating them
of shortcut to a privilege swap, or am I better off
just deleting users and recreating them with the new name.
___
Sorry to deluge this mailing list with so many requests, but I'm trying
to build my knowledge base for a CMDEV and I spend hours painting myself
into corners with MySQL
Up to this point, I have controlled MySQL privileges from Perl or PHP
pages. All connections to the database used the same MySQL login. Ordinary
users used pages that strictly controlled selections, insertions, or updates.
Administrators/Developers used password-protected pages that
Vittorio Zuccalà wrote:
Anthony ha scritto:
for root access, i already have phpMyAdmin installed on the server.
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
Indeed, if you set PHPMyAdmin to 'HTTP' or 'cookie' authentication m
Vittorio Zuccalà ha scritto:
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
Uff...
I didn't remember...
If it is not enought you can use Dadabik (www.dadabik.org)
It is great: do not be impressed from its simple interface. It is very
comp
Anthony ha scritto:
for root access, i already have phpMyAdmin installed on the server.
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hello,
i am looking for a simple Web interface,
for normal users (non admin), that will only have access to their Database,
and have the possibility to manage their tables (create,delete,insert,...).
for root access, i already have phpMyAdmin installed on the server.
--
MySQL General
Dan Nelson <[EMAIL PROTECTED]> writes:
>> Is it possible to do the same with MySQL?
>
> Not yet,
Argh!
> but it being looked at:
>
> http://bugs.mysql.com/bug.php?id=4703
> http://forge.mysql.com/wiki/PluggableAuthenticationSupport
Very good! Keep up the good work guys. I guess our students
words and since want each
> student to have its own MySQL user and database I wanted to make a
> mapping between the database users and the posix users.
> Unfortunately I can't find how to do that.
>
> Let's to be a bit more explicit on what I want to do, I would like
>
database I wanted to make a mapping
between the database users and the posix users. Unfortunately I can't
find how to do that.
Let's to be a bit more explicit on what I want to do, I would like the
user foo in MySQL to be authenticated though pam on the posix user
foo. That way if foo c
a session (this is in PHP) the 'login_date'
BEFORE I update it with the current info. So effectively, that would be the
LAST login date right?
Then I need to whip up some SQL to compare all users created_on date BETWEEN
that 'LAST' date and CURRENT_DATE?
DÆVID
> -O
not sure how to solve. But it's so common, I feel
kind of stupid asking this...
I have a 'user' table with 'login_date' which is an auto updated DATETIME
column and a 'created_on' which is a DATETIME (but not updated after the
record is created the first time)
I
ecord is created the first time)
I want to show a list of users who are new since my last login. But the
problem is that my last login changes for every page load (i.e. it is
updated so that I can guestimate if a user is logged in still or not... I
consider 10m to be the window, since rarely do user
1 - 100 of 551 matches
Mail list logo
