Creating mysql tables once you have db credentials

[ketanco]

Hi,

In wordpress for instance, when you install it, and after you provide the database username, hos and password, wordpress takes care or creating all the necessary tables in mysql by itself. How does it do that? Which files (or hopefully file)? And which line of codes? I mean without me going into phpmyadmin, it creates tables. How, is it done without going into phpmyadmin, that is my question. Otherwise I know just to paste the mysql create table code into query box, once I am in there.

[johanafm]

Creating tables is no different from executing any other query. That is, doing SELECT, INSERT, CREATE TABLE, ALTER TABLE etc is done the same way, and thus it doesn't matter if you execute these queries in phpmyadmin, MySQL CLI client or through your own php code.

However, the proper privileges must be set up, and a user may have privileges for SELECT only, or SELECT, INSERT, UPDATE, DELETE, but not CREATE.
So once wordpress can connect to the db with credentials for a user with create privs, the queries are executed and the tables created.