of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privilege as described here:
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_replication-slave
My question is about what replication-related users
On 2/26/2019 9:44 AM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 7:29 PM, Jim wrote:
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user
Hello Jim,
On 2/25/2019 7:29 PM, Jim wrote:
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privilege as described here:
https://dev.mysql.com
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master, the replication user must have the
Repl_slave_priv privilege as described here:
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
instance which is currently running on version
> `5.7.11-enterprise-commercial-advanced-log`. On this instance I am
> trying to figure out the most recent timestamp at which a specific user has
> established a connection to this instance (or) performed any DML operations
> which mi
Hi,
We have a MySQL instance which is currently running on version
`5.7.11-enterprise-commercial-advanced-log`. On this instance I am trying to
figure out the most recent timestamp at which a specific user has established a
connection to this instance (or) performed any DML operations
- Improve QxTraits module
<http://www.qxorm.com/doxygen/html/group___qx_traits.html> to reduce
compilation times and build smaller binaries ;
- Improve QxOrm website adding possibility to search and replacing the old
FAQ <http://www.qxorm.com/qxorm_en/faq.html> by a more organized manual
(use
, it sounds like one SQL user.
Think of MySQL users as roles, rather than users. Segregate these roles
according to how much trust you have in the user behind the role, and how much
damage that role could perform.
You may want a separate MySQL user that can only INSERT, for example, but
without DELETE
since you normally never ever should connect as root to your application
it even don't have the permissions to add mysql-users
how would you even imagine working with a usertable on your applications
side which is for every user different - chicken/egg
One generic, non-admin user is what you'll
as root to your application
it even don't have the permissions to add mysql-users
how would you even imagine working with a usertable on your applications
side which is for every user different - chicken/egg
One generic, non-admin user is what you'll find in most apps.
Some developers take
don't have the permissions to add mysql-users
how would you even imagine working with a usertable on your applications
side which is for every user different - chicken/egg
One generic, non-admin user is what you'll find in most apps.
Some developers take the approach of creating several users
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should each get their own MySQL username and password or is
how would you even imagine working with a usertable on your applications
side which is for every user different - chicken/egg
signature.asc
Description: OpenPGP digital signature
?
That is rather vague.
What data is stored for each user?
What are these queries that a user may perform?
- --
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
-BEGIN PGP SIGNATURE-
Version: GnuPG v2
iEYEARECAAYFAlXUvlgACgkQzTcr8Prq0ZPrHQCdFDqY9uEa1mS62LuUr7FhqzEa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/19/2015 10:06 AM, Richard Reina wrote:
Data stored for each user would be a list of places visited that
and details relating to those trips. The type of queries they would
be able to perform be able to read, update and create new records
Hi Reindel,
you client configuration shows no indication for SSL, i see it in my.cnf
only in the [mysqld] section and remember when you initrialize replication
you need to specify it there too
i doubt there is anything to change the logging but since you *know* what
that user requires
Am 21.07.2015 um 05:03 schrieb Tim Dunphy:
I see absolutely NO indication as to why the login for the 'slave2' user
(that requires SSL) is failing
So my questions are 1) how to I bump up the verbosity on the logs so I can
get an indication as to why this is failing? 2) what is the best way
.
We're using mariadb-5.5.41 server on CentOS 7 hosts.
It's a neat plan!
However I am unable to get authentication to work with ssl required of the
user.
We already have a CA certificate and key established in the environment.
And we used those to generate the cert and key to be used with mariadb
Bernd wrote:
a password ?
Hi,
this is my system:
mysql status
--
mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1
Connection id: 142883
Current database: mysql
Current user: root@localhost
SSL
Hi,
this is my system:
mysql status
--
mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1
Connection id: 142883
Current database: mysql
Current user: root@localhost
SSL:Not in use
Current pager: less
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user 'root'@'localhost (using password:'NO')
how can I
Am 29.05.2014 20:22, schrieb Érico:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user 'root
Did you tried this..
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
*thanks,*
*-- *Kishore Kumar Vaishnav
On Thu, May 29, 2014 at 11:22 AM, Érico erico...@gmail.com wrote:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user
for root/localhost ... ?
one with pwd filled
and the second with the pwd empty
how can I insert on this table with the mandatory column ssl_cipher as blob
... ? what value must I provide in a insert like :
insert into mysql.user(host,user,ssl_cipher) values('localhost','root' ,
??? )
thks !!
2014-05
running this :
./mysqladmin -u root -p
at this momento it thorws me to mysqladmin man page
2014-05-29 15:35 GMT-03:00 Reindl Harald h.rei...@thelounge.net:
Am 29.05.2014 20:22, schrieb Érico:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user
this :
./mysqladmin -u root -p
at this momento it thorws me to mysqladmin man page
2014-05-29 15:35 GMT-03:00 Reindl Harald h.rei...@thelounge.net:
Am 29.05.2014 20:22, schrieb Érico:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got
Hello Érico
On 5/29/2014 2:22 PM, Érico wrote:
I have ran the following to test a fix for an app issue :
delete from mysql.user where user='';
2lines got effected
after this I can´t connect through command line anymore :
./mysqladmin -u root password pwd
I get access denied for user 'root
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd / server and db
using both localhost and 127.0.01
Hello Érico,
On 5/29/2014 3:51 PM, Érico wrote:
I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
)
at its login page it asks for user / pwd
Hi,
I am trying to connect two mysql servers with different versions ( 5.1
5.5 ) . But in Mysql 5.1 i am facing strange issues.
Below testuser exists in both Mysql Versions :
mysql select host,user,password from mysql.user where user='testuser
/bin/sh /opt/local/lib/mysql5/bin/mysqld_safe
--datadir=/opt/local/var/db/mysql5
--pid-file=/opt/local/var/db/mysql5/mac.local.pid
295 ?? S 0:00.74 /opt/local/libexec/mysqld --basedir=/opt/local
--datadir=/opt/local/var/db/mysql5 --user=_mysql
--log-error=/opt/local/var/db/mysql5
Hi
| | ericomtxmacbookpro.local |
*E85DC00A0137C6171923BE35EDD809573FB3AB4F |
mysql DELETE FROM mysql.user WHERE user='';
mysql FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
13.01.2014 23:59, schrieb Érico:
true
but please check this out :
mysql Select user, host, password from mysql.user;
+--+--+---+
| user | host | password
the current input
statement.
mysql
...
but in the browser I get the error :
Access denied for user 'root'@'localhost' (using password: YES)
I can't find any information in error log and access log
is there any command parameter that I should use when starting mysql so
this doesn't happen ?
I
the error :
Access denied for user 'root'@'localhost' (using password: YES)
I can't find any information in error log and access log
is there any command parameter that I should use when starting mysql so
this doesn't happen?
are you using localhost or 127.0.0.1 in the web-application
root
with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.15 MySQL Community Server (GPL)
but in the browser I get the error :
Access denied for user 'root'@'localhost' (using password: YES)
I can't find any information in error log and access log
is there any command parameter that I
:
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.15 MySQL Community Server (GPL)
but in the browser I get the error :
Access denied for user 'root'@'localhost
monitor. Commands end with ; or \g.
Your MySQL connection id is 97
Server version: 5.6.15 MySQL Community Server (GPL)
but using 127.0.0.1 no :
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h
127.0.0.1 -P 3306
Enter password:
ERROR 1045 (28000): Access denied for user
password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
ericomtxmacbookpro:bin ericomtx$
2014/1/13 Erick Ocrospoma zipper1...@gmail.com
From that error I would suspect you are trying to access to a database
where has not external access. And yeah, try
)
but using 127.0.0.1 no :
ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1
-P 3306
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
ericomtxmacbookpro:bin ericomtx$
2014/1/13 Erick Ocrospoma zipper1
the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237
' identified by kernel26' at line 1
It's my error :) It should be:
mysql grant all privileges on *.* to 'root'@'127.0.0.1' identified by
'kernel26';
...
in eclipse using jconnector ... I get the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
error :) It should be:
mysql grant all privileges on *.* to 'root'@'127.0.0.1' identified by
'kernel26';
...
in eclipse using jconnector ... I get the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
password: YES
' or '127.0.0.1' is where the
server believes the connection is coming from. The password you must be
using in your client connection attempt must match the one used on the
server for the mysql user 'root'@'localhost' or you will not authenticate.
You also need to remember that if your .php page
ericomtxmacbookpro.local
#127.0.0.1 mysqld
The thing to remember is that 'localhost' or '127.0.0.1' is where the
server believes the connection is coming from. The password you must be
using in your client connection attempt must match the one used on the
server for the mysql user 'root
id is 31
Server version: 5.6.15 MySQL Community Server (GPL)
but in the browser I get the error :
Access denied for user 'root'@'localhost' (using password: YES)
I can't find any information in error log and access log
is there any command parameter that I should use when starting mysql so
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a *mysql user* with *that
host*
http://dev.mysql.com/doc
*if there is* a *mysql user* with *that
host*
http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
... snip ...
The problem is, his other clients (his php page,his eclipse environment)
is where he has problems making the connection from. His direct
connection (using the mysql command
provide the output of the below query.
Select user, host, password from mysql.user;
Thanks
Vikas Shukla
Mail Sent from my Windows Phone From: Reindl Harald
Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38
To: mysql@lists.mysql.com
Subject: Re: Access denied for user 'root'@'localhost' (using
Am 13.01.2014 21:47, schrieb shawn l.green:
Hello Reindl,
We are not saying he is using HTTP commands to log into his database
we excludes obviously the OP or his overall understanding :-)
Am 13.01.2014 18:54, schrieb Érico:
using both urls I get the same error :
I've noticed a weird issue in our chained replication environment where when
setting user-defined variables, the first time the variable is used in a
session the value is NULL, but all uses thereafter work correctly.
The environment is such: we have a master (master1), which has a slave which
Hi Matthew,
On 16/07/2013 21:21, Matthew Ward wrote:
I've noticed a weird issue in our chained replication environment where when
setting user-defined variables, the first time the variable is used in a
session the value is NULL, but all uses thereafter work correctly.
snip
The first time I
you need CREATE Privileges.
http://dev.mysql.com/doc/refman/5.0/en/grant.html#grant-privileges
On Wed, Feb 27, 2013 at 10:42 PM, Rajeev Prasad rp.ne...@yahoo.com wrote:
Hello,
currently on this version of MySQL a database has been built for me to
use. and following privileges are given: I
is that he/she needs CREATE to create tables and
ALTER to alter them.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@lists.mysql.com
Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow
the user to create or drop tables, the user below is
able to do anything for a common web-app
to anser the OP's question
% in mysql is the same as * for the bash
so yes, % means any host
Am
...@thelounge.net]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@lists.mysql.com
Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow the user to create or
drop tables, the user
Hello Round,
On 12/27/2012 5:34 AM, Round Square wrote:
On 12/26/2012 01:25 PM, Igor Shevtsov wrote:
You mysql.user table might be corrupted.
If you have access to it as a root user, try check table mysql.user, and repair
table mysql.user if table corruption was detected.
Alternatively, shut
On 12/26/2012 01:25 PM, Igor Shevtsov wrote:
You mysql.user table might be corrupted.
If you have access to it as a root user, try check table mysql.user, and
repair table mysql.user if table corruption was detected.
Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your
Hi all:
Suddenly, after a long, functioning run of the mysql server, all the non-root
accounts went bad, with:
Access denied for user 'non_root_user'@'localhost' (using password:
YES)
Authenticating with non_root_u...@server.ip.address still works ( the
bind-address in my.cnf
You mysql.user table might be corrupted.
If you have access to it as a root user, try check table mysql.user, and
repair table mysql.user if table corruption was detected.
Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your
$datadir/mysql directory) and run
mysqlcheck -r
at 11:29 PM, Keith Murphy bmur...@paragon-cs.comwrote:
My friend Dave Holoboff wrote this up some time ago:
http://mysqlhints.blogspot.com/2011/01/how-to-log-user-connections-in-mysql.html
You know you people sound like children.
Really unprofessional.
Go ahead --- call me names. i left
://mysqlhints.blogspot.com/2011/01/how-to-log-user-connections-in-mysql.html
You know you people sound like children.
Really unprofessional.
Go ahead --- call me names. i left middle school almost 30 years ago. It
won't bother me.
Can we knock off the name calling and actually offer advice and possible
- Original Message -
From: Singer Wang w...@singerwang.com
2) use a init-connect to log logins but that doesn't work for users
with super privileges as Keith mentioned below (thanks Keith for actually
trying to help!)
That is indeed quite the nifty trick. Thanks, Keith :-)
3)
Hello,
I want to find the last time the given list of users logged in.
Is there any mysql table from where i can retrieve the data or anyt
specific sql
Aastha Gupta
There is no such thing. Your application has to deal with such info.
LS
On Oct 4, 2012, at 11:28 AM, Aastha wrote:
Hello,
I want to find the last time the given list of users logged in.
Is there any mysql table from where i can retrieve the data or anyt
specific sql
Aastha Gupta
Am 04.10.2012 17:28, schrieb Aastha:
I want to find the last time the given list of users logged in.
Is there any mysql table from where i can retrieve the data or any
specific sql
no - because this would mean a WRITE QUERY in the mysql-database
for every connection - having a
It is possible in MySQL 5.6
S
On Thu, Oct 4, 2012 at 11:30 AM, List Man list@bluejeantime.com wrote:
There is no such thing. Your application has to deal with such info.
LS
On Oct 4, 2012, at 11:28 AM, Aastha wrote:
Hello,
I want to find the last time the given list of users
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
this makes pretty no sense and is NOT the job of a RDBMS
implement it in your application / db-abstraction-layer
I notice no specification of what kind of users, so I'm assuming DB users.
There *is* such a thing: you
Yes, i meant DB users.
On Thu, Oct 4, 2012 at 10:57 AM, Johan De Meersman vegiv...@tuxera.bewrote:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
this makes pretty no sense and is NOT the job of a RDBMS
implement it in your application / db-abstraction-layer
it does not matter what kind of users
usually each application has it's own datanase and it's
own user, the application makes the connection and
can at this point log whatever you want
using the general query log can only be a bad joke
you will log EVERY query and not only logins
again
sudden, unpredictable and above all annoyingly brief peaks in the number of
connections, and I needed to know what APPLICATION INSTANCE was responsible,
not which particular user - as well as have a good view of what the offending
sessions did. A tcpdump would have been an option, but given
IT IS IMPOSSIBLE
MYSQL CAN NOT DO WHAT THE OP WANT
Regardless of having any background knowledge on the circumstance of the
question, even.
mysql can not an dwill not log user-logins
You truly are a gifted individual.
your opinion, but the answer to the question of the OP
is simply NO you can't
Hi,
2012/10/4 Reindl Harald h.rei...@thelounge.net
Am 04.10.2012 17:28, schrieb Aastha:
I want to find the last time the given list of users logged in.
Is there any mysql table from where i can retrieve the data or any
specific sql
no - because this would mean a WRITE QUERY in the
[mailto:claudio.na...@gmail.com]
Sent: Thursday, October 04, 2012 3:51 PM
To: Reindl Harald
Cc: mysql@lists.mysql.com
Subject: Re: user last activity and log in
Hi,
2012/10/4 Reindl Harald h.rei...@thelounge.net
Am 04.10.2012 17:28, schrieb Aastha:
I want to find the last time the given list
...@gmail.com]
Sent: Thursday, October 04, 2012 3:51 PM
To: Reindl Harald
Cc: mysql@lists.mysql.com
Subject: Re: user last activity and log in
Hi,
2012/10/4 Reindl Harald h.rei...@thelounge.net
Am 04.10.2012 17:28, schrieb Aastha:
I want to find the last time the given list of users logged
My friend Dave Holoboff wrote this up some time ago:
http://mysqlhints.blogspot.com/2011/01/how-to-log-user-connections-in-mysql.html
You know you people sound like children.
Really unprofessional.
Go ahead --- call me names. i left middle school almost 30 years ago. It
won't bother me.
Can
One small correction. Init-connect doesn't require a restart of MySQL. I
was thinking of init-file. So that's even better.
On Thursday, October 4, 2012, Keith Murphy wrote:
My friend Dave Holoboff wrote this up some time ago:
http://mysqlhints.blogspot.com/2011/01/how-to-log-user
I am considering using cryptic username for accessing and working on a database
on my MySQL installation. can anyone with experience provide some suggestion pl?
in documentation, i only see that it can be 16 char long. how complex it can
be? any side effects/bugs of username complexity? can I
? Have the username
(and db name) reflect the project it's used in or the user it belongs to, make
sure you have a properly complex password, allow only from appropriate hosts
and set up restrictive firewall rules. If you know how many simultaneous
connections the application can make, you can
i have given select/insert/update/delete rights to a user on a specific
database, from localhost. when i try to login to mysql using the uid, i get
error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES)
what other privilege do i need to give this user?
That says that your password in not correct. You have not gotten to specific
privileges.
Did you previously do
GRANT ... TO myuser@localhost IDENTFIED BY '...';
?
If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';
-Original
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad rp.ne...@yahoo.com wrote:
i have given select/insert/update/delete rights to a user on a specific
database, from localhost. when i try to login to mysql using the uid, i get
error:
ERROR 1045 (28000): Access denied for user 'myuser
IDENTFIED BY '...';
?
If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';
-Original Message-
From: Rajeev Prasad [mailto:rp.ne...@yahoo.com]
Sent: Monday, September 24, 2012 10:56 AM
To: mysql list
Subject: user
On this note, one thing that really bugs me about MySQL passwords is the
inability to use special characters. In the SQL Server world, I let users
choose their own passwords, but obeying these rules:
It cannot be a dictionary word or sequence of words.
It must contain at least one numeric digit.
Hello Arthur,
On 9/24/2012 4:25 PM, Arthur Fuller wrote:
On this note, one thing that really bugs me about MySQL passwords is the
inability to use special characters. In the SQL Server world, I let users
choose their own passwords, but obeying these rules:
It cannot be a dictionary word or
' |
+-+
I am using phpmyadmin to manage mysql, including user privileges.
From: Ben Mildren ben.mild...@gmail.com
To: Rajeev Prasad rp.ne...@yahoo.com
Cc: mysql list mysql@lists.mysql.com
Sent
mysql SELECT * FROM mysql.user WHERE user ='myuser
, 2012 4:11 PM
Subject: Re: user not able to login from localhost
mysql SELECT * FROM mysql.user WHERE user ='myuser
Thanks for the update, Shawn. I'll check it out right now.
On Mon, Sep 24, 2012 at 4:40 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Hello Arthur,
On 9/24/2012 4:25 PM, Arthur Fuller wrote:
On this note, one thing that really bugs me about MySQL passwords is the
inability to use special
Hello All,
Question. In mysql 5.5 what are the defaults for these values:
max_connections = ? (is this set to 151 in 5,5)
max_user_connections = ?(is this set to unlimited unless you provide
the exact number)?
Thank you so much.
Wayne Leutwyler, RHCT
Open Source + Open
, 2012 7:04 AM
To: mysql@lists.mysql.com
Subject: Default Values for Max User and Max Connections.
Hello All,
Question. In mysql 5.5 what are the defaults for these values:
max_connections = ? (is this set to 151 in 5,5)
max_user_connections = ? (is this set to unlimited
Hello,
I want to create users and give access to different schema within the
database.
I also want to give them selective privileges to access the table in
different schema.
One way is to create users in MySQL and then grant with privileges.
Is there any way to give them access to MySQL
Hi Aastha,
I think that you can develop a Plugin to do it.
Recently, I post a plugin that allow authenticate users through LDAP Server
(
http://nafiux.com/blog/2012/08/16/mysql-ldap-authentication-plugin-clear-password-client-plugin/
).
More info about MySQL Authentication Plugins:
at 9:17 PM
Subject: Re: why must user variable in EXECUTE USING clause ?
To: Cifer Lee mailto:mantia...@gmail.commantia...@gmail.com
would you PLEASE send to the list instead off-list
and put your answer BELOW instead to-posting?
is it really so difficult to use mailing-lists?
Am
- Original Message -
From: Cifer Lee mantia...@gmail.com
it seems none of you hava answered my question.
Yes, that happens :-)
I'm slightly confused as to the difference between user variables and local
variables, though. Are you saying you couldn't just declare @myvar and use
Am 26.03.2012 14:13, schrieb Cifer Lee:
why can't be local variable which declared in DECLARE clause?
what are you speaking about?
keep in mind that we can not read your thoughts
signature.asc
Description: OpenPGP digital signature
-- Forwarded message --
From: Reindl Harald h.rei...@thelounge.net
Date: Mon, Mar 26, 2012 at 9:17 PM
Subject: Re: why must user variable in EXECUTE USING clause ?
To: Cifer Lee mantia...@gmail.com
would you PLEASE send to the list instead off-list
and put your answer BELOW
, Cifer Lee wrote:
-- Forwarded message --
From: Reindl Harald mailto:h.rei...@thelounge.neth.rei...@thelounge.net
Date: Mon, Mar 26, 2012 at 9:17 PM
Subject: Re: why must user variable in EXECUTE USING clause ?
To: Cifer Lee mailto:mantia...@gmail.commantia...@gmail.com
would you
1 - 100 of 1916 matches
Mail list logo
