Link to home
Start Free TrialLog in
Avatar of team2005
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 b2559d6155bab36db6dad9e0a5b37a2e

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>b2559d6155bab36db6dad9e0a5b37a2e<92>

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

Open in new window

Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

I am not sure which quotes you had, but it must be single quotes...


GRANT SUPER, PROCESS ON WTCDATA.* TO 'PXKILLR'@'10.252.170.67' IDENTIFIED BY 'b2559d6155bab36db6dad9e0a5b37a2e'

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Umesh
Umesh
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of team2005
team2005

ASKER

Thanks for help. Working just fine now...