CREATE USER("jeffrey"@"localhost", IDENTIFIED BY "mypass");
Is the problem. You cannot just use a mysql query in php and expect it to work. That line should be removed. You have to execute it in your mysql console, or phpmyadmin, or whatever you prefer to use.
pritaeas
Posting Expert
5,483 posts since Jul 2006
Reputation Points: 653
Solved Threads: 875