So I have two tables in my phpmyadmin like tabel1 and tabel2 in both tables, i want to select id = 2 so I have tried mysql_query('SELECT * FROM tabel1, table2 WHERE id=2'); but not working plz give me some…
Can any please help me in below issue. I am planning to host more than one site on single AWS ec-2 Instance, now I want every site have its own cpanel and phpmyadmin. Confusion should I need to install Cpanel…
When I try to sign into my websites wp-admin login screen it refreshes and redirects me to the login page. After researching this issue it looks like deactivating the plugins should fix the issue. However, when I try doing this…
I am not sure why I am getting this connection failed error. I am sure that the sever where the database is located is "localhost:3306". I'm currently using cPanel to access myAdmin. My php code is <?php $server = "localhost:3306";…
I have a php script that (in theory) connects to a database. The issue is that when I try to test my script in http://phptester.net/ it tells me that said credentials are wrong. I am fairly new to this whole…
I am trying to rework an old implementation of osCommerce and re-introduce data from the old database to the new one. I exported the data from the old tables using phpMyAdmin. When I tried to import them to the new…
I'm trying to move a WordPress database from Plesk to cPanel using phpMyAdmin but I get the following error when importing: SQL query: Table structure for table `wp_commentmeta` CREATE TABLE IF NOT EXISTS `wp_commentmeta` ( `meta_id` BIGINT( 20 ) UNSIGNED…
I've been trying to work out the best way of copying structure & data from one database to another but the PHPMyAdmin export seems to churn out pretty poor scripts. The most obvious example is if I export a database…
I have a remote mySQL table that I use in a few tools, occasionally I need to access the table from inside a particular test site temporarily. The problem is I cannot access phpMyAdmin because an outbound port is blocked…
I have plesk 8.3.0, with phpmyadmin 2.8.2.4 I tried to look up where the phpmyadmin is located. I couldn't find it in srv/ and i did a find command in the server and not quite sure where it is actually…