RE: phpMyAdmin and other management tools
I personally use SQLYog, and as for it not having the query creation... it has a fairly decent query builder, but it is in the paid version, not the community one. I like all the features it has, and I use most of them. Granted, it is always a good idea to know how to use the command line, just incase you're locked out of it somehow, or if you need to repair, backup or create users. But if you're a windoze user, 99% of them don't know what a command line is :) Steven Staples -Original Message- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: July 1, 2010 7:58 AM To: David Stoltz Cc: mysql@lists.mysql.com Subject: Re: phpMyAdmin and other management tools Hi Dave, I recommend you to use Toad for MySQL. It has wizard for query creation phpMyAdimn, mysql workbench, sqlyog lack this feature. Krishna On Thu, Jul 1, 2010 at 5:08 PM, David Stoltz dsto...@shh.org wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is mySQL Workbench, which I haven't really fooled with yet Can anyone comment on what they use and why? Thanks! Dave No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.830 / Virus Database: 271.1.1/2972 - Release Date: 06/30/10 02:36:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: phpMyAdmin and other management tools
Folks - I've check out several application people have suggested. I LOVE Toad for mySQL, and Spotlight for mySQL. Thanks for all the advice! -Original Message- From: Steven Staples [mailto:sstap...@mnsi.net] Sent: Friday, July 02, 2010 8:22 AM To: mysql@lists.mysql.com Subject: RE: phpMyAdmin and other management tools I personally use SQLYog, and as for it not having the query creation... it has a fairly decent query builder, but it is in the paid version, not the community one. I like all the features it has, and I use most of them. Granted, it is always a good idea to know how to use the command line, just incase you're locked out of it somehow, or if you need to repair, backup or create users. But if you're a windoze user, 99% of them don't know what a command line is :) Steven Staples -Original Message- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: July 1, 2010 7:58 AM To: David Stoltz Cc: mysql@lists.mysql.com Subject: Re: phpMyAdmin and other management tools Hi Dave, I recommend you to use Toad for MySQL. It has wizard for query creation phpMyAdimn, mysql workbench, sqlyog lack this feature. Krishna On Thu, Jul 1, 2010 at 5:08 PM, David Stoltz dsto...@shh.org wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is mySQL Workbench, which I haven't really fooled with yet Can anyone comment on what they use and why? Thanks! Dave No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.830 / Virus Database: 271.1.1/2972 - Release Date: 06/30/10 02:36:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dsto...@shh.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: phpMyAdmin and other management tools
I prefer the good old command line. ~~Fish~~ On Jul 1, 2010 7:38 AM, David Stoltz dsto...@shh.org wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is mySQL Workbench, which I haven't really fooled with yet Can anyone comment on what they use and why? Thanks! Dave
Re: phpMyAdmin and other management tools
Hi Dave, I recommend you to use Toad for MySQL. It has wizard for query creation phpMyAdimn, mysql workbench, sqlyog lack this feature. Krishna On Thu, Jul 1, 2010 at 5:08 PM, David Stoltz dsto...@shh.org wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is mySQL Workbench, which I haven't really fooled with yet Can anyone comment on what they use and why? Thanks! Dave
Re: phpMyAdmin and other management tools
On Thu, 2010-07-01 at 07:38 -0400, David Stoltz wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is mySQL Workbench, which I haven't really fooled with yet command line (mysql prompt etc) and phpmyadmin. command line perfect for quick instructions phpmyadmin for its ease with larger DB structures, also, most users wont have command access and its simple for them, it also doesn't require you to install anything on your machine, I've tried a few in the past, but none of them match up to phpmyadmin, and Marc (its author) is always very approachable. Cheers
Re: phpMyAdmin and other management tools
http://mysqlonlinehelp.wordpress.com/2010/06/30/tools-for-mysql-database/ regards, Nilnandan Noel Butler wrote: On Thu, 2010-07-01 at 07:38 -0400, David Stoltz wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is mySQL Workbench, which I haven't really fooled with yet command line (mysql prompt etc) and phpmyadmin. command line perfect for quick instructions phpmyadmin for its ease with larger DB structures, also, most users wont have command access and its simple for them, it also doesn't require you to install anything on your machine, I've tried a few in the past, but none of them match up to phpmyadmin, and Marc (its author) is always very approachable. Cheers
Re: phpMyAdmin and other management tools
You can also explore : http://kontrollsoft.com/software-kontrollbase On Thu, Jul 1, 2010 at 5:47 PM, Nilnandan Joshi nilnand...@synechron.comwrote: http://mysqlonlinehelp.wordpress.com/2010/06/30/tools-for-mysql-database/ regards, Nilnandan Noel Butler wrote: On Thu, 2010-07-01 at 07:38 -0400, David Stoltz wrote: Hi Folks, I'm currently using phpMyAdmin to manage the mySQL databases. I'm wondering what most people like to use? I know there is mySQL Workbench, which I haven't really fooled with yet command line (mysql prompt etc) and phpmyadmin. command line perfect for quick instructions phpmyadmin for its ease with larger DB structures, also, most users wont have command access and its simple for them, it also doesn't require you to install anything on your machine, I've tried a few in the past, but none of them match up to phpmyadmin, and Marc (its author) is always very approachable. Cheers -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
Re: phpMyAdmin links?
Is there a way to have a permalink to pages in phpMyAdmin, particularly record editing pages? I successfully did it -- for a while -- by simply copying the URL when I was on a record editing page and replacing the obvious key GET parameter with a variable. But that URL has a GET parameter called token with an opaque identifier that I'll bet is a session handle. You can't go to the record without it, and if it's included, it stops working after some period of time. I'm doing some custom web database work, and for debug and admin purposes only, I want to create a link whenever a primary key is shown that will allow let me at the raw data, dammit editing. Thanks for whatever help you can offer, including suggesting a different list or approach or tool. (I haven't looked for a phpMyAdmin list yet.) The light at the end of the tunnel is a man with a flashlight yelling, Go back! Go back! -- Sol Stein Jan Steinman http://www.VeggieVanGogh.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: phpmyadmin problems with quoting exported text
Which version? Which export type? Strings TEXT, VARCHAR would be quoted. INT would not, I think. Their forum might be a better place. www.phpmyadmin.net. 2wsxdr5 wrote: I just tried to use the output of the export function on phpmyadmin and got a million errors. After looking at the file I found that certain columns that are strings were not quoted at all. I can't find any reason why some are and some are not quoted. Anyone have any idea why this is happening? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin problems with quoting exported text
John Taylor-Johnston wrote: Which version? Which export type? Strings TEXT, VARCHAR would be quoted. INT would not, I think. Their forum might be a better place. www.phpmyadmin.net. I am using phpMyAdmin 2.6.1-rc. I have no control over that as I am not the admin on the server. All the columns I am talking about are varchar. Some get quoted and some do not. Also some integer columns get quoted for some reason I am unaware of. With out quoting the strings it makes the output worthless. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin 2.5.4 login in ERROR!
That is as follow: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client Hi Zhu, have a look at http://dev.mysql.com/doc/mysql/en/old-client.html Basically, you should keep on using the pre 4.1 authentication mechanism if you have to use the php mysql extension (as phpMyAdmin does) Hope it helps. Sorry for my poor English -- Ciao Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin 2.5.4 login in ERROR!
On Apr 5, 2005, at 6:41 AM, Nico Alberti wrote: That is as follow: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client Hi Zhu, have a look at http://dev.mysql.com/doc/mysql/en/old-client.html Basically, you should keep on using the pre 4.1 authentication mechanism if you have to use the php mysql extension (as phpMyAdmin does) Or build php from source, linking against the mysql 4.1 client library. Hope it helps. Sorry for my poor English -- Ciao Nico Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
At 08:15 AM 3/13/2005, you wrote: Hi All, have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and changed the url path like below, but, when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration Documentation http://localhost/phpMyAdmin-2.6.1-pl3/Documentation.html#faqmysql /** * Your phpMyAdmin url * * Complete the variable below with the full url ie http://localhost/phpMyAdmin-2.6.1-pl3/ * What am I mising.? Cheers. This probably isn't the problem in itself, but I thought I might share this with you. But here is how mine is setup: $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpmyadmin/'; That just assures me that I can use the IP address or domain name without it giving me a problem and I can also move the directory to another server without having to change this line each time. Where mine has /phpmyadmin/, you will of course need to change that to the directory it is in. Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Hassan Schroeder wrote: Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? Hi All, where do I input phpinfo(), browser or terminal..? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Steve Buehler wrote: At 08:15 AM 3/13/2005, you wrote: Hi All, have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and changed the url path like below, but, when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration Documentation http://localhost/phpMyAdmin-2.6.1-pl3/Documentation.html#faqmysql /** * Your phpMyAdmin url * * Complete the variable below with the full url ie http://localhost/phpMyAdmin-2.6.1-pl3/ * What am I mising.? Cheers. This probably isn't the problem in itself, but I thought I might share this with you. But here is how mine is setup: $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpmyadmin/'; That just assures me that I can use the IP address or domain name without it giving me a problem and I can also move the directory to another server without having to change this line each time. Where mine has /phpmyadmin/, you will of course need to change that to the directory it is in. Steve Hi All, Steve, below is how It looks after your suggestions, but, still with the same errors. Cheers. Mark Sargent. /** * Your phpMyAdmin url * * Complete the variable below with the full url ie * http://localhost/phpMyAdmin-2.6.1-pl3/ * * It must contain characters that are valid for a URL, and the path is * case sensitive on some Web servers, for example Unix-based servers. * * In most cases you can leave this variable empty, as the correct value * will be detected automatically. However, we recommend that you do * test to see that the auto-detection code works in your system. A good * test is to browse a table, then edit a row and save it. There will be * an error message if phpMyAdmin cannot auto-detect the correct value. * * If the auto-detection code does work properly, you can set to TRUE the * $cfg['PmaAbsoluteUri_DisableWarning'] variable below. */ $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpMyAdmin-2.6.1-pl3/'; /** * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set * You should use this if and ONLY if the PmaAbsoluteUri auto-detection * works perfectly. */ $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Mark Sargent wrote: Hassan Schroeder wrote: Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? Hi All, where do I input phpinfo(), browser or terminal..? Cheers. Mark Sargent. Hi All, disregard that..Below is the start of the info displayed with phpinfo() in the browser. Cheers. phpinfo (PHP 3, PHP 4 , PHP 5) phpinfo -- Outputs lots of PHP information Description int *phpinfo* ( [int what] ) I'm figuring you wanted to know if php was working, yes..? I had already tested it, and it was. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Mark Sargent wrote: where do I input phpinfo(), browser or terminal..? Cheers. Either create a Web page with this in it: ?php phpinfo(); ? or if you have CLI (running `which php` returns something), just `php -i` will get you a long, not-too-formatted listing of what's compiled in your PHP installation. -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
If your php was built with mysql support, there will be a mysql section in the output of phpinfo(). Given your error message, I'd guess your php was not built with mysql support. Michael Mark Sargent wrote: Mark Sargent wrote: Hassan Schroeder wrote: Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? Hi All, where do I input phpinfo(), browser or terminal..? Cheers. Mark Sargent. Hi All, disregard that..Below is the start of the info displayed with phpinfo() in the browser. Cheers. phpinfo (PHP 3, PHP 4 , PHP 5) phpinfo -- Outputs lots of PHP information Description int *phpinfo* ( [int what] ) I'm figuring you wanted to know if php was working, yes..? I had already tested it, and it was. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
At 08:59 AM 3/13/2005, you wrote: Steve Buehler wrote: At 08:15 AM 3/13/2005, you wrote: Hi All, have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and changed the url path like below, but, when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration Documentation http://localhost/phpMyAdmin-2.6.1-pl3/Documentation.html#faqmysql /** * Your phpMyAdmin url * * Complete the variable below with the full url ie http://localhost/phpMyAdmin-2.6.1-pl3/ * This probably isn't the problem in itself, but I thought I might share this with you. But here is how mine is setup: $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpmyadmin/'; That just assures me that I can use the IP address or domain name without it giving me a problem and I can also move the directory to another server without having to change this line each time. Where mine has /phpmyadmin/, you will of course need to change that to the directory it is in. Steve, below is how It looks after your suggestions, but, still with the same errors. Cheers. $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpMyAdmin-2.6.1-pl3/'; $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; The link it gave you to look at the documentation has the following info: begin cut and paste-- [1.20] I receive the error cannot load MySQL extension, please check PHP Configuration. To connect to a MySQL server, PHP needs a set of MySQL functions called MySQL extension. This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called PHP-MySQL or something similar. end cut and paste Are you running this on windows or linux? I am running all of mine on RedHat 9, RHEL ES 3 RHEL ES 4 using rpms to install everything. So the version of PHP-MySQL that I am running on my RedHat 9 is php-mysql-4.2.2-17.2. Do you have the php-mysql installed if you are running on linux? If you are running on Windows...do you have php_mysql.dll installed? Can you connect to your database from ANY of your php scripts? Or is this the only one you can't connect from? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Mark Sargent wrote: I'm figuring you wanted to know if php was working, yes..? No, I wanted to know if your PHP was compiled with MySQL support. It doesn't have to be, and in your case seems it probably *isn't*. But we still don't know :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Hassan Schroeder wrote: Mark Sargent wrote: I'm figuring you wanted to know if php was working, yes..? No, I wanted to know if your PHP was compiled with MySQL support. It doesn't have to be, and in your case seems it probably *isn't*. But we still don't know :-) Hi All, guys, I'm using Fedora3(sorry for not saying that earlier). I had problems with the rpm install of MySQL, so, went with installing the tar file. I installed php via yum, though. I did a rpm -q php-mysql which showed it not installed. I then did a yum install php-mysql which showed the following, [EMAIL PROTECTED] ~]# yum install php-mysql Setting up Install Process Setting up Repo: dag repomd.xml100% |=| 1.1 kB00:00 Setting up Repo: base repomd.xml100% |=| 1.1 kB00:00 Setting up Repo: updates-released repomd.xml100% |=| 951 B00:00 Reading repository metadata in from local files dag : ## 1932/1932 base : ## 2622/2622 primary.xml.gz100% |=| 298 kB00:09 MD Read : ## 706/706 updates-re: ## 706/706 Resolving Dependencies -- Populating transaction set with selected packages. Please wait. --- Downloading header for php-mysql to pack into transaction set. php-mysql-4.3.10-3.2.i386 100% |=| 15 kB00:01 --- Package php-mysql.i386 0:4.3.10-3.2 set to be installed -- Running transaction check -- Processing Dependency: libmysqlclient.so.10 for package: php-mysql -- Restarting Dependency Resolution with new changes. -- Populating transaction set with selected packages. Please wait. --- Package mysql.i386 0:3.23.58-14 set to be installed -- Running transaction check -- Processing Dependency: perl-DBD-MySQL for package: mysql -- Restarting Dependency Resolution with new changes. -- Populating transaction set with selected packages. Please wait. --- Downloading header for perl-DBD-MySQL to pack into transaction set. perl-DBD-MySQL-2.9003-5.i 100% |=| 5.3 kB00:00 --- Package perl-DBD-MySQL.i386 0:2.9003-5 set to be installed -- Running transaction check Dependencies Resolved Transaction Listing: Install: php-mysql.i386 0:4.3.10-3.2 Performing the following to resolve dependencies: Install: mysql.i386 0:3.23.58-14 Install: perl-DBD-MySQL.i386 0:2.9003-5 Is this ok [y/N]: y Downloading Packages: php-mysql-4.3.10-3.2.i386 100% |=| 32 kB00:01 perl-DBD-MySQL-2.9003-5.i 100% |=| 111 kB00:00 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: mysql 100 % done 1/3 Installing: php-mysql 100 % done 2/3 Installing: perl-DBD-MySQL 100 % done 3/3 Installed: php-mysql.i386 0:4.3.10-3.2 Dependency Installed: mysql.i386 0:3.23.58-14 perl-DBD-MySQL.i386 0:2.9003-5 Complete! It looks to have re-installed mysql again. Does this mean I now have the mysql database installed 2 times..? Seems like it, yes..? Now, 2 things I need to ask, 1. How do I determine whether I need to configure php to work with mysql and 2. how do I actually configure if needed.? Cheers. P.S. After the yum install and an updatedb I did a search for php-mysql via which wheris and locate, below is the results. [EMAIL PROTECTED] ~]# updatedb [EMAIL PROTECTED] ~]# which php-mysql /usr/bin/which: no php-mysql in (/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin) [EMAIL PROTECTED] ~]# whereis php-mysql php-mysql: [EMAIL PROTECTED] ~]# locate php-mysql /var/cache/yum/updates-released/packages/php-mysql-4.3.10-3.2.i386.rpm /var/cache/yum/updates-released/headers/php-mysql-4.3.10-3.2.i386.hdr Hope I've given enuff info this time. Cheers, again. (Oh, btw, I'm not a php programmer etc, I'm just doing this so I can say to a future employer, yes, I can install/setup/config php/mysql etc if you need it). Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin don't show table size
Update phpMyAdmin. Santino At 12:33 + 12-11-2004, Dilipan Sebastiampillai wrote: Hello, after restoring from a mysqldump I use phpMyAdmin to view my database but the size field is unknown ... how could I get a size display ? -- Dilipan Sebastiampillai -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin and MySQL 4.1
On Oct 27, 2004, at 10.26, Schalk Neethling wrote: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com i struggled w/ this for a while, before learning that even though i had mysql 4.1 installed, php4 was being compiled w/ it's own built-in mysql libraries, which are pre-4.1, hence the error. compiling php5 will solve the problem, as it's included mysql libraries are apparently newer, or compiling php4, and pointing configure to your mysql libraries (--with-mysql=/path/to/mysql) will also work. -ben -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin and MySQL 4.1
i struggled w/ this for a while, before learning that even though i had mysql 4.1 installed, php4 was being compiled w/ it's own built-in mysql libraries, which are pre-4.1, hence the error. compiling php5 will solve the problem, as it's included mysql libraries are apparently newer, or compiling php4, and pointing configure to your mysql libraries (--with-mysql=/path/to/mysql) will also work. FWIW, I have been using PHP5 for a while now with MySQL 4.1.14-gamma. If I compile PHP5 with MySQL 4.1.14 libraries things go crazy and I get reproducible and strange errors during queries. Compile PHP5 against the old MySQL 4.0.x libraries and everything is ok. Everything works fine and you end up with a working apache/php that works just fine accessing a running 4.1.14 MySQL. I have not tried compiling against 4.1.17 (production) so my comments may be irrelevant but I HTH you in case the problem is not yet fixed and you do decide to try compiling PHP5 against MySql 4.1.x. I did have to change my default collation in phpMyAdmin when I upgraded to 4.1 via the PMA front page. Andrew. --- btb [EMAIL PROTECTED] wrote: On Oct 27, 2004, at 10.26, Schalk Neethling wrote: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com i struggled w/ this for a while, before learning that even though i had mysql 4.1 installed, php4 was being compiled w/ it's own built-in mysql libraries, which are pre-4.1, hence the error. compiling php5 will solve the problem, as it's included mysql libraries are apparently newer, or compiling php4, and pointing configure to your mysql libraries (--with-mysql=/path/to/mysql) will also work. -ben __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin and MySQL 4.1
You need to get caught up on your reading. The password hash changed as of 4.1 and this behavior is well documented. Start here: http://dev.mysql.com/doc/mysql/en/Problems.html and if you have more questions read this http://dev.mysql.com/doc/mysql/en/Password_hashing.html What it boils down to is that you are using pre-4.1 clients (phpMyAdmin is a MySQL client) with a 4.1+ server. Several workaround are in the reading I just gave you. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Schalk Neethling [EMAIL PROTECTED] wrote on 10/27/2004 10:26:09 AM: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin and MySQL 4.1
Op woensdag 27 oktober 2004 16:52, schreef [EMAIL PROTECTED]: I had the same problem on my Linux suse 9.1 box. I was using a mysql client/server that came with my distro. Got the same error as you trying to connect with phpmyadmin, while I was sure to have installed the proper client (4.1) via rpm (and deleted the 4.0 one). I also read the passw hashing documentation and followed their instructions, with no result. After a while I was getting sick of all the new errors (probably due to myself ;), so I decided to start over from scratch. At the same time I could upgrade to php5 and Apache 2.0 What I did: - deleting all mysql stuff through my package manager (Yast for SUSE) - deleting my apache webserver - deleting PHP4.3 Afterwards: - installed mysql 4.1 client, server and shared rpm's - compiled apache - compiled php5 And I was having the latest lamp working. Phpmyadmin runs without problems Notes: - this was on my development machine - I'm not pushing mysql to the end when I use it (in a basic way) - maybe not the nicest solution, but digging 2 days through documentation isn't nice either. - I got my lamp working in less then 2 hours. Rik You need to get caught up on your reading. The password hash changed as of 4.1 and this behavior is well documented. Start here: http://dev.mysql.com/doc/mysql/en/Problems.html and if you have more questions read this http://dev.mysql.com/doc/mysql/en/Password_hashing.html What it boils down to is that you are using pre-4.1 clients (phpMyAdmin is a MySQL client) with a 4.1+ server. Several workaround are in the reading I just gave you. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Schalk Neethling [EMAIL PROTECTED] wrote on 10/27/2004 10:26:09 AM: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin and MySQL 4.1
Hi. See: http://www.phpmyadmin.net/documentation/#faqmysqlversions Regards. Schalk Neethling [EMAIL PROTECTED] wrote: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin does not show mysql-db, MacOS
At 0:48 h +0200 2004.07.20, Peter Paul Sint wrote: After installing mysql4.1 on Mac OS 10.2.8 mysql-standard-4.1.3-beta-apple-darwin6.8-powerpc php and phpMyAdmin 2.5.7-pl1 (following the tutorial http://www.macservers.org/feature-2.html ) Using http://localhost/phpMyAdmin/index.php (or with my absolute URL instead localhost) I get: Welcome to phpMyAdmin 2.5.7-pl1 - Login Language: English (in popup) The configuration file now needs a secret passphrase (blowfish_secret). but no database or login field is shown. (I did not touch anything with blowfish) I should have done so: After rereading the comments config.inc.php more carefully I found that mysql4.1.3beta needs a blowfish passphrase if one uses at least one cookie auth-type. My tutorial did not know about this (yet). The addition of blowfish seems to be new in 4.1 or later (its a beta). After inserting a blowfish passphrase in config.inc.php it works :-) Some uncertainties with installing php on 10.2: The installer Entropy-PHP-4.3.4-2.dmg has not enabled: AddModule mod_php4.c LoadModule php4_modulelibexec/httpd/libphp4.so actually I found that the installer from Marc Linyage http://www.entropy.ch/software/macosx/php/ created an additional config file /usr/local/php/httpd.conf.php //Additional PHP apache directives which contains just above AddModule, LoadModule commands. Thanks to Wesley Furgiuele who wrote off list. -- Peter Sint [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin screw up
seems like you set the mysql root passwd which is the right thing to do. now should connect as follows: # /usr/local/mysql/bin/mysql -u root -p Saqib Ali - http://validate.sf.net --- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, joffrey leevy wrote: Hi all: I was trying to use phpmyadmin for the first time and messed up when trying to give the [EMAIL PROTECTED] a password. I did that because phpmyadmin told me something about lax security using root with no password. Anyhow something went wrong. Now I can't do anything with phpadmin or mysql client. The message is - Error 1045: Access Denied for User: (Using Password:No). Grateful for anyone's help. Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin request problem
On Thu, 25 Sep 2003 10:11:27 +0200 (CEST) Artem Batoussov [EMAIL PROTECTED] wrote: The first part has been generated by phpMyAdmin and I've just added CHARACTER SET koi8r COLLATION koi8r_general_ci like it's done in the example from this doc : http://www.mysql.com/documentation/mysql/bychapter/manual_Charset.html#Charset-cyrillic-sets . But I have a syntaxe error in this part of code ! Which is it ? please, tell us what error message do you get and your version of MySQL server. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PhpMyadmin
Hi, I want to install phpMyAdmin on my windows 2000 box. Whare can I find the PhpMyAdmin software to download. http://www.phpmyadmin.net/ Google would have found that for you in seconds, it's the first result for a search for phpmyadmin. With all due respect, you really should try a little harder to find the answer yourself first before posting to a list about it. HTH David P -- David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyadmin
Quick one... is this program just for Linux? I think not. As long as you have mysql and apache/php running it can run on any unix os i think. Take out the word 'unix' and you'll be right. If you can get a PHP environment (doesn't necessarily require Apache to be the web server) and MySQL, myPHPAdmin will work. Peter. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyadmin
I think not. As long as you have mysql and apache/php running it can run on any unix os i think. -- Thank you, Louie Miranda ([EMAIL PROTECTED]) - Original Message - From: Michael G. Tracey [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:59 PM Subject: phpMyadmin Quick one... is this program just for Linux? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHPMYADMIN and Foreign Keys
Hi Brian, You understand that (at present) you will need to use Innodb tables if you want or already use Foreign key support ? O.K , just making sure you didn't miss that. I can give you only advice how to do it in the mysql command line client. Please login to the mysql command line client to execute the following programs. Use SHOW INDEX FROM tblname; to see all indexes specified. Use SHOW CREATE tblname to see the create statement for a table (including the indexes). I assume you are confortable on the command line, so I dont include the screen output here as it wraps rather ugly in an e-mail. Best regards Nils Valentin Tokyo/Japan 2003 7 11 22:59Brian Rivet : Hi Everyone, I'm using PHPMyAdmin to set up the database for a website, and I am trying to set up foreign keys between tables. I know that MySQL doesn't enforce them, but I want them there as part of the schema anyway. I tried executing the command to add the foreign key, it ran without any error, but I don't see any indication that the foreign key exists as part of the schema now. Is there a command either in PHPMyAdmin or MySQL that will show me which fields are foreign keys, and where they point to? I just want to make sure I set them up right. Thanks, Brian Rivet -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHPMYADMIN and Foreign Keys
Hi Brian, thats fine. You can always convert between the different table formats. As long as you know some rules there will be no data loss. As mentioned at the present only innodb support foreign keys. That means that converting a innodb table f.e to another table format should either give you an error message or silently ignore the foreign keys. Anyway I suggest not experiencing not on the real data tables ( WOW - I guess you didnt new that ;-) - just wanted to make sure it's in the record ;-). You will have to setup all foreign keys by yourself, mysql will not do that for you automatically. I am unable at present to give any advice on the PHP side. Best regards Nils Valentin Tokyo/Japan 2003 7 11 23:41Brian Rivet : Hi Nils, I wasn't actually aware of this, but I don't plan to use MySQL to enforce the foreign keys, I just want them there as part of the schema in case the database needs porting to another system. I will do all of the enforcement in PHP. I just wanted to see if it was actually setting up the foreign key in the database somewhere. Thanks, Brian -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re; phpMyAdmin
I'm having problems getting phpMyadmin to work with MySQL. Using the following: RH7.3 completely patched MySQL-3.23.54a-3.73 php-4.1.2-7.3.6 phpMyAdmin-2.1.0-1 There is a setting in config.inc.php3 that you are supposed to set to the complete path to your phpMyAdmin. I've set mine as such, is this correct? $cfg['PmaAbsoluteUri'] http://192.168.1.11/var/www/html/phpMyAdmin/ No matter what I try I get The connection was refused when attempting to contact 192.168.1.11. Can someone please help. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin
Open http://your.server.name/phpMyAdmin-2.*.*/Documentation.html#setup. If you read the docs (#3 in the initial Quick Install section tells you that the file you'll be editing is config.inc.php, in the phpMyAdmin root dir), you'll just be stepped through a simple series of table creations and editing of config.inc.php (which is trivial). -- Barry Marler Plant Genome Mapping Laboratory University of Georgia Room 229, C A G T 111 Riverbend Road Athens, GA 30602 (706)583-0164(office) (706)583-0160(fax) http://www.plantgenome.uga.edu -Original Message- From: Stephen Tiano [mailto:[EMAIL PROTECTED] Sent: Saturday, March 08, 2003 3:29 PM To: [EMAIL PROTECTED] Subject: phpMyAdmin Anyone familiar with the GUI interface for MySQL/PHP called 'phpMyAdmin'? I'm at a point in my intensive self-study via books, tutorials, and exercises where one of the books I'm working with--trying to tie together with my graphical HTML editor--Dreamweaver: PHP Development--suggests phpMyAdmin is worth knowing as a tool for more efficient work in a production environment. When I get phpMyAdmin to show up in my browser, it looks pretty much the way the book shows it. Except that, after a few lines that are word-for-word with the book, in place of [bullet] Run SQL query/queries on ... and a flexible field in which to type in said queries, I have an error message: [bullet] Error The additional Features for working with linked Tables have been deactivated. To find out why, click here. Clicking 'here' brings me to a link to 'Documentation' and a line underneath saying 'General relation features Disabled'. Clicking on 'Documentation' brings me to what looks vaguely like directions for altering various '$cfg' strings. Needless to say, I'm leery. I'm not certain where to find these strings to alter. But more importantly, I'm not clear on what I'm being told to do. It's not as if the directions are step-by-step for a novice. And it doesn't spell out whether this will address the 'General features' being 'Disabled'. That is, will it make these 'General features' functional? May I ask your help in doping this out? Thank you. Steve Tiano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyadmin
Has a quick overview of installation : http://www.php.net/manual/en/ref.mysql.php A whole load more tutorials : http://www.domaincarecenter.com/php_programming_tutorials.htm Jerry - Original Message - From: agc [EMAIL PROTECTED] To: KH Chiu [EMAIL PROTECTED] Cc: Jon Miller [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 8:46 AM Subject: phpMyadmin I have downloaded phpmyadmin, and installed, well not really, I placed it under /var/www/html, and decompressed therr, it generated its own directory, and so, well I am getting an error msg: cannot load MySQL extension, please check PHP Configuration. when I check the docs I get this solution To connect to a MySQL server, PHP needs a set of MySQL functions called MySQL extension. This extension may be part of the PHP server (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or mysql.dll. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called PHP-MySQL or something similar. so from where can I download this PHP-MySQL? or where can I get mysql.so? and how do I tell php to load it? thanks in advance. another qquestin and please for give me in advance, but this is something I .. well which is mysql adminniistrative uuser? is it mysql? I am running linnux rethat 8, and installed mysql from the disctibution cd rom. I ask this because in thee installation instructions for phpmyadmin says that I have to type the root myslq user name and mysql host is mysql host localhost? thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyadmin
Are you using a RedHat system. In RedHat system does not install php mysql support by default. You may install php-mysql rpm from redhat distribution disks. Regards, -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com I have downloaded phpmyadmin, and installed, well not really, I placed it under /var/www/html, and decompressed therr, it generated its own directory, and so, well I am getting an error msg: cannot load MySQL extension, please check PHP Configuration. when I check the docs I get this solution To connect to a MySQL server, PHP needs a set of MySQL functions called MySQL extension. This extension may be part of the PHP server (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or mysql.dll. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called PHP-MySQL or something similar. so from where can I download this PHP-MySQL? or where can I get mysql.so? and how do I tell php to load it? thanks in advance. another qquestin and please for give me in advance, but this is something I .. well which is mysql adminniistrative uuser? is it mysql? I am running linnux rethat 8, and installed mysql from the disctibution cd rom. I ask this because in thee installation instructions for phpmyadmin says that I have to type the root myslq user name and mysql host is mysql host localhost? thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyadmin
did you compile phpmyadmin from source if so then there should be a couple of switches that you can add to pick up the mysql libraries check under the installed directory and do a ./configure --help and have a look at the options as for the php-mysql library here is the tarball try and compile it and see what you get, hope this helps http://www.claws-and-paws.com/[..]ware/php-mysql-lib/php-mysql-lib-0.5.tgz cheers David Ziggy Lubowa Network Engineer One2net (U) web: www.one2net.co.ug Tel: +256 41 345466 --- Every minute is an occasion to change your life -Original Message- From: agc [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 11:46 AM To: KH Chiu Cc: Jon Miller; [EMAIL PROTECTED] Subject: phpMyadmin I have downloaded phpmyadmin, and installed, well not really, I placed it under /var/www/html, and decompressed therr, it generated its own directory, and so, well I am getting an error msg: cannot load MySQL extension, please check PHP Configuration. when I check the docs I get this solution To connect to a MySQL server, PHP needs a set of MySQL functions called MySQL extension. This extension may be part of the PHP server (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or mysql.dll. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called PHP-MySQL or something similar. so from where can I download this PHP-MySQL? or where can I get mysql.so? and how do I tell php to load it? thanks in advance. another qquestin and please for give me in advance, but this is something I .. well which is mysql adminniistrative uuser? is it mysql? I am running linnux rethat 8, and installed mysql from the disctibution cd rom. I ask this because in thee installation instructions for phpmyadmin says that I have to type the root myslq user name and mysql host is mysql host localhost? thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyadmin
Or is there another product that can manage a MySQL database from either a Windows or Linux laptop/desktop. I'm sure there are many products that do this. My favorite is mysqltool. We switched from phpmyadmin to mysqltool a couple years ago when mysqltool offered features not available in phpmyadmin. I'm not sure what the current state of phpmyadmin is (it may or may not offer the features found in mysqltool). mysqltool is a perl based product and is available at http://www.dajoba.com/projects/mysqltool/ Regards, Bill -- If Verisign is the 'Value of Trust', then trust ain't worth much any more. - me Spam Trap Mail Key: ASK and you shall receive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyadmin
Are you also going to install MySQL on the laptop? PHPMyAdmin runs over the web, so you just need to be able to pull up the PHPMyAdmin website on the laptop in order to use it. There shouldn't be any installation required. If you want to use a GUI to connect to the remote MySQL server, then use MyCC, Mascon, MySQLFront (discontinued, but still good) or any other the other tools frequently mentioned. Just make sure the GRANTs are secure for the remote user. ---John Holmes... - Original Message - From: Jon Miller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 1:05 AM Subject: re: phpMyadmin Using PhpMyAdmin for administering MySQL, can this product be installed on a remote system? We currently have it installed on the same server as MySQL, but now the programmer wants it on his Laptop. Or is there another product that can manage a MySQL database from either a Windows or Linux laptop/desktop. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: phpMyadmin
Using PhpMyAdmin for administering MySQL, can this product be installed on a remote system? We currently have it installed on the same server as MySQL, but now the programmer wants it on his Laptop. Or is there another product that can manage a MySQL database from either a Windows or Linux laptop/desktop. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: phpMyadmin
phpMyAdmin can admin. database that is not on the same machine. The only requirement is that machine can access the MySQL database to be admin. Which usually means that a user name and a ip address on the MySQL user table. However, I don't think that it is appropiate to have a notebook to install a phpMyAdmin and admin. a remote database. First of all, the notebook should have a web server installed. Secondly, there may be a security loop holes to have a remote user for a MySQL database. Esp., if the notebook used for the programmer on the move. He may just access the phpMyAdmin on the host by IE. If further security is required (esp. on the move), you may consider to have SSL installed. You may also consider some secure shell such as ssh which can also provide secure connection. Regards, -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com Using PhpMyAdmin for administering MySQL, can this product be installed on a remote system? We currently have it installed on the same server as MySQL, but now the programmer wants it on his Laptop. Or is there another product that can manage a MySQL database from either a Windows or Linux laptop/desktop. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin and mysql
Hello Martin, Your problem is related to PHP not MySQL. You should check the max_post_size directive in yor php.ini file. AFAIK, this limit is set to 8M. If you decreased the size, increasing it may solve your problem. max_post_size controls the maximim POST size you can do, and if you exceed this limit, your post will be discarded. - Original Message - From: Martin Hudec [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 13:53 Subject: phpmyadmin and mysql Hello MySQL, we have this problem: when using phpmyadmin if we select database to view and we put SQL command to ENTER SQL QUERY/QUERIES TO DATABASE field and submit it, it will display NO SQL QUERYwhat is wrong? please help me...thank you -- Best regards, Martin mail [EMAIL PROTECTED] mobile +421.907.303.393 icq34358414 wwwhttp://www.corwin.sk PGP key fingerprint 21365ca05ecfd8aeb1cf19c838fff033 In those days spirits were brave, the stakes were high, men were real men, women were real women and small furry creatures from Alpha Centauri were real small furry creatures from Alpha Centauri. by Douglas Adams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin
From: Mitchell Wright [EMAIL PROTECTED] Is phpmyadmin secure? I believe in the default install, it sends cleartext passwords. I use it on a trusted LAN only, so I don't care, but you should probably buttress it's login with a .htaccess and password. -- SQL SQL SQL SQL SQL SQL SQL SQL : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpmyadmin
If one cannot avoid using PHP how can I secure it? I will initially have it on the same server as IIS. There is a wrapper program that temporarily elevates PHP's permissions, so that the PHP scripts don't have to be world-readable. Can't remember what it is, offhand, though. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpmyadmin
A quick question: Is phpmyadmin secure? Anyone have an negative experiences having it installed on their server? PHP itself is not secure unless special steps are taken to secure it, and even then it's no guarantee. There have been several exploits published against PHP, and a few of them have been root exploits. I avoid PHP when I can, especially on shared servers. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin (OT)
I don't want to start a flame but where do take this from? Every security-hole in php has been fixed shortly after it was known. Its as secure as any other server-side scripting-language in the web. Thomas On Fri, 25 Oct 2002 10:40:32 -0500 Ed Carp [EMAIL PROTECTED] wrote: PHP itself is not secure unless special steps are taken to secure it, and even then it's no guarantee. There have been several exploits published against PHP, and a few of them have been root exploits. I avoid PHP when I can, especially on shared servers. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin (OT)
Unfortunately, when people suggest that they avoid PHP when they can it usually means they don't understand much about the language or how to use it appropriately. That being said, I personally avoid .NET and FrontPage MS - Original Message - From: Thomas Seifert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002 9:47 AM Subject: Re: phpmyadmin (OT) I don't want to start a flame but where do take this from? Every security-hole in php has been fixed shortly after it was known. Its as secure as any other server-side scripting-language in the web. Thomas On Fri, 25 Oct 2002 10:40:32 -0500 Ed Carp [EMAIL PROTECTED] wrote: PHP itself is not secure unless special steps are taken to secure it, and even then it's no guarantee. There have been several exploits published against PHP, and a few of them have been root exploits. I avoid PHP when I can, especially on shared servers. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin (OT)
Hrm. Yes, php can be vulnerable, but I was more worried about phpmyadmin and the potential of direct access to my databases. This particular server runs red hat 7.3, and they bundle php with their distro. They also patch everything in their distros fairly regularly and I subscribe to their update services, I feel fairly secure in their offerings. I was mostly fishing for any horror stories out there from people that installed phpmyadmin and were hacked because of it. I like the convenience, but am not willing to sacrifice security. I am however willing to run php, so the security concern is purely with phpmyadmin. Any advice would be most appreciated, Mitchell On 10/25/02 11:47 AM, Thomas Seifert [EMAIL PROTECTED] wrote: I don't want to start a flame but where do take this from? Every security-hole in php has been fixed shortly after it was known. Its as secure as any other server-side scripting-language in the web. Thomas On Fri, 25 Oct 2002 10:40:32 -0500 Ed Carp [EMAIL PROTECTED] wrote: PHP itself is not secure unless special steps are taken to secure it, and even then it's no guarantee. There have been several exploits published against PHP, and a few of them have been root exploits. I avoid PHP when I can, especially on shared servers. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpmyadmin
If one cannot avoid using PHP how can I secure it? I will initially have it on the same server as IIS. At 10:40 AM 10/25/2002 -0500, Ed Carp wrote: A quick question: Is phpmyadmin secure? Anyone have an negative experiences having it installed on their server? PHP itself is not secure unless special steps are taken to secure it, and even then it's no guarantee. There have been several exploits published against PHP, and a few of them have been root exploits. I avoid PHP when I can, especially on shared servers. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: phpmyadmin (OT)
Mitchell, I run phpmyadmin at a freewebhost on RH 7.0/ Apache 1.3.22/ PHP 4.0.6/ MySQL 3.23.46 in multiuser mode with about 300 users for one year. Zero problems at all with the software. The box got hacked but not because of vulnerabilities in phpmyadmin. In time I use Usermin (plugin for Webmin see webmin.com - good as hosting-console) or MySQLman (http://www.gossamer-threads.com), both Perl/DBI based. Neither any security problems though MySQLman has it's problems displaying HTML code in database fields e.g. from CMS db's. STIBS === At 2002-10-25, 11:56:00 you wrote: === Hrm. Yes, php can be vulnerable, but I was more worried about phpmyadmin and the potential of direct access to my databases. This particular server runs red hat 7.3, and they bundle php with their distro. They also patch everything in their distros fairly regularly and I subscribe to their update services, I feel fairly secure in their offerings. I was mostly fishing for any horror stories out there from people that installed phpmyadmin and were hacked because of it. I like the convenience, but am not willing to sacrifice security. I am however willing to run php, so the security concern is purely with phpmyadmin. Any advice would be most appreciated, Mitchell On 10/25/02 11:47 AM, Thomas Seifert [EMAIL PROTECTED] wrote: = = = = = = = = = = = = = = = = = = = = 2002-10-25, Best regards, Freundliche Grüße STIBS (aka Michael Stibane) Training, Consulting, Development (Linux, Network, Internet, Database) http://www.stibs.cc Escapade Server-Sided Scripting Language Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org Mandrakesoft Linux-Campus Trainer http://www.mandrakesoft.com/training = = = = = = = = = = = = = = = = = = = = No HTML mails please! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpmyadmin
If you are worried about security, don't run IIS! Now, that's insecure! Use Apache, this also runs fine on windows. PHP is as insecure as own programming is. If you program securely then so is PHP. My 2 cents. -Original Message- From: John Chang [mailto:johnec;umich.edu] Sent: vrijdag 25 oktober 2002 18:10 To: mysql list Subject: RE: phpmyadmin If one cannot avoid using PHP how can I secure it? I will initially have it on the same server as IIS. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin/MySQL Question
I believe you need to change the socket to the location in your /etc/my.cnf file. I usually add both sections in it just to kep things straight. [client] socket=path-for-socket-file [mysqld] socket=path-for-socket-file I used /ldata/mysql/tmp/mysql.sock my.cnf isn't automatically there so you may have to create it. then change $cfg['Servers'][$i]['socket']= ''; to $cfg['Servers'][$i]['socket']= 'path-used-in-my.cnf'; I am probably wrong, but its something that you can try without any danger of screwing up everything. If it doesn't work, simply remove the socket information and lines from the my.cnf file. Jason -Original Message- From: Easton, William [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:55 PM To: '[EMAIL PROTECTED]' Subject: phpMyAdmin/MySQL Question Maybe someone else can come up with an answer for me on this question. I am getting the following error when I try to run my index.php file. I think I have configured it correctly, but obviously I haven't. And my host basically told to go shove it. Welcome to phpMyAdmin 2.3.1-rc1 Error MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Does anyone have any suggestions on this one? My config file looks like this in the areas I think I may have screwed up: $cfg['PmaAbsoluteUri'] = 'http://www.iaacc.org/phpMyAdmin/'; $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; $cfg['PmaNoRelation_DisableWarning'] = FALSE; /** * Server(s) configuration */ $i = 0; $i++; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket']= ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['controluser'] = ''; $cfg['Servers'][$i]['controlpass'] = ''; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = '***'; $cfg['Servers'][$i]['password'] = '***'; $cfg['Servers'][$i]['only_db'] = ''; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['pmadb'] = ''; $cfg['Servers'][$i]['bookmarktable'] = ''; $cfg['Servers'][$i]['relation'] = ''; $cfg['Servers'][$i]['table_info']= ''; $cfg['Servers'][$i]['table_coords'] = ''; $cfg['Servers'][$i]['pdf_pages'] = ''; $cfg['Servers'][$i]['column_comments'] = ''; $cfg['Servers'][$i]['AllowDeny']['order'] = ''; $cfg['Servers'][$i]['AllowDeny']['rules'] = array(); I have my login and password entered into the user/password area. Also, the actually database is online at mysql.iaacc.org and that might be different. If anyone can help, I would REALLY appreciate it. Thanks -Bill William Easton Creative Media Group The University of Iowa Room 1185 Westlawn Iowa City, IA 52242 319/353-3022 voice 319/335-9127 fax [EMAIL PROTECTED] http://www.medicine.uiowa.edu/creative http://telemed.medicine.uiowa.edu Notice: This e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin/MySQL Question
Yes, please, someone please tell how that mysql.sock file is working. I get the same general thing as well when I try to connect using just mysqladmin. Don B. -Original Message- From: Easton, William [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 10:55 AM To: '' Subject: phpMyAdmin/MySQL Question Maybe someone else can come up with an answer for me on this question. I am getting the following error when I try to run my index.php file. I think I have configured it correctly, but obviously I haven't. And my host basically told to go shove it. Welcome to phpMyAdmin 2.3.1-rc1 Error MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Does anyone have any suggestions on this one? My config file looks like this in the areas I think I may have screwed up: $cfg['PmaAbsoluteUri'] = 'http://www.iaacc.org/phpMyAdmin/'; $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; $cfg['PmaNoRelation_DisableWarning'] = FALSE; /** * Server(s) configuration */ $i = 0; $i++; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket']= ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['controluser'] = ''; $cfg['Servers'][$i]['controlpass'] = ''; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = '***'; $cfg['Servers'][$i]['password'] = '***'; $cfg['Servers'][$i]['only_db'] = ''; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['pmadb'] = ''; $cfg['Servers'][$i]['bookmarktable'] = ''; $cfg['Servers'][$i]['relation'] = ''; $cfg['Servers'][$i]['table_info']= ''; $cfg['Servers'][$i]['table_coords'] = ''; $cfg['Servers'][$i]['pdf_pages'] = ''; $cfg['Servers'][$i]['column_comments'] = ''; $cfg['Servers'][$i]['AllowDeny']['order'] = ''; $cfg['Servers'][$i]['AllowDeny']['rules'] = array(); I have my login and password entered into the user/password area. Also, the actually database is online at mysql.iaacc.org and that might be different. If anyone can help, I would REALLY appreciate it. Thanks -Bill William Easton Creative Media Group The University of Iowa Room 1185 Westlawn Iowa City, IA 52242 319/353-3022 voice 319/335-9127 fax [EMAIL PROTECTED] http://www.medicine.uiowa.edu/creative http://telemed.medicine.uiowa.edu Notice: This e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHPMyAdmin and mySQL
On 29 Jul 2002, William Bradley wrote: From suggestions I received on this mySQL list I installed phpMyAdmin from the Mandrake 8.2 CDrom, which is the system I am running.So I am presuming that there are a number of members on the list using phpMyAdmin. I am one of the developers of phpMyAdmin. I'm not sure which version of phpMyAdmin is shipped with Mandrake 8.2, but I can tell you that it is in your best interests to upgrade to the latest version (2.3.0-rc4 and 2.3.0 final in 2 weeks). When I use the following command in a browser, phpMyAdmin starts up and then tells me: Access denied for user 'root@localhost' (using password NO) It sounds like you don't have any password in the password field for the basic authentication method. When I try to edit the config.inc.php it comes up as a read only file. When I change the permissions on it, things go screwy. Sounds like some weird setup in Mandrake. See my advice above re upgrading. (Filter fodder: sql, query) -- Robin Hugh Johnson E-Mail : [EMAIL PROTECTED] Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin and mysql 3.23.49
starting with version 3.23.49, load data local is dis-abled see this URL for more info http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html I upgraded my redhat to 7.3, which comes with mysql 3.23.49. Since then, I am no longer able to upload data files into mysql databases. This is what I got: The used command is not allowed with this MySQL version I think the used command here is referring to load data local infile. Has anyone else had this problem? Any workaround? Thanks. - hcir [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin and mysql 3.23.49
Thanks for the pointer. Anyone know how to make phpMyAdmin to work around this new feature? Thanks. Bz On Fri, 2002-07-05 at 10:14, hcir wrote: starting with version 3.23.49, load data local is dis-abled see this URL for more info http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html I upgraded my redhat to 7.3, which comes with mysql 3.23.49. Since then, I am no longer able to upload data files into mysql databases. This is what I got: The used command is not allowed with this MySQL version I think the used command here is referring to load data local infile. Has anyone else had this problem? Any workaround? Thanks. - hcir [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin and mysql 3.23.49
one way is to create a file in /usr/local/mysql/data OR wherever you data dir is named my.cnf with the following contents [mysql] local-infile = 1 On Friday, July 5, 2002, at 02:13 , Bin Zhang wrote: Thanks for the pointer. Anyone know how to make phpMyAdmin to work around this new feature? Thanks. Bz On Fri, 2002-07-05 at 10:14, hcir wrote: starting with version 3.23.49, load data local is dis-abled see this URL for more info http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html I upgraded my redhat to 7.3, which comes with mysql 3.23.49. Since then, I am no longer able to upload data files into mysql databases. - hcir [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpmyadmin .... ?????
Hi If you open the directory where it is installed with a web browser what happens? Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: toby - [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 08:03 To: [EMAIL PROTECTED] Subject: phpmyadmin ? hi guyz i have downloaded phpmyadmin i have configured it by the book but i dont know how to use it for mysql database :$ will someone pleez tell me how to thnx a million toby . _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin issue + looking for php/mysql websites
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Looks like you're running phpMyAdmin on a machine with Windows and PHP in CGI-mode? I don't recall if it's PHP in CGI-mode on Windows that in general doesn't work with the header()-function or if it's only IIS. The solution is to install PHP as non-cgi... Don't know how that is done as I'm using FreeBSD, but know you know whats wrong :) I dont think i set up mySQL properly maybe ? The problem is not related to MySQL. :wq //andreas http://phpwizard.dk/ (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin issue + looking for php/mysql websites
I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header function is just that a couple of the .inc files with phpMyAdmin need to have the extra lines after the ? deleted. But, that message says that the headers have already been sent out. The error below usually means a 404 error if you are using a template. If not, it usually means that you have forgotten something like a curly brace or a script ending. Post your code and it will be easier to help. Scott -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:27 PM To: 'catriona grisewood'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Looks like you're running phpMyAdmin on a machine with Windows and PHP in CGI-mode? I don't recall if it's PHP in CGI-mode on Windows that in general doesn't work with the header()-function or if it's only IIS. The solution is to install PHP as non-cgi... Don't know how that is done as I'm using FreeBSD, but know you know whats wrong :) I dont think i set up mySQL properly maybe ? The problem is not related to MySQL. :wq //andreas http://phpwizard.dk/ (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin issue + looking for php/mysql websites
Im not sure what way php is installed as it was already installed on the server here. How i got this message exactly was when i opened up MyphpMyAdmin after just installing it. I go to create a new datbase and thats when the error page comes up. Could it be i dont have the config file setup correctly ? or maybe MySQL isnt configured correctly ? i dont know if that helps ? Thanks for any help --- Hathaway, Scott L [EMAIL PROTECTED] wrote: I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header function is just that a couple of the .inc files with phpMyAdmin need to have the extra lines after the ? deleted. But, that message says that the headers have already been sent out. The error below usually means a 404 error if you are using a template. If not, it usually means that you have forgotten something like a curly brace or a script ending. Post your code and it will be easier to help. Scott -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:27 PM To: 'catriona grisewood'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Looks like you're running phpMyAdmin on a machine with Windows and PHP in CGI-mode? I don't recall if it's PHP in CGI-mode on Windows that in general doesn't work with the header()-function or if it's only IIS. The solution is to install PHP as non-cgi... Don't know how that is done as I'm using FreeBSD, but know you know whats wrong :) I dont think i set up mySQL properly maybe ? The problem is not related to MySQL. :wq //andreas http://phpwizard.dk/ (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin issue + looking for php/mysql websites
when im connecting to an online MySQL server do i just put in the server name ie 'orac'in the config file or do i need to put in its ip address etc with it ? --- Hathaway, Scott L [EMAIL PROTECTED] wrote: I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header function is just that a couple of the .inc files with phpMyAdmin need to have the extra lines after the ? deleted. But, that message says that the headers have already been sent out. The error below usually means a 404 error if you are using a template. If not, it usually means that you have forgotten something like a curly brace or a script ending. Post your code and it will be easier to help. Scott -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:27 PM To: 'catriona grisewood'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Looks like you're running phpMyAdmin on a machine with Windows and PHP in CGI-mode? I don't recall if it's PHP in CGI-mode on Windows that in general doesn't work with the header()-function or if it's only IIS. The solution is to install PHP as non-cgi... Don't know how that is done as I'm using FreeBSD, but know you know whats wrong :) I dont think i set up mySQL properly maybe ? The problem is not related to MySQL. :wq //andreas http://phpwizard.dk/ (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin issue + looking for php/mysql websites
Is there a reason why you are using IIS? I would disable IIS and run apache. That's what I did, IIS is way to difficult and unstable to install PHP as CGI or ISAPI Apache is easy to set up with PHP. Download Apache and run PHP from there. Make sure you disable ALL the IIS services -Original Message- From: catriona grisewood [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:45 PM To: Hathaway, Scott L; 'Andreas_Frxsting'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites Im not sure what way php is installed as it was already installed on the server here. How i got this message exactly was when i opened up MyphpMyAdmin after just installing it. I go to create a new datbase and thats when the error page comes up. Could it be i dont have the config file setup correctly ? or maybe MySQL isnt configured correctly ? i dont know if that helps ? Thanks for any help --- Hathaway, Scott L [EMAIL PROTECTED] wrote: I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header function is just that a couple of the .inc files with phpMyAdmin need to have the extra lines after the ? deleted. But, that message says that the headers have already been sent out. The error below usually means a 404 error if you are using a template. If not, it usually means that you have forgotten something like a curly brace or a script ending. Post your code and it will be easier to help. Scott -Original Message- From: Andreas Frosting [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:27 PM To: 'catriona grisewood'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Looks like you're running phpMyAdmin on a machine with Windows and PHP in CGI-mode? I don't recall if it's PHP in CGI-mode on Windows that in general doesn't work with the header()-function or if it's only IIS. The solution is to install PHP as non-cgi... Don't know how that is done as I'm using FreeBSD, but know you know whats wrong :) I dont think i set up mySQL properly maybe ? The problem is not related to MySQL. :wq //andreas http://phpwizard.dk/ (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy AwardsR http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: RE: phpMyAdmin issue + looking for php/mysql websites
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query Gaah.. Hi, I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header function is just that a couple of the .inc files with phpMyAdmin need to have the extra lines after the ? deleted. If that was the case, phpMyAdmin wouldn't be working with any other webserver... Well, it does! PHP's behavior regarding headers and data sent before the headers itself is the same on all platforms. But, that message says that the headers have already been sent out. I've never worked with IIS, but that's a Microsoft-style error message if that's true. The error below usually means a 404 error if you are using a template. If not, it usually means that you have forgotten something like a curly brace or a script ending. If it was a 404 the server would say so. If it's a script error php would say something like Parse error... blahblah :) :wq //andreas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin issue + looking for php/mysql websites
Read the documentation. Where is the mySQL database located? Is it on the web server or on another machine? If its on another machine then you put in the IP address. If its on the same machine as the Web Server, then put in localhost Get it? -Original Message- From: catriona grisewood [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:55 PM To: Hathaway, Scott L; 'Andreas_Frxsting'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites when im connecting to an online MySQL server do i just put in the server name ie 'orac'in the config file or do i need to put in its ip address etc with it ? --- Hathaway, Scott L [EMAIL PROTECTED] wrote: I use PHP (cgi) with IIS and phpMyAdmin. The problem with the header function is just that a couple of the .inc files with phpMyAdmin need to have the extra lines after the ? deleted. But, that message says that the headers have already been sent out. The error below usually means a 404 error if you are using a template. If not, it usually means that you have forgotten something like a curly brace or a script ending. Post your code and it will be easier to help. Scott -Original Message- From: Andreas Frosting [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:27 PM To: 'catriona grisewood'; [EMAIL PROTECTED] Subject: RE: phpMyAdmin issue + looking for php/mysql websites The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Looks like you're running phpMyAdmin on a machine with Windows and PHP in CGI-mode? I don't recall if it's PHP in CGI-mode on Windows that in general doesn't work with the header()-function or if it's only IIS. The solution is to install PHP as non-cgi... Don't know how that is done as I'm using FreeBSD, but know you know whats wrong :) I dont think i set up mySQL properly maybe ? The problem is not related to MySQL. :wq //andreas http://phpwizard.dk/ (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy AwardsR http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin issue
The problem is PHP and IIS... IIS takes a lot to get it to work... I think you should ask sourceforge about it, not the mysql mailing list. This is a PHP issue not a mysql. -Original Message- From: CATRIONA GRISEWO0D [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 6:24 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: phpMyAdmin issue Hi I have got phpMyAdmin connecting to my server. When i open up index i can see on the left hand side my datbase and tables. And on the right of the page is the welcome page... Welcome to phpMyAdmin 2.2.5 MySQL 3.23.32 running on 136.201.105.3 as [EMAIL PROTECTED] phpMyAdmin ...OLE_Obj... Top of Form 1 ...OLE_Obj... Language: ...OLE_Obj... ...OLE_Obj... Bottom of Form 1 ...OLE_Obj... phpMyAdmin documentation ...OLE_Obj... Official phpMyAdmin Homepage ...OLE_Obj... Sourceforge phpMyAdmin Download Page [ChangeLog] [CVS] [Lists] I seem to be missing the bit where you create a database etc. Then if I click on my database on the left hand side i get the error: CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: hh any ideas ? im sorry but im a complete beginner here - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin and mysql client conflict!! HOW?!
Here's a clearer indication of the problem I mentioned earlier: In the mysql client terminal output below, note how the column type of startDate does not show up as changed from timestamp to date (even though I had changed it earlier in phpmyadmin) until I run Repair Table on the table in PHPMYADMIN. Is the Repair Table command refreshing the table cache or something else that PHPMYADMIN is failing to do? mysql show columns from checklist; +-+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+---+ | checklistID | int(11) | | PRI | 0 | | | eventID | int(11) | | | 0 | | | label | varchar(50) | | | | | | startDate | timestamp(14) | YES | | NULL| | | statusID| int(11) | | | 0 | | | version | int(11) | YES | | NULL| | +-+---+--+-+-+---+ 6 rows in set (0.00 sec) mysql exit Bye [localhost:Documents/somehost/credo] root# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 950 to server version: 3.23.38 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql use credo; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql show columns from checklist; +-+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+---+ | checklistID | int(11) | | PRI | 0 | | | eventID | int(11) | | | 0 | | | label | varchar(50) | | | | | | startDate | timestamp(14) | YES | | NULL| | | statusID| int(11) | | | 0 | | | version | int(11) | YES | | NULL| | +-+---+--+-+-+---+ 6 rows in set (0.03 sec) mysql repair table checklist; +-++--+--+ | Table | Op | Msg_type | Msg_text | +-++--+--+ | credo.checklist | repair | status | OK | +-++--+--+ 1 row in set (0.04 sec) mysql show columns from checklist; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | checklistID | int(11) | | PRI | 0 | | | eventID | int(11) | | | 0 | | | label | varchar(50) | | | | | | startDate | date| YES | | NULL| | | statusID| int(11) | | | 0 | | | version | int(11) | YES | | NULL| | +-+-+--+-+-+---+ 6 rows in set (0.01 sec) mysql On Tuesday, July 10, 2001, at 08:08 AM, Werner Stuerenburg wrote: I just changed a column type (timestamp -- date) in PHPmyadmin, but when I checked the table structure in the mysql client immediately afterwards, it showed up with the old column type!! Has anyone else had something like this happen? No. I just tested, everything ok. How can PHPmyadmin and the mysql client show different output?!! phpMyAdmin shows you the query. Check it for consistency. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin newbie problem
At 10:23 am +0100 19/6/01, Tommy Beavitt wrote: I am wondering why I am unable to use the SELECT statement to access data in a MySQL (3.22.32) database I have created using phpMyAdmin (2.1.0). Everything else about it is a delight to use (I am migrating from SQLAnywhere) and I have managed to create tables and insert data into them no problem. But every time I use a SELECT statement I get the error: Error SQL-query: select * from books; MySQL said: Back Obviously I am making a wrong assumption somewhere. The documentation I have checked is the official MySQL manual but this does not relate specifically to phpMyAdmin and certainly does not prohibit SELECT statements! But nobody picked up on it. Does anyone know of a good discussion list relating specifically to phpMyAdmin? Thanks Tommy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin newbie problem
Drop the semi-colon off the end of the SQL Statement you wish to run. You don't need them in the phpMyAdmin SQL Window. Enjoy, Tyrone - Original Message - From: Tommy Beavitt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 8:31 AM Subject: Re: phpMyAdmin newbie problem At 10:23 am +0100 19/6/01, Tommy Beavitt wrote: I am wondering why I am unable to use the SELECT statement to access data in a MySQL (3.22.32) database I have created using phpMyAdmin (2.1.0). Everything else about it is a delight to use (I am migrating from SQLAnywhere) and I have managed to create tables and insert data into them no problem. But every time I use a SELECT statement I get the error: Error SQL-query: select * from books; MySQL said: Back Obviously I am making a wrong assumption somewhere. The documentation I have checked is the official MySQL manual but this does not relate specifically to phpMyAdmin and certainly does not prohibit SELECT statements! But nobody picked up on it. Does anyone know of a good discussion list relating specifically to phpMyAdmin? Thanks Tommy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpmyadmin + mysql +Unknown database 'test'
Hi, Well, I also had the same problem and finally traced the bug down to a file called db_readdump.php3 in phpmyadmin directory. If you'r still having the problem, may be this is helpful to you too. edit db_readdump.php3 and add in the beginning of the file $db = trim($db); Then at the bottom of the code (somewhere around line no.45) you will find.. if(!empty($sql_file) $sql_file != none ereg(^php[0-9A-Za-z_.-]+$, basename($sql_file))) { $sql_query = addslashes(fread(fopen($sql_file, r), filesize($sql_file))); } Cut this part of code and paste it just below, the following code... $pieces = split_sql($sql_query); if (count($pieces) == 1 !empty($pieces[0])) { $sql_query = trim($pieces[0]); include (sql.php); exit; } thats it, Hope this helps, Regards, Sivaprasad. R.L http://netlogger.net __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin equivalent
"MikeBlezien" wrote: Hello All, Was wonder if any knows of a Perl equivalent to the PHP's version of phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP installed, and frankly, to lazy to do all the typing thru telnet session! :) MysqlTool Looks pretty good http://dajoba.com/projects/mysqltool/ Greg TIA, Mickalo Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin equivalent
Gossamer Threads (http://www.gossamer-threads.com) has an near identical knockoff written in perl calles mysqlman - Original Message - From: "MikemickaloBlezien" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 10:53 AM Subject: phpMyAdmin equivalent Hello All, Was wonder if any knows of a Perl equivalent to the PHP's version of phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP installed, and frankly, to lazy to do all the typing thru telnet session! :) TIA, Mickalo Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin equivalent
I've gotten thttpd compiled with php running phpMyAdmin beautifully, if you want a small lightweight httpd to use phpMyAmin with. Ive done it with x86 linux, ppc linux, and sparc64 linux. Advanced authentication, everything works swell. I do it with php-4.0.3pl1 with a patch to the php, but I think that patch (which is needed for advanced authentication) is in php 4.0.4pl1. The php source has instructions on how to integrate php into thttpd. Another option is to run php with phpMyAdmin on a different server. Also works well- though you have to give permission for your users who will be using it to connect from the server running the phpMyAdmin. On Monday, March 5, 2001, at 11:35 AM, Frederick L. Steinkopf wrote: Gossamer Threads (http://www.gossamer-threads.com) has an near identical knockoff written in perl calles mysqlman - Original Message - From: "MikemickaloBlezien" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 10:53 AM Subject: phpMyAdmin equivalent Hello All, Was wonder if any knows of a Perl equivalent to the PHP's version of phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP installed, and frankly, to lazy to do all the typing thru telnet session! :) TIA, Mickalo Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = -=-=-=-=-=-=-=-=-=-=-=-=-=-=- Michael A. Peters Abriasoft Senior Developer http://www.abriasoft.com/ (510) 623-9726x357 Fax: (510) 249-9125 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin
http://www.phpwizard.net/projects/phpMyAdmin/ At 11:08 AM 2/14/2001 -0500, [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin
Hi, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? Here it is: http://www.phpwizard.net/projects/phpMyAdmin/ Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin
http://www.phpwizard.net/ you gotta download it... it's seperate from php and mysql. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 11:08 AM To: [EMAIL PROTECTED] Subject: phpMyAdmin I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? Tx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin
At 11:08 AM -0500 2/14/01, [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? Have a look at ... http://www.htmlwizard.net/projects/phpMyAdmin/ ... or if you prefer a similar tool written in Perl as opposed to PHP, you might want to check out ... http://dajoba.com/projects/mysqltool/ - Ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin
Muchas gratias. I now know why everyone keeps referring to this little jewel. thanks again to you and to all replying. Scott Baker [EMAIL PROTECTED] on 02/14/2001 12:17:45 PM To: Lad Gaal/MarconiMedical@Marconi, [EMAIL PROTECTED] cc: Subject: Re: phpMyAdmin http://www.phpwizard.net/projects/phpMyAdmin/ At 11:08 AM 2/14/2001 -0500, [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: phpMyAdmin
phpwizard.net [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? Tx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php