Can't Create DB in Phpadmin

simpy you cant...

you can log as mysql root in phpmyadmin and add db but directadmin will not recognize those db.

For create new database you have to pass via directadmin
 
Hi there,

Im having the same issue as wm20472 : we need to create database(s) and 1 user within each db. By just pressing 1 button. This will be operated by our system admin with a dashboard page. All can be scripted and perfectly safe as we use normal mysql statements like 'create table x like db.y'.

Is there really no way to do this?

And if so.. why not?
Why do i have to use the Direct Admin panel?
Is this for marketing reasons ?
Is this for safety reasons?
Why?

Best regards,
Colin
 
Last edited:
Hmm.. there's a double post of wm20472 which i missed.
In this post there's an answer to my question why db's have to be created within da panel is: "so da can effectively manage them".

so im rephrasing my question: what do you manage?
repair, backup, etc?

And is there a way to do this, but ill loose the support of da ?

Can i do with the api commands?
can i also create users by the api?

thanks
 
Last edited:
Well what do you know? A little more searching before posting the forums would have given me the information of creating databases and users by the API.

This is exactly what i need.
I can implement this in a dashboard and follow da's logic.

More info about the API here:
http://www.directadmin.com/api.html

php api examples shows how nifty it is.

For those being scared of the word API, dont be. DA made it really simple.
For those who need to create a database by hand: use DA's panel.

Thanks,
Colin
 
Last edited:
you can log directly to database with da_admin user and password saved in /usr/local/directadmin/conf/mysql.conf

but.. for as i know, directadmin will no backup your data with user/admin backups.. thats the only problem and you will not see that databse in user databases from directadmin, beside that, everything will work fine...

as nilo sayd, you can use api that would be a better implementation for your site with directadmin

regards
 
Niloc said:
Hi there,

Im having the same issue as wm20472 : we need to create database(s) and 1 user within each db. By just pressing 1 button. This will be operated by our system admin with a dashboard page. All can be scripted and perfectly safe as we use normal mysql statements like 'create table x like db.y'.

Is there really no way to do this?
Click to expand...

This is a completely different issue than wm20472. wm20472 wanted to use phpmyadmin and you want to use your own custom script.

If you do not name the database properly then DA will not see the database and will not perform any backups of the database.

If you are using the API then you are using DA to create the databases and again a completely separate issue than the OP.
 
You must log in or register to reply here.
Back
Top