Creating Database and Assign user from PHP Code

Question

I want to ask about create user and database from PHP Code.

I have cpanel at server. At my application, I want my app create a database to backup something. But I always get error "access denied"

So, how to create a database and assign user to that database so this user can access it.

My code right now is:

<?php
$con = mysql_connect("localhost","k3516438_disp","secret");
mysql_query("GRANT ALL PRIVILEGES ON *.* TO  'k3516438_disp'@'localhost' IDENTIFIED BY PASSWORD 'secret' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

if (mysql_query("CREATE DATABASE IF NOT EXISTS k3516438_dispatcher_backup",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}

mysql_select_db("universal_backup", $con);

$sql = "CREATE TABLE order_backup
(
order_id varchar(15),
request_id varchar(15)
)";

mysql_query($sql);
?>

And it still not works, that code I have write is from this: problem. But it doesn't work for me, I thought. Sorry for my Bad English.

Error creating database: Access denied for user 'k3516438_disp'@'localhost' to database 'k3516438_dispatcher_backup' — Celia Tan
– Celia Tan, Commented Jan 26, 2013 at 3:45

Mark · Accepted Answer · 2013-01-26 03:37:32Z

1

Sounds like your user doesn't have relevant privileges.

answered Jan 26, 2013 at 3:37

Mark

2,4734 gold badges26 silver badges40 bronze badges

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

2 Comments

Celia Tan Over a year ago

well, that's my question. How to grant that user from PHP code.

Mark Over a year ago

If the user doesn't have access in the first place, it would be obviously unsecure if you could just request higher access via the user that needs it! Create another user that your script will use, with the required permissions. Then use that user inplace of the one you have. To create and grant subsequent users permission(s).

Manjula · Accepted Answer · 2013-01-26 03:49:38Z

0

It is not enough to have the required privilege to user. He should have the privileges when he logged from a specific IP also. Please check whether user "k3516438_disp" have the privileges to create users and databases when accessing from your server IP.

May be your user "k3516438_disp" doesn't have the permission to access from "localhost". MySQL official site has more information about 'access denied' errors. See http://dev.mysql.com/doc/refman/5.1/en/access-denied.html

edited Jan 26, 2013 at 3:49

answered Jan 26, 2013 at 3:43

Manjula

5,1413 gold badges31 silver badges42 bronze badges

1 Comment

Celia Tan Over a year ago

I've give all privileges to that user.

Celia Tan · Accepted Answer · 2013-01-28 02:08:07Z

0

Finally I backup it from local (my office), remote the database. Because at local there's no problem to that privileges. Thanks for all respond to this question.

answered Jan 28, 2013 at 2:08

Celia Tan

1657 bronze badges

Collectives™ on Stack Overflow

Creating Database and Assign user from PHP Code

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related