Re: Funky permission issue...
| From: | Don Wieland | Date: | Wed, 20 Aug 2014 20:16:23 +0000 |
| Subject: | Re: Funky permission issue... | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-323774@lists.php.net to get a copy of this message | ||
On Aug 20, 2014, at 12:42 PM, Aziz Saleh wrote:
> Forgot to mention, borrowed the answer from this link:
>
> http://stackoverflow.com/a/6091447
Okay I ran this separately:
grant all privileges
on dwdc_pps.*
to 'dwdc_pps'@'localhost'
identified by 'my_password';
flush privileges;
ERROR: Access denied for user 'dwdc_pps'@'%' to database 'dwdc_pps'
ERROR: [ERROR in query 1] Access denied for user 'dwdc_pps'@'%' to database
'dwdc_pps'
[ERROR in query 2] Access denied; you need (at least one of) the RELOAD privilege(s) for this
operation
Then I ran this separately:
GRANT FILE ON *.* TO 'dwdc_pps'@'localhost';
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'TO 'dwdc_pps'@'localhost''
at line 1
Sigh… Are you are I am going down the right path - heehee ;oP
Don Wieland
D W D a t a C o n c e p t s