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 and
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, the
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
h 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 might have changed
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
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 e
>
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
iEYEARECAAYFAlXUvlgACgkQzTcr8Prq0ZPrHQCdFDqY9uEa1mS6
-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 ne
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 y
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 developer
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 sev
users
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
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
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
> tha
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 b
ical.
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 use
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
> Cu
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: l
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
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 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
I get access denied for
5.2014 21:19, schrieb Érico:
> 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 :
>
>>
>> Am 29.05.2014 20:22, schrieb Érico:
>>> I have ran the following to
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 :
>
> 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 w
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' ,
???
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 wrote:
> I have ran the following to test a fix for an app issue :
>
> delete from mysql.user where user='&
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
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
I get access denied for user 'root'@'localhost" (using pas
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=&#
al/var/db/mysql5 --user=_mysql
--log-error=/opt/local/var/db/mysql5/mac.local.err
--pid-file=/opt/local/var/db/mysql5/mac.local.pid
--socket=/opt/local/var/run/mysql5/mysqld.sock
2175 s000 S 0:00.02 /bin/sh
/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/bin/mysqld_safe
--datadir=
Hi
> > > | | ericomtxmacbookpro.local |
> > *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > >
>
mysql> DELETE FROM mysql.user WHERE user='';
mysql> FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
1.2014 23:59, schrieb Érico:
> > true
> >
> > but please check this out :
> >
> > mysql> Select user, host, password from mysql.user;
> >
> +--+--+---
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 :
>
> http://localhost/mysql
fer-Encoding: quoted-printable
Please 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 den
* 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
*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
gt;> 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
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'@'
emember 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'@'localhost' or you will n
he
> manual
> > that corresponds to your MySQL server version for the right syntax to use
> > near 'to *.* 'root'@'127.0.0.1' identified by kernel26' at line 1
> It's my error :) It should be:
>
> mysql> grant all privileges on *.* to &#x
ur MySQL server version for the right syntax to use
> near 'to *.* 'root'@'127.0.0.1' 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'
by kernel26' at line 1
...
in eclipse using jconnector ... I get the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQL
or. 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
&
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 Oc
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
ro: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 er
r. 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' (using password: YES)
>>
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
> thi
. Type '\c' to clear 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 th
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.
The first time
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
: 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
d
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
?"
>
> The answer to that question 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
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 wrote:
> Hello,
>
> currently on this version of MySQL a database has been built for me to
> use. and following privileges are given: I am not able to c
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/my
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
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
- Original Message -
> From: "Singer Wang"
>
> 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) Write your own p
; 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 --- c
4, 2012 at 11:29 PM, Keith Murphy wrote:
> 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
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/2
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.
From: Claudio Nanni [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
>>
>>
Nanni [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
>
> >
> >
> > Am 04.10.2012 17:28, schrieb Aastha:
&
Hi,
2012/10/4 Reindl Harald
>
>
> 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
want,
> Harald.
not all but the one to the topic
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 opinio
useful at times. I recently turned it on to investigate
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 di
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
Yes, i meant DB users.
On Thu, Oct 4, 2012 at 10:57 AM, Johan De Meersman wrote:
>
> - Original Message -
> > From: "Reindl Harald"
> >
> > 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 o
- Original Message -
> From: "Reindl Harald"
>
> 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 can find it in the
It is possible in MySQL 5.6
S
On Thu, Oct 4, 2012 at 11:30 AM, List Man 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 logged in.
>
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 web-applicat
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 G
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
Thanks for the update, Shawn. I'll check it out right now.
On Mon, Sep 24, 2012 at 4:40 PM, Shawn Green wrote:
> 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
friends, i figure that i had to give password in quotes. i was then able to
login. thank you all for your help and time.
From: Rajeev Prasad
To: Rick James ; mysql list
Sent: Monday, September 24, 2012 4:11 PM
Subject: Re: user not able to login from
mysql> SELECT * FROM mysql.user WHERE user =
ase`.* TO
'myuser'@'localhost' |
+-+
I am using phpmyadmin to manage mysql, including user privileges.
From: Ben Mildren
To: Rajeev Prasad
Cc: mysql list
Sent: Monday, Sep
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 sequ
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.
I
st 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: Mon
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad 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 '
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
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?
yptic usernames? 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 appl
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 us
:wleut...@columbus.rr.com]
> Sent: Friday, September 21, 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
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 M
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:
http://dev.my
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 database
- Original Message -
> From: "Cifer Lee"
>
> 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 coul
Reindl Harald <<mailto:h.rei...@thelounge.net>
> 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 <<mailto:mantia...@gmail.com>mantia...@gmail.com>
> >
&
ly known)
At 21.38 26/03/2012 +0800, Cifer Lee wrote:
>-- Forwarded message --
>From: Reindl Harald <<mailto:h.rei...@thelounge.net>h.rei...@thelounge.net>
>Date: Mon, Mar 26, 2012 at 9:17 PM
>Subject: Re: why must user variable in EXECUTE USING claus
-- Forwarded message --
From: Reindl Harald
Date: Mon, Mar 26, 2012 at 9:17 PM
Subject: Re: why must user variable in EXECUTE USING clause ?
To: Cifer Lee
would you PLEASE send to the list instead off-list
and put your answer BELOW instead to-posting?
is it really so difficult
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
1 - 100 of 1985 matches
Mail list logo
