Hi all,
No SQLite support?
http://www.sqlite.org/
Seems curious you wouldn't have this yet, especially given its popularity
on
both embedded systems and Android to say the least.
Indeed, no native SQLite support. Lots of other systems are popular and
not supported.
The reason for this is t
Apparently Winblows-only.
It sure would be nice if people would note platform requirements in their
announcement, rather than forcing people to dig through their websites for such
info.
I guess I should know better; if it doesn't list platform requirements, the
developer hasn't thought beyond
Correct me if I am wrong, but my impression is that usage of
"DEFINER=" in stored procedures has no impact on runtime and is
actually optional.
(not to be confused with the clause SQL SECURITY INVOKER which is
crucial.)
Note: I use 5.1.32-enterprise-gpl-advanced-log.
David.
--
MySQL General Mail
- Original Message -
> From: "Brent Clark"
>
> I know the answer (well I think I do :) ), but im still going to ask.
> What is the risk if do the "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
> IDENTIFIED BY 'mysql' WITH GRANT OPTION;"
> To satisfy the developer.
That said developer then h
Perhaps he could make the stored procedure functional by creating a user
with the EXECUTE permission (somebody please fell free to correct me if I am
mistaken) if it is to be used to execute a stored procedure. You don't want
someone to attempt using the 'root' username with a typical 'mysql' passw
It would allow anyone from anywhere to access your server as root with full
access to all databases using the password 'mysql'. Not very secure. I don't
recommend having a root@% defined.
On Aug 17, 2011 8:50 AM, "Brent Clark" wrote:
Hiya
Thank you so much for replying. I really appreciate it.
Hiya
Thank you so much for replying. I really appreciate it.
I know the answer (well I think I do :) ), but im still going to ask.
What is the risk if do the "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY 'mysql' WITH GRANT OPTION;"
To satisfy the developer.
Thank you again.
Brent
Change the definer to one of your registered root accounts. Root@127 or
root@localhost.
On Aug 17, 2011 8:39 AM, "Brent Clark" wrote:
Hiya
Ill be up front my saying my knowledge of store procedures is limited.
A Developer gave me a procedure to load.
It starts off with:
CREATE DEFINER=`root`
Hiya
Ill be up front my saying my knowledge of store procedures is limited.
A Developer gave me a procedure to load.
It starts off with:
CREATE DEFINER=`root`@`%` PROCEDURE
But now, the developer informs me that he gets the following message.
There is no 'root'@'%' registered
Googlin
you are acting blindly
if would recommend that YOU stay at 5.1 and do not touch things
you do not understand as long we are speaking about production servers
why will you change to innodb?
you know about the differences (fulltext search..)?
you know that for most web-load MyISAM is faster?
you k
10 matches
Mail list logo
