Mysql CREATEUSER command through php

Question

So I am trying to add users to my server that can login through the mysql_connect(host,username,password) command. I currently have

$str = "CREATE USER '.$name.'@'localhost' IDENTIFIED BY '.$encryption.'"
$query = mysql_query($str);

When I run this on my server with the variables manually plugged in, the query works. When I run this through php it doesn't. Is my formatting incorrect?

The formatting does not seems to be good and you may also have permission differences. The php user may not have enough permissions to create mysql users. — Peter Porfy
– Peter Porfy, Commented Oct 29, 2013 at 18:25
In this scenario I am using the root user. So I have full permission. — Wyatt
– Wyatt, Commented Oct 29, 2013 at 18:32

AbraCadaver · Accepted Answer · 2013-10-29 18:25:55Z

1

Get rid of those dots . in the query. You are using doubles quotes and not breaking out of them:

$str = "CREATE USER '$name'@'localhost' IDENTIFIED BY '$encryption'";

answered Oct 29, 2013 at 18:25

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AbraCadaver Over a year ago

Also, if you are actually supplying the hash instead of the plaintext password, you need: IDENTIFIED BY PASSWORD '$encryption'

Collectives™ on Stack Overflow

Mysql CREATEUSER command through php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related