phpmyadmin interview questions
Top phpmyadmin frequently asked interview questions
I am trying to import a .sql file and its failing on creating tables.
Here's the query that fails:
CREATE TABLE `data` (
`id` int(10) unsigned NOT NULL,
`name` varchar(100) NOT NULL,
`value` varchar(15) NOT NULL,
UNIQUE KEY `id` (`id`,`name`),
CONSTRAINT `data_ibfk_1` FOREIGN KEY (`id`) REFERENCES `keywords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
I exported the .sql from the the same database, I dropped all the tables and now im trying to import it, why is it failing?
MySQL: Can't create table './dbname/data.frm' (errno: 150)
Source: (StackOverflow)
How can I change the phpmyadmin automatic log out time?
It will log out automatically after 1440 seconds which is very low for me. How can I change the option or remove log in request completely?
Source: (StackOverflow)
I tried to import a large sql file through phpMyAdmin...But it kept showing error
'MySql server has gone away'
What to do?
Source: (StackOverflow)
I have changed all the php.ini parameters I know:
upload_max_filesize, post_max_size.
Why am I still seeing 2MB?
Im using Zend Server CE, on a Ubuntu VirtualBox over Windows 7 host.
Source: (StackOverflow)
I want to be able create stored procedures using phpMyAdmin and later on use it through php.
But I dont know how to?
From what I know, I found out that we cannot manage stored procedures through phpMyAdmin.
What other tool can manage stored procedure?
I am not even sure if it is better option to use stored procedure through PHP. Any suggestion?
Source: (StackOverflow)
I have done a fresh installation of Fedora 14 and installed the phpMyAdmin module. When I run phpMyAdmin, it asks me for a username and password.
What is the default username and password for phpMyAdmin?
Source: (StackOverflow)
I need to simply edit a very complicated view in phpMyAdmin 3.2.4 but I cannot figure how to do that. Any suggestions?
Thanks!
Source: (StackOverflow)
Usually I use manual find to replace text in mysql database using phpmyadmin, and im tired now, how to run query find and replace that search all table and replace with new text in phpmyadmin.
example : find keyword domain.com, replace with www.domain.com
Thanks..
Source: (StackOverflow)
The user interface for phpmyadmin is displayed in german for some reason and i'd like to change it to english but don't know how. I installed the latest xampp.
Thanks
Source: (StackOverflow)
I'm setting up a database using phpMyAdmin. I have two tables (foo and bar), indexed on their primary keys. I am trying to create a relational table (foo_bar) between them, using their primary keys as foreign keys.
I created these tables as MyISAM, but have since changed all three to InnoDB, because I read that MyISAM doesn't support foreign keys. All id fields are INT(11).
When I choose the foo_bar table, click the "relation view" link, and try to set the FK columns to be database.foo.id and database.bar.id, it says "No index defined!" beside each column.
What am I missing?
Clarification/Update
For the sake of simplicity, I want to keep using phpMyAdmin. I am currently using XAMPP, which is easy enough to let me focus on the PHP/CSS/Javascript, and it comes with phpMyAdmin.
Also, although I haven't been able to set up explicit foreign keys yet, I do have a relational table and can perform joins like this:
SELECT *
FROM foo
INNER JOIN foo_bar
ON foo.id = foo_bar.foo_id
INNER JOIN bar
ON foo_bar.bar_id = bar.id;
It just makes me uncomfortable not to have the FKs explicitly defined in the database.
Source: (StackOverflow)
I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
How can I fix this? I am unable to open LAMP, uninstall it or reinstall it.
Source: (StackOverflow)
This question already has an answer here:
I work on my wamp for localhost backend development everyday.
I feel annoyed by phpmyadmin auto log out out quickly. Is there any way I could get rid of this or extend the timeout?
Where can I set this timeout value?
Source: (StackOverflow)
you have been of terrific help today. I am on my way to learn PHP with MySQL and unexpectedly got stuck while dropping the database.
Basically, I was taught on how to create a root password using the "mysqladmin -u root -p password" command, this was done all through the windows command editor. Now, the next process was to display the default databases (info. schema, mysql and test) which was achieved by using "SHOW DATABASES;"
But according to the book, we had to delete the redundant test file and the following error pops up:
Error Dropping Database (Can't rmdir '.test\', errno: 17)
The command put to use was DROP DATABASE test;
I am using MYSQL and PHPMYADMIN. Any help on how to drop the file with no errors?
Source: (StackOverflow)
I was suggested, not long ago, to change my code to use PDO in order to parameterize my queries and safely save HTML in the database.
Well, here are the main problems:
I looked at http://php.net/manual/en/ref.pdo-mysql.php and I don't really get where I should put that $ ./configure --with-pdo-mysql string...
The site I'm building actually only requires PDO for one page. While I may consider re-writing it, it would take a while and I need the pages to be running soon, so I can't turn off MySQL completely. If I do install PDO, will I still be able to use mysql_* handlers?
The server in question is running PHP Version 5.4.6-1ubuntu1 and apache/2.2.22 (Ubuntu). I'm also running a PHPMyAdmin database, if it matters.
Source: (StackOverflow)