Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

problem transferring database

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

problem transferring database

Postby dammyaking » Sat Apr 02, 2011 2:49 pm

i transferred my database from one system to a new one. when i tried accessing it on phpmyadmin, i couldnt access the table. take a look at the snapshot of what i get, in phpmyadmin, it indicatin the no of table but cant select them
phpmyadmin.gif
phpmyadmin.gif (55.51 KiB) Viewed 905 times


can anyone please help me out, i will 4eva be greatful
dammyaking
New php-forum User
New php-forum User
 
Posts: 4
Joined: Sat Mar 05, 2011 9:49 am

Re: problem transferring database

Postby TheProdigyGuy » Fri Dec 16, 2011 2:43 pm

Can you connect to that database and issuse using mysql client (not phpmyadmin)
show tables;
select * from yourtablename;
etc. etc?
If not this means you have no grants for that database.
If yes this means problem in Phpmyadmin (Try to upgrade it)
If no then:
grant all on yourdb.* to 'youruser'@'yourhostip_or_name' with grant option \g
grant usage on *.* to 'youruser'@'yourhostip_or_name' \g
Sorry for buming old thread.
TheProdigyGuy
New php-forum User
New php-forum User
 
Posts: 215
Joined: Wed Dec 07, 2011 5:25 pm


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron