[SOLVED] LAMP question. How to create new database from PHP, SQL

zubat123 · 11-04-2010, 11:36 PM

Actually, I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?

quanta · 11-05-2010, 01:34 AM

Create a new user and grant CREATE privilege for it.

smoker · 11-05-2010, 01:38 AM

Not without giving the regular user extra privileges. It is a better idea to create the database manually first as root, then create a user with the minimum privileges required that can create/modify/delete tables within that database. Your script can then do all it needs to, but can't affect any other databases.