i am on shared hosting and i can create a database through cpanel but when i go to phpmyadmin it says no databases any ideas why is happening?
Its not possible to create new database using phpmyadmin in shared hosting due to security issue, use mysql database wizard instead .
Did you install phpmyadmin or was it provided by your service provider? If you have received it with your hosting account (ie via cPanel) then open a support ticket with your hosting provider, however if you have installed phpmyadmin yourself, than look for config.inc.php in root folder (phpmyadmin root folder) and make suitable changes to server name / username / password etc. HTH
thanx for the replies i opened a support ticket and im still waiting for a reply and i cant do anything until they fix it
provide the host providers the username, password and then database name, and they will create one for you. They should be able to create one for you. If already exists, ask them to grant permission for the username only and not recreate.