Hello people!
I am on a competition for a job, and I was asked to make various tricky things I could manage to solve them.
But now I am asked to create a database from PhpMyAdmin, I am getting access to a webhosting service, I am loging to cPanel and then access from there to PhpMyAdmin.
The thing is that I cannot create databases from PhpMyAdmin, since I am logged as a user without privileges to create databases. Here I am trying to create a database directly from console:
[https://ibb.co/FsQWn1P
Even the button to make new Databases is disabled:
[https://ibb.co/Lx5xxNS
And I cannot access to the .mysql folder from the terminal, since it is inside root directory.
I think the hint here is that I am using a shared webhost:
[https://ibb.co/gFnhTxN
There is a MySQL Database wizard in cPanel but that is not a valid solution. I also have to name the database with 2 words beginning with capital letters like this: “MyDatabase”
But from the SQL wizard it is all set to lowercase and it has to have my user prefix, then “_” and finally the name of the database: “myuser” + “
[https://ibb.co/c1svN5L
Remember that I don’t have access to the root user (at least I don’t have any password) so I cannot grant privileges to my current user (the one that I have access to PhpMyAdmin) to create databases.
I have until today at midnight to submit my solution (this issue is only one from many that I have already solved), so if you can help me, I would be really really thankful.
I still am researching, this is the only thing that I am missing, I will post the answer if I find it.
P.S.: Sorry for my noobness to post pictures, I’ve been awake for a lot of hours now, I really want to sleep.