team2005
asked on
GRANT SUPER, PROCESS .... Error
Hi!
Include my Command to execute to mysql.
But get this error messege:
ERROR 1064 at line 1: 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 '10.252.170.67 IDENTIFIED BY b2559d6155bab36db6dad9e0a5 b37a2e
The line -> PXKILLR@10.252.170.67
is stored like this in my jobb.sql file:
GRANT SUPER, PROCESS ON WTCDATA.* TO <92>PXKILLR<92>@<92>10.252 .170.67<92 > IDENTIFIED BY <91>b2559d6155bab36db6dad9 e0a5b37a2e <92>
Maby that is the problem ?
Please help ASAP.
Thanks
Include my Command to execute to mysql.
But get this error messege:
ERROR 1064 at line 1: 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 '10.252.170.67 IDENTIFIED BY b2559d6155bab36db6dad9e0a5
The line -> PXKILLR@10.252.170.67
is stored like this in my jobb.sql file:
GRANT SUPER, PROCESS ON WTCDATA.* TO <92>PXKILLR<92>@<92>10.252
Maby that is the problem ?
Please help ASAP.
Thanks
GRANT SUPER, PROCESS ON WTCDATA.* TO PXKILLR@10.252.170.67 IDENTIFIED BY b2559d6155bab36db6dad9e0a5b37a2e
GRANT SUPER, PROCESS ON WTDDATA.* TO PXKILLR@10.252.170.67 IDENTIFIED BY b2559d6155bab36db6dad9e0a5b37a2e
GRANT SELECT ON WTCDATA.WTCMERCHANT TO PXCHKR@10.252.170.67 IDENTIFIED BY 7949406f16d52140802b9e536e537a66
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for help. Working just fine now...
Open in new window