I use PHPMyAdmin for convenience in updating a remote database. But it doesn't show warnings, by default, which recently got me into some embarrassing trouble where I was updating a SET field with string not on its list and not noticing the problem. I'm using 2.11.9.1 (Dreamhost's default install). On the PHPMyAdmin wiki it lists "Di...
My colleagues and I are looking for alternative client tools for Mac OS X. I tend to prefer the text-based interface and we have PHPMyAdmin installed on our development servers (Linux). What are your recommendations? (One recommendation per answer please, so people can up-mod individual recommendations). ...
It seems to me that phpMyAdmin imports tables by default with collation latin1_swedish_ci, how i change this? ...
I have Windows 2003 Standard, IIS 6, PHP, MySQL and amy trying to get mcrypt working so I can use phpMyAdmin. I have uncommended php_mcrypt.dll in php.ini and this file is in my extensions folder (c:\php). I have downloaded libmcrypt.dll to c:\php, c:\php\ext, c:\windows, c:\windows\system32. I have also found a second version of this ...
Hello, I've make an application in php that uses DOMDocument() in php 5. The problem is that my server uses php4 and DOM object is not recognized. What can I do? Can I download any kind of software and put it in my server and use include? wich one? Thanks a lot. ...
I am creating a new table inside mysql and I am trying to add a foreign key constraint to one of the fields. CREATE TABLE `onlineorder` ( `receiptid` varchar(10) NOT NULL default '', `delivereddate` date default NULL, `cid` int(10) NOT NULL, `card#` int(10) default NULL, `expire` date default NULL, PRIMARY KEY (`receiptid`...
when i point my browser to http://localhost/phpmyadmin, instead of showing me its front page, it comes up with save as dialog. I'm running: Apache/2.2.3 (Debian) PHP/5.2.0-8+etch13 Server I've reinstalled both apache2 and php5. After re-install i don't have httpd.conf file, how can i get it back? Is there a standard file which i can ju...
I may be barking up the wrong tree... However, what I have is a MySQL server that accepts connections only from a client with a valid SSL cert (see this link). This works great for example with Rails. I have my database on one server, and a Rails app that connects using the client certificate. Maybe not the fastest, but it works. The co...
okee, i followed all instructions i could find here and i could display all kinds of multilingual characters on my pages... the problem is in phpmyadmin the japanese characters are replaced by question marks, as in a bunch of ???? ??? pieced together i think there's a problem with my database's collation but i just wanted to verify that ...
I'm migrating my WordPress blog and phpBB Forum into a new hosting server. I am using phpMyAdmin to import the SQL script from the database in the previous site. When I open the .sql script with Kate, it says it uses UTF8 as encoding. When I import the sql in the new server, I have the option in phpMyAdmin to choose the encoding, where...
Dear all, I am developing PHP/Mysql application using vertrigoserver, I need to enter the german text in Tables,The Problem is when i read the tables from php, some of character didnt show the exact typed one,Do i need additional steps to display all characters Effectively? ...
I'm working on a script that sadly I inherited - with no commenting or anything. Argh! For testing purposes I duplicated one of the tables in the database which had an auto-incrementing ID. When the data is saved to the database, though, the ID number just reads "0" -- which is the default for that column. I'm not sure why it's not auto...
if my host does not allow me to upload a file directly to my mysql folder and i can only do so throught phpmyadmin? are there any alternatives aside from its native import feature so that my connection would not time out while uploading a query that's around 8mb? ...
I created a field in my table and set it as the index but I can't get it to increase on it s own when a new item is added. How do I do make it do this through PHPMyAdmin? ...
I have encountered this problem a couple of times, in the last few days. So, it happens occasionally. I have setup mysql on a remote machine, and there is a java program on another machine querying the database to read and write records every few seconds. I am using phpMyAdmin to administer my database. And, at times, after running som...
Is there any webbased interface for MySQL better than phpMyAdmin? I use phpMyAdmin a lot but it is becoming a pain, especially it is slow sometimes. I'd like to have deep export functionality like phpMyAdmin but more design features ...
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 fo...
I have just installed phpMyAdmin on my new Fedora Core 10 dedicated server. I downloaded the phpMyAdmin-3.1.2-english.tar.gz. I extracted it and placed it in this folder /opt/phpMyAdmin-3.1.2-english and i created a symbolic link in the /var/www/html directory so that I can access it like this: http://www.mydomainname.com/webdb. When I...
How do you change the password for the root user in phpMyAdmin on WAMP server? because I'm locked out of phpMyAdmin, after changing the password incorrectly. ...
I trying to code a login script for phpmyadmin <?php $user = "Domain"; $passwords = file("passwords.txt"); foreach ( $passwords as $pass){ $source = file_get_contents("http://dbadmin.one.com/index.php?lang=en&server=1&pma_username=$user&pma_password=$pass"); if(preg_match("/Database/", $source)): echo "Login Worked wit...