Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : phpMyAdmin help

[SusieWoosey]

I am new to phpMyAdmin, it is already installed on where my webspace is hosted. I have an online store set-up with php/mysql and have been able to modify it to a certain extent without totally messing things up (ie it still works), learning a little php in the process.

I was trying out phpMyAdmin from my website control panel, and even though I am logged in and can access all aspects of my control panel, when I go to phpMyAdmin it appears I am unable to create a new database.

It simply says 'No Privileges'. How can I be barred from making a new database on my own website? Have I inadvertantly done something to cause a problem? Or totally messed something up?

I have read tutorials on making a new database in php and it all seems pretty simple, but I'd like to try phpMyAdmin too.

Any offers of help greatly appreciated.

Love SusieWoosey

[shoperotic]

usually, in website's control panel( Cpanel, Plesk, so on), you need to create databases from control panel,(with separate users and passwords) not in phpmyadmin , and you can see those databases in separate instances of phpmyadmin.

[ElyDesign]

As the other user says, usually you should create a new DB from the control panel and to use it there. Some shared hosting are limited to one DB. Check out what is yours. If they have given you more DB, you should see them in the control panel of the hosting. The problem is not in the phpMyAdmmin, but in the way the hosting companies use it.

[SusieWoosey]

Thank you for the replies, with a little more tinkering and messing about I have now succeeded in creating a new database, added some data to it, and I have been able to write a short .php program to retrieve selected items from it.

This time last week I could not do either task.

Thanks again for your input and showing me the right direction.


SusieWoosey