Re: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?
Hello, On 4/17/2019 10:29 AM, Turritopsis Dohrnii Teo En Ming wrote: Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap? Good evening from Singapore, Our customer (company name is Confidential/not disclosed) reported that their MySQL database has been found missing or was deleted a few times. While it is bad form to explain how to break into anyone's software (including our own), there are places you can look to get a better idea about what might have happened: 1 - the database may have been removed by a DROP DATABASE command. General Query Log - this will show you which session issued the command and the command itself. Audit log (only for commercial releases) - same thing Binary Log - Should have a record of the command executing. But, depending on which account was used or if Binary Log filtering is in place, it may not. This presumes that the Binary Log is even enabled on this system. Many people mistakenly believe it is only for Replication when its other primary use is for point-in-time recovery. If your customer has a recent backup and all of the Binary Log files created since that backup, they could return the system to the point it was at just before that database went missing, skip that DROP command, then continue rolling forward the changes to the other tables to return to a "current" state of their data. 2 - The database was "dropped" by either changing privileges to the folder or by removing it from disk or some other file-level or system-level operation. Either of those would cause errors to start appearing in the MySQL Error Log because a resource that mysqld thinks should exist is no longer available. While the Error Log can't tell you which operation made those files "no longer available" it will have a fingerprint that such an action happened outside of mysqld. Have you determined which method was used to make that database/schema disappear? A normal DROP command (which could happen through an SQL injection attack) would not leave messages in the Error Log about "unable to access ..." or something similar. The server (mysqld) would know that the database was gone (because it removed it) and it wouldn't be trying to find it or the tables within it for your clients to use it. ... snip ... No matter how many commands I try, sqlmap always report that phpMyAdmin 4.8.4 is *NOT* SQL injectable. Perhaps I was using the wrong sqlmap commands all the time? The following is one of the many sqlmap commands I have used. $ python sqlmap.py -u "https://www.EXAMPLE.com/phymyadmin/index.php?id=1; --level=1 --dbms=mysql --sql-query="drop database" Privately asking phpMyAdmin may be a better source of information about how to hack their system to do things it was not intended to do. This list is not about phpMyAdmin and it is very public. They may also have a way of showing you some kind of trace or log that serves as a fingerprint for that happening. -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Integrated Cloud Applications & Platform Services Office: Blountville, TN Become certified in MySQL! Visit https://www.mysql.com/certification/ for details. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?
Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap? Good evening from Singapore, Our customer (company name is Confidential/not disclosed) reported that their MySQL database has been found missing or was deleted a few times. They are using Ubuntu 16.04 LTS Linux server with Apache2 Web Server, MySQL and PHP (LAMP). We responded to these security incidents by changing the passwords of the regular user, root user, and MySQL database user root. We have also examined /var/log/auth.log and think that the hacker could not have come in through ssh or sftp over ssh. From /var/log/mysql/error.log, we can ascertain that the MySQL database has been deleted at certain timings. We have also found nothing abnormal after examining /var/log/apache2/access.log. Even though we have secured the Ubuntu Linux server by changing passwords, the hacker was still able to delete our customer's MySQL database again and again. I have already proposed to install ModSecurity Open Source Web Application Firewall (WAF) to defend against web application attacks but my boss has told me to put that on hold at the moment. In fact, I have already deployed ModSecurity 2.9.0 on a Ubuntu 16.04 LTS *Testing* server and found that it actively detects and logs Nessus and sqlmap vulnerability scans in blocking mode. Since we did not find any evidence that the hacker had breached our customer's Ubuntu 16.04 LTS production server through ssh or Teamviewer, we suspect that the hacker could have achieved it by SQL injection. I took the initiative of downloading and installing Nessus Professional 8.3.1 Trial version for Windows 64-bit. The vulnerability scan report generated by Nessus Web Application Tests shows that our customer is using a version of phpMyAdmin prior to 4.8.5 which could be vulnerable to SQL injection using the designer feature. Further research shows that I can use sqlmap to determine if phpMyAdmin is SQL injectable. I already have a Testing Ubuntu 16.04 LTS Linux server with a Testing MySQL database and a Testing phpMyAdmin 4.8.4. I have purposely installed phpMyAdmin 4.8.4 because this version was reported to be vulnerable to SQL injection using the designer feature, and our customer is using a vulnerable version, according to CVE-2019-6798 ( https://nvd.nist.gov/vuln/detail/CVE-2019-6798 ). Then I proceeded to download and execute sqlmap on our Ubuntu Linux desktop against our Testing server. No matter how many commands I try, sqlmap always report that phpMyAdmin 4.8.4 is *NOT* SQL injectable. Perhaps I was using the wrong sqlmap commands all the time? The following is one of the many sqlmap commands I have used. $ python sqlmap.py -u "https://www.EXAMPLE.com/phymyadmin/index.php?id=1; --level=1 --dbms=mysql --sql-query="drop database" Replace database by database name. May I know what is the correct sqlmap command that I should use to determine that my Testing phpMyAdmin 4.8.4 is SQL injectable? I would like to know if I can successfully drop/delete the Testing database on our Testing server. If I can successfully drop/delete the Testing MySQL database using sqlmap, I would be able to conclude that the hacker must have carried out SQL injection to drop/delete the customer's database. I have already turned off the Testing ModSecurity Web Application Firewall on our Testing server to allow sqlmap to go through. Please point me to any good tutorial on SQL injection using sqlmap. Maybe I do not understand SQL injection well enough. Our customer is also using a customised in-house inventory management system that relies on PHP application and MySQL database. Would open source Snort Intrusion Detection System (IDS) and Intrusion Prevention System (IPS) be able to detect and block SQL injection as well? Please advise. Thank you very much. -BEGIN EMAIL SIGNATURE- The Gospel for all Targeted Individuals (TIs): [The New York Times] Microwave Weapons Are Prime Suspect in Ills of U.S. Embassy Workers Link: https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html Singaporean Mr. Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 14 Feb 2019 [1] https://tdtemcerts.wordpress.com/ [2] https://tdtemcerts.blogspot.sg/ [3] https://www.scribd.com/user/270125049/Teo-En-Ming -END EMAIL SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Problem accessing phpmyadmin using IP from remote machine
Hi Abhishek, Yes I can do that. On Tue, Dec 11, 2012 at 12:50 PM, abhishek jain abhishek.netj...@gmail.comwrote: Can you ping ip 192.168.1.9 from other machines? On Dec 11, 2012 11:21 AM, Girish Talluru girish.dev1...@gmail.com wrote: Hi Guys, I have environment as specified below. Main server: Windows Server 2008 Virtual Box: Oracle VM VM OS: Ubuntu Inside Ubuntu I downloaded and configured Apache, MySql, PHP and PhpMyadmin individually following an article which is mentioned below. https://help.ubuntu.com/community/ApacheMySQLPHP IP Configuration: LAN Address: 192.168.1.9 VirtualBox Address: 192.168.56.1 As mentioned in the file I commented the bind address in my.cnf file. Using http://localhost/phpmyadmin or http://127.0.0.1/phpmyadmin I could able to access the phpmyadmin but when I tried with the LAN/VM address http://192.168.1.0/phpmyadmin or http://192.168.56.1/phpmyadmin I'm trying this because I have requirement to access phpmyadmin from other machines in LAN. I tried to change the bind address to VM and LAN address and checked it is also not working. Can anyone suggest where am I thinking wrong? Suggestions please. Thanks, Girish Talluru
Re: Problem accessing phpmyadmin using IP from remote machine
Can you ping ip 192.168.1.9 from other machines? On Dec 11, 2012 11:21 AM, Girish Talluru girish.dev1...@gmail.com wrote: Hi Guys, I have environment as specified below. Main server: Windows Server 2008 Virtual Box: Oracle VM VM OS: Ubuntu Inside Ubuntu I downloaded and configured Apache, MySql, PHP and PhpMyadmin individually following an article which is mentioned below. https://help.ubuntu.com/community/ApacheMySQLPHP IP Configuration: LAN Address: 192.168.1.9 VirtualBox Address: 192.168.56.1 As mentioned in the file I commented the bind address in my.cnf file. Using http://localhost/phpmyadmin or http://127.0.0.1/phpmyadmin I could able to access the phpmyadmin but when I tried with the LAN/VM address http://192.168.1.0/phpmyadmin or http://192.168.56.1/phpmyadmin I'm trying this because I have requirement to access phpmyadmin from other machines in LAN. I tried to change the bind address to VM and LAN address and checked it is also not working. Can anyone suggest where am I thinking wrong? Suggestions please. Thanks, Girish Talluru
changing mySQL table name screws phpMyAdmin?? reverting change fixes??
I changed a name of the table from within phpMyAdmin, and immediately it crapped. after that when I try to connect using phpMyAdmin (/phpMyAdmin/index.php) I get error in log: [Wed Aug 0814:18:582012][error]Query call failed:Table'mydb.mychangedtbls'doesn't exist (1146) (I changed the name from mychangedtbls to mychangedtbl) mychangedtbl is the table whose name was changed. this issue is only in phpMyAdmin, I am able to access the database and tables find from CLI. I restarted mySQL, but that did not fix. Seems like something is stuck for phpMyAdmin. I restarted browser also but that didnt help either. when i rename this particular table back to what it was using command line, myphphAmin works fine again. here is the structure of this table: mysqlDESCRIBE mychangedtbl; +---+-+--+-+-+---+ |Field |Type |Null|Key|Default|Extra | +---+-+--+-+-+---+ |userid |char(6) |NO |PRI |NULL | | |userpass |varchar(40)|NO | |NULL | | |userlevel |char(3) |NO | |o | | |userpcip |varchar(45)|NO | |NULL | | +---+-+--+-+-+---+ 4rows inset(0.00sec) mysql column userpass has Collation = asci_bin which it does not show in above output, other columns are ascii_general_ci pl advice. ty. Rajeev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: changing mySQL table name screws phpMyAdmin?? reverting change fixes??
(I don't know about phpMyAdmin) SHOW CREATE TABLE is more descriptive than DESCRIBE. You are more likely to get the collation information that way. -Original Message- From: Rajeev Prasad [mailto:rp.ne...@yahoo.com] Sent: Wednesday, August 08, 2012 10:20 AM To: mysql list Subject: changing mySQL table name screws phpMyAdmin?? reverting change fixes?? I changed a name of the table from within phpMyAdmin, and immediately it crapped. after that when I try to connect using phpMyAdmin (/phpMyAdmin/index.php) I get error in log: [Wed Aug 0814:18:582012][error]Query call failed:Table'mydb.mychangedtbls'doesn't exist (1146) (I changed the name from mychangedtbls to mychangedtbl) mychangedtbl is the table whose name was changed. this issue is only in phpMyAdmin, I am able to access the database and tables find from CLI. I restarted mySQL, but that did not fix. Seems like something is stuck for phpMyAdmin. I restarted browser also but that didnt help either. when i rename this particular table back to what it was using command line, myphphAmin works fine again. here is the structure of this table: mysqlDESCRIBE mychangedtbl; +---+-+--+-+-+---+ |Field |Type |Null|Key|Default|Extra | +---+-+--+-+-+---+ |userid |char(6) |NO |PRI |NULL | | |userpass |varchar(40)|NO | |NULL | | |userlevel |char(3) |NO | |o | | |userpcip |varchar(45)|NO | |NULL | | +---+-+--+-+-+---+ 4rows inset(0.00sec) mysql column userpass has Collation = asci_bin which it does not show in above output, other columns are ascii_general_ci pl advice. ty. Rajeev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Fwd: Backing up MySQL using PHPMyAdmin problem with UTF-8
MySQL Administrator 1.2.15 is fails with the same problem. Do anyone have any other suggestions ? -- Forwarded message -- From: Tompkins Neil neil.tompk...@googlemail.com Date: Fri, Oct 15, 2010 at 11:21 AM Subject: Re: Backing up MySQL using PHPMyAdmin problem with UTF-8 To: Michael Dykman mdyk...@gmail.com Cc: [MySQL] mysql@lists.mysql.com I managed to use the older version of MySQL Administrator 1.2.15 and it appears to back up find using InnoDB online backup. On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote: I have had this problem with PHPMyAdmin many times, and the only way I know around it, is to go in and do your dump at the console. PHP does not deal with UTF very well. - michael dykman On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi, I'm using PHP MyAdmin to backup my MySQL database. The database is of type InnoDB and encoding used is utf8_unicode_ci. The variables are set as follows : *MySQL connection collation: **utf8_unicode_ci* *MySQL charset: **UTF-8 Unicode (utf8)* *character set client: utf8* *character set connection: utf8* *character set results: utf8* *collation connection: **utf8_unicode_ci* The problem I have is that the foreign characters like ăÿć etc are being backed up as scrambled non-readable characters. Any ideas why this is happening ?? Are there any other variables I need to check/set ? Cheers Neil -- - michael dykman - mdyk...@gmail.com May the Source be with you.
Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
Oh this isn't good. Because the database in on a shared server and I don't think I've got console access ? On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote: I have had this problem with PHPMyAdmin many times, and the only way I know around it, is to go in and do your dump at the console. PHP does not deal with UTF very well. - michael dykman On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi, I'm using PHP MyAdmin to backup my MySQL database. The database is of type InnoDB and encoding used is utf8_unicode_ci. The variables are set as follows : *MySQL connection collation: **utf8_unicode_ci* *MySQL charset: **UTF-8 Unicode (utf8)* *character set client: utf8* *character set connection: utf8* *character set results: utf8* *collation connection: **utf8_unicode_ci* The problem I have is that the foreign characters like ăÿć etc are being backed up as scrambled non-readable characters. Any ideas why this is happening ?? Are there any other variables I need to check/set ? Cheers Neil -- - michael dykman - mdyk...@gmail.com May the Source be with you.
Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
I managed to use the older version of MySQL Administrator 1.2.15 and it appears to back up find using InnoDB online backup. On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote: I have had this problem with PHPMyAdmin many times, and the only way I know around it, is to go in and do your dump at the console. PHP does not deal with UTF very well. - michael dykman On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi, I'm using PHP MyAdmin to backup my MySQL database. The database is of type InnoDB and encoding used is utf8_unicode_ci. The variables are set as follows : *MySQL connection collation: **utf8_unicode_ci* *MySQL charset: **UTF-8 Unicode (utf8)* *character set client: utf8* *character set connection: utf8* *character set results: utf8* *collation connection: **utf8_unicode_ci* The problem I have is that the foreign characters like ăÿć etc are being backed up as scrambled non-readable characters. Any ideas why this is happening ?? Are there any other variables I need to check/set ? Cheers Neil -- - michael dykman - mdyk...@gmail.com May the Source be with you.
Backing up MySQL using PHPMyAdmin problem with UTF-8
Hi, I'm using PHP MyAdmin to backup my MySQL database. The database is of type InnoDB and encoding used is utf8_unicode_ci. The variables are set as follows : *MySQL connection collation: **utf8_unicode_ci* *MySQL charset: **UTF-8 Unicode (utf8)* *character set client: utf8* *character set connection: utf8* *character set results: utf8* *collation connection: **utf8_unicode_ci* The problem I have is that the foreign characters like ăÿć etc are being backed up as scrambled non-readable characters. Any ideas why this is happening ?? Are there any other variables I need to check/set ? Cheers Neil
Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
I have had this problem with PHPMyAdmin many times, and the only way I know around it, is to go in and do your dump at the console. PHP does not deal with UTF very well. - michael dykman On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi, I'm using PHP MyAdmin to backup my MySQL database. The database is of type InnoDB and encoding used is utf8_unicode_ci. The variables are set as follows : *MySQL connection collation: **utf8_unicode_ci* *MySQL charset: **UTF-8 Unicode (utf8)* *character set client: utf8* *character set connection: utf8* *character set results: utf8* *collation connection: **utf8_unicode_ci* The problem I have is that the foreign characters like ăÿć etc are being backed up as scrambled non-readable characters. Any ideas why this is happening ?? Are there any other variables I need to check/set ? Cheers Neil -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
phpMyAdmin Privileges Query
Hello, just wondering if anyone can advise the query that phpMyAdmin generates to list all the privileges for a specific database. What I'm after is an output like: +-++--+-+ |User | Host| Type | Privileges | +-++--+-+ | A | a.b.c.d | global | S, I, U, D | | B | localhost | database-specific | S, I, U | +-++--++ Thanks, Mike. Adam Internet accepts no liability for the content of this e-mail, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of Adam Internet. If you are not the intended recipient you must not distribute or copy this transmission and should notify the sender of the error. You must not forward, in part or in full, the contents of the e-mail to any recipient unless granted explicit permission from the sender. WARNING: Computer viruses can be transmitted via e-mail. The recipient should check this email and any attachments for the presence of viruses. Adam Internet accepts no liability for any damage caused by any virus transmitted by this e-mail.
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
phpMyAdmin and other management tools
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
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
Access denied for phpmyadmin
Hi all, when i m trying to access phpmyadmin it gives the error * #1045 - Access denied for user 'pma'@'localhost' (using password: NO) ** *How could i fix the problem olease help me, Advanced thanx to you. -Regards Ganeswar Mishra Junior Programmer TathyaSoft pvt. ltd. (+91)9438014761
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: mysqldump vs phpmyadmin dump
Wang Zi Feng wrote: Hi everyone, Here is a rookie question. The problem what I found is that mysqldump and phpmyadmin generate different size of backup file against same database. I try to dump same database with the 2 different methods, the original database is 2.8mb, phpmyadmin export 1.5mb file, and mysqldump export only 941kb file. mysqldump has a number of different settings, and the file size will vary according to which you use. For example, using extended insert syntax will significantly increase the size of the output, and that could easily account for the difference between your two files. What's probably happening is that the settings you're using when running mysqldump from the command line are different to those used by phpMyAdmin, so you end up with differently formatted files. I know there must be some difference between the two export method, but after I import the 941kb file which mysqldump created into a new database, it just works fine. So I'm not sure if I can use mysqldump as the best option to do mysql backup, can someone can help me to figure out why phpmyadmin would generate twice big file? And I see some post that address it is not recommend to import mysqldump file by using phpmyadmin, because it will cause problem. Importing any large file via phpMyAdmin is likely to have problems, as you'll find yourself limited by the maximum upload file size of the web server where phpMyAdmin is running (that's typically 2Mb for PHP on Apache, although the administrators can change that). But the source of the file is irrelevant; so long as it's within the file upload limit then it doesn't matter whether it was exported by phpMyAdmin itself or created using mysqldump from the command line. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqldump vs phpmyadmin dump
hi there, thanks for your reply. the mysql server is running on windows xp sp3, every time I use root user to log in. the command line i use for mysqldump is mysqldump --user=root --password=pass testtest.sql phpmyadmin is with following checked Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT Add IF NOT EXISTS Add AUTO_INCREMENT value Enclose table and field names with backquotes Complete inserts Extended inserts I read about the manual saying that mysqldump is default enabled with -opt, which is --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. So I wonder what is the most secure way to backup mysql database to keep data consistency? Thanks and best regards Wang 2009/11/20 Mark Goodge m...@good-stuff.co.uk Wang Zi Feng wrote: Hi everyone, Here is a rookie question. The problem what I found is that mysqldump and phpmyadmin generate different size of backup file against same database. I try to dump same database with the 2 different methods, the original database is 2.8mb, phpmyadmin export 1.5mb file, and mysqldump export only 941kb file. mysqldump has a number of different settings, and the file size will vary according to which you use. For example, using extended insert syntax will significantly increase the size of the output, and that could easily account for the difference between your two files. What's probably happening is that the settings you're using when running mysqldump from the command line are different to those used by phpMyAdmin, so you end up with differently formatted files. I know there must be some difference between the two export method, but after I import the 941kb file which mysqldump created into a new database, it just works fine. So I'm not sure if I can use mysqldump as the best option to do mysql backup, can someone can help me to figure out why phpmyadmin would generate twice big file? And I see some post that address it is not recommend to import mysqldump file by using phpmyadmin, because it will cause problem. Importing any large file via phpMyAdmin is likely to have problems, as you'll find yourself limited by the maximum upload file size of the web server where phpMyAdmin is running (that's typically 2Mb for PHP on Apache, although the administrators can change that). But the source of the file is irrelevant; so long as it's within the file upload limit then it doesn't matter whether it was exported by phpMyAdmin itself or created using mysqldump from the command line. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=frank.zif...@gmail.com
mysqldump vs phpmyadmin dump
Hi everyone, Here is a rookie question. The problem what I found is that mysqldump and phpmyadmin generate different size of backup file against same database. I try to dump same database with the 2 different methods, the original database is 2.8mb, phpmyadmin export 1.5mb file, and mysqldump export only 941kb file. I know there must be some difference between the two export method, but after I import the 941kb file which mysqldump created into a new database, it just works fine. So I'm not sure if I can use mysqldump as the best option to do mysql backup, can someone can help me to figure out why phpmyadmin would generate twice big file? And I see some post that address it is not recommend to import mysqldump file by using phpmyadmin, because it will cause problem. Thanks and best regards Wang
RE : MediumBlob / phpMyAdmin / hex dumps Questions
I wonder if you are doing the import with phpMySQL. It does not seem possible to import a large database with phpMySQL (or perhaps any php based utility?) on a local PC running windows without hitting various timeouts. I am dealing with large import by doing them directly using mysql at the command line level -- Jacques Brignon -Message d'origine- De : mik...@qualityadvantages.com [mailto:mik...@qualityadvantages.com] Envoyé : samedi 13 décembre 2008 15:13 À : mysql@lists.mysql.com Objet : MediumBlob / phpMyAdmin / hex dumps Questions Hello and Greetings mysql list, A few weeks ago, I posted a question here about importing a database to my local XP pro system and getting loads of MySQL server went away errors during the import. I got suggestions about increasing max packet size and a few other parameters which I followed but still could not get a clean import with out the server going away error. I have since some more troubleshooting to try to narrow in on the source of the problem. The table that is getting the error I have isolated and know that it is a PhotoPlog data table that contains all the binary images that it is storing. The Table has two fields defined with mediumblob, one for the picture and the second one for the thumbnail. I have used phpMySQL to export this table and noticed that it is dumping these fields as HEX and not binary and think that this may be the source of the problem with importing to another system. Anyone have any thoughts on MediumBlog being dumped out as HEX? The other troublesome part of this problem is that only some of the records have problems and no clue what the distinction is between the ones that work and the ones that fail? Any pointer greatly appreciated as always. TIA -- Best regards, mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jacbrig...@online.fr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MediumBlob / phpMyAdmin / hex dumps Questions
Hello and Greetings mysql list, A few weeks ago, I posted a question here about importing a database to my local XP pro system and getting loads of MySQL server went away errors during the import. I got suggestions about increasing max packet size and a few other parameters which I followed but still could not get a clean import with out the server going away error. I have since some more troubleshooting to try to narrow in on the source of the problem. The table that is getting the error I have isolated and know that it is a PhotoPlog data table that contains all the binary images that it is storing. The Table has two fields defined with mediumblob, one for the picture and the second one for the thumbnail. I have used phpMySQL to export this table and noticed that it is dumping these fields as HEX and not binary and think that this may be the source of the problem with importing to another system. Anyone have any thoughts on MediumBlog being dumped out as HEX? The other troublesome part of this problem is that only some of the records have problems and no clue what the distinction is between the ones that work and the ones that fail? Any pointer greatly appreciated as always. TIA -- Best regards, mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
[phpMyAdmin] please vote or suggest features
Hi, for all you people out there loving phpMyAdmin ;-) please visit http://hackontest.org and vote for or suggest your favorite feature you would like to see in phpMyAdmin and that can be implemented within 24 hours by a team of three Thank you very much! -- Sebastian Mendel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Creating Password Username with phpMyAdmin
You wrote, Actually the way to do this would be as follows: When you have created a new database, click on the SQL tab and the use the following to create the user and password: GRANT ALL PRIVILEGES ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Hit the submit button and you are set. * * * * * * * * * * Actually, that didn't work. I typed the following into my SQL window: GRANT ALL PRIVILEGES ON World.* TO [EMAIL PROTECTED] IDENTIFIED BY 'Citizen' It seemed to process correctly, with no error messages, but no database was created. So I created a database manually, then clicked on Privileges. Next, I created a password and username. Not only can I not access the database, I can't even access phpMyAdmin now; I get this error message: * * * * * * * * * * Welcome to phpMyAdmin 2.7.0-pl2 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: YES) * * * * * * * * * * I opened config.inc.php but couldn't find any reference to the database table, password or username I created. Any tips? Thanks. - Original Message From: Schalk Neethling [EMAIL PROTECTED] To: David Blomstrom [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 21, 2007 1:37:12 AM Subject: Re: Creating Password Username with phpMyAdmin No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. http://mobile.yahoo.com/mail
Re: Creating Password Username with phpMyAdmin
Hi David, Actually the way to do this would be as follows: When you have created a new database, click on the SQL tab and the use the following to create the user and password: GRANT ALL PRIVILEGES ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Hit the submit button and you are set. HTH Schalk Neethling AlliedBridge (code.google.com/p/alliedbridge) David Blomstrom wrote: Sorry for the beginner's question, but I'm confused. I can easily create passwords and usernames for my online databases by going into my C-Panel and clicking a MySQL icon. It fetches a page that allows me to easily create and delete databases, add and change passwords, etc. But I can't remember how I created my password and username for the database on my PC. I'm now trying to duplicate that database on a MacBook Pro running MySQL 5 and the current version of phpMyAdmin. But I'm not sure about creating a password and username with phpMyAdmin. Suppose I have a database named World, and I want to give it the password Global and the username Citizen. I created the database, then clicked the Privileges tab, which took me to the page User 'root'@'localhost' : Edit PrivilegesAm I correct in ignoring everything (Global Privileges, Database-Specific Privileges, etc.) except the section?... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Creating Password Username with phpMyAdmin
Ah, that does look like a better way. Thanks! Schalk Neethling [EMAIL PROTECTED] wrote: Hi David, Actually the way to do this would be as follows: When you have created a new database, click on the SQL tab and the use the following to create the user and password: GRANT ALL PRIVILEGES ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Hit the submit button and you are set. - We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list.
Creating Password Username with phpMyAdmin
Sorry for the beginner's question, but I'm confused. I can easily create passwords and usernames for my online databases by going into my C-Panel and clicking a MySQL icon. It fetches a page that allows me to easily create and delete databases, add and change passwords, etc. But I can't remember how I created my password and username for the database on my PC. I'm now trying to duplicate that database on a MacBook Pro running MySQL 5 and the current version of phpMyAdmin. But I'm not sure about creating a password and username with phpMyAdmin. Suppose I have a database named World, and I want to give it the password Global and the username Citizen. I created the database, then clicked the Privileges tab, which took me to the page User 'root'@'localhost' : Edit PrivilegesAm I correct in ignoring everything (Global Privileges, Database-Specific Privileges, etc.) except the section?... Change Login Information / Copy User In this section, under Username, I assume I would change root to Citizen. Would I leave Password set to Do not change password before typing in Global? Then I would simply click Generate and I'm finished, right? Thanks. - Looking for earth-friendly autos? Browse Top Cars by Green Rating at Yahoo! Autos' Green Center.
Substitute for phpMyadmin?
Hello, Ever since I upgraded to MySQL 5.0.x, phpMyAdmin has appeared to be buggy as hell (and yes, of course, I updated the client API in PHP). I guess it really was more of a MyQL 4.0 thingy. At any rate, does anyone know what I could use instead, as semi-graphical interface, on Apache? (FreeBSD). I'm ready to do away with phpMyAdmin. Thanks, - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Substitute for phpMyadmin?
Mark wrote: Hello, Ever since I upgraded to MySQL 5.0.x, phpMyAdmin has appeared to be buggy as hell (and yes, of course, I updated the client API in PHP). I guess it really was more of a MyQL 4.0 thingy. At any rate, does anyone know what I could use instead, as semi-graphical interface, on Apache? (FreeBSD). I'm ready to do away with phpMyAdmin. Thanks, - Mark Just a couple of hours ago Vittorio Zuccalà suggested dadabik - http://www.dadabik.org/ - which looks pretty good to me, though I've only just downloaded and I havn't had chance to play with yet. It would be interesting to see what people think. - Jonathon Wardman, flutt.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Substitute for phpMyadmin?
At any rate, does anyone know what I could use instead, as semi-graphical interface, on Apache? (FreeBSD). I'm ready to do away with phpMyAdmin. Thanks, - Mark Just a couple of hours ago Vittorio Zuccalà suggested dadabik - http://www.dadabik.org/ - which looks pretty good to me, Thanks. :) I'll give it a try. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to create references and insert into values in phpmyadmin?
Hello NG,
how can I implement a reference in phpmyadmin between two fields from
two different tables, so that the two fields of the two different tables
have the same values? And if I have to fill this two tables by building and
executing
the insert into command, which default value of the referenced fields do I
have
to take using the insert into command? The primary key ID field of the first
table do not have a value by building the insert into command.
But the other referenced field of the table two? Which value using insert
into?
The two referenced fields are an auto_increment, primary key ID
field of the table 1 and another field, Typ: index, of the table 2.
In postgres the value filling the table 2 is currval(sequence), how
to in mysql?:
insert into table 2 (authorid, title, subtitle)
values (currval('s_authors'), 'Effektiv C++ Programmieren',
'50 Wege zur Verbesserung Ihrer Programme und Entwuerfe');
Best regards
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5 / phpMyAdmin
I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It gives me this error: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I'm using the same phpMyAdmin config file as when I had a previous version of MySQL installed, so I'm stumped on what could be the hangup. How do I upgrade my MySQL client? phpinfo tells me the API is 3.23.49. $cfg['Servers'][$i]['auth_type'] = 'config'; I'm not even sure this is a MySQL question, but if someone can provide a clue for me that would be great. -- Amer Neely Home of Spam Catcher W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | MySQL | CGI programming for all data entry forms. We make web sites work! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 5 / phpMyAdmin
try a search for old_password -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 1:39 PM To: MySQL List Subject: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It gives me this error: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I'm using the same phpMyAdmin config file as when I had a previous version of MySQL installed, so I'm stumped on what could be the hangup. How do I upgrade my MySQL client? phpinfo tells me the API is 3.23.49. $cfg['Servers'][$i]['auth_type'] = 'config'; I'm not even sure this is a MySQL question, but if someone can provide a clue for me that would be great. -- Amer Neely Home of Spam Catcher W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | MySQL | CGI programming for all data entry forms. We make web sites work! -- 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: MySQL 5 / phpMyAdmin
Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Regards! -Mensaje original- De: Amer Neely [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 10 de Mayo de 2006 12:39 p.m. Para: MySQL List Asunto: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It gives me this error: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I'm using the same phpMyAdmin config file as when I had a previous version of MySQL installed, so I'm stumped on what could be the hangup. How do I upgrade my MySQL client? phpinfo tells me the API is 3.23.49. $cfg['Servers'][$i]['auth_type'] = 'config'; I'm not even sure this is a MySQL question, but if someone can provide a clue for me that would be great. -- Amer Neely Home of Spam Catcher W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | MySQL | CGI programming for all data entry forms. We make web sites work! -- 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: MySQL 5 / phpMyAdmin - SOLVED
Thanks to Ing. Edwin Cruz and George Law for pointing me in the right direction, as previous messages in this thread indicate. phpMyAdmin now working great with MySQL 5.0. Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html try a search for old_password -- Amer Neely Home of Spam Catcher W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | MySQL | CGI programming for all data entry forms. We make web sites work! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: setting up phpmyadmin problem
[EMAIL PROTECTED] schrieb: http://www.blue-fly.co.uk/screen.jpg I cannot seem to add a server..anyone shed any light on it? Just edit config.inc.php It has good documentation comments, so it should not be a problem. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: setting up phpmyadmin problem
I did. The server is windows could this be the problem? The config.inc.php is in the main phpmyadmin folder not in the config folder. Is this ok? Ross - Original Message - From: Dominik Klein [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, April 10, 2006 11:25 AM Subject: Re: setting up phpmyadmin problem [EMAIL PROTECTED] schrieb: http://www.blue-fly.co.uk/screen.jpg I cannot seem to add a server..anyone shed any light on it? Just edit config.inc.php It has good documentation comments, so it should not be a problem. -- 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: [PHP] phpmyadmin problems with quoting exported text
On Wed, November 9, 2005 11:05 am, Chris W wrote: Richard Lynch wrote: On Sun, November 6, 2005 2:17 am, Chris W 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? Because unless a field contains a ',' or '' character, it doesn't NEED quotes to delineate it: 1,test,3 1,I said,It's not the same,3 is the same thing as: 1,test,3 1,I said,It's not the same,3 Your import function is BROKEN in a major way, by requiring quotes where they are not strictly necessary to conform to the CSV specification. That said, it's probably easier to get phpMyAdmin to always quote the output than it is to fix whatever broken import tool you are using. The program I am using to import the data is the MySQL tools. They don't like the output of phpMyAdmin 2.6.1-rc1. And I don't have any control over the server so I can't upgrade the version either. Unless I find a work around, I'm SOL You could probably import into something smart enough to handle the missing quotes, then export with a setting that always quotes. I believe Excel (gak!) would do this correctly. PHP's http://php.net/fgetcsv might do the right thing, and you could write out the CSV any which way you want... Or, at that point, just write an INSERT query. Which route to take depends how big the file is, and how often you have to do this and what tools you are familiar with. -- Like Music? http://l-i-e.com/artists.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP] phpmyadmin problems with quoting exported text
On Sun, November 6, 2005 2:17 am, Chris W 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? Because unless a field contains a ',' or '' character, it doesn't NEED quotes to delineate it: 1,test,3 1,I said,It's not the same,3 is the same thing as: 1,test,3 1,I said,It's not the same,3 Your import function is BROKEN in a major way, by requiring quotes where they are not strictly necessary to conform to the CSV specification. That said, it's probably easier to get phpMyAdmin to always quote the output than it is to fix whatever broken import tool you are using. -- Like Music? http://l-i-e.com/artists.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpmyadmin problems with quoting exported text
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? -- 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 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: Can't Access Via Webmin or PhpMyAdmin.
Mark Sargent wrote: Hi All, I can start mysql with the following cmd, /etc/rc.d/init.d/mysql start although, I had to change bindir=./bin to bindir=/usr/local/mysql/bin to get it to work. I can access the DB with, mysql -h localhost -u root -p successfully, but, when trying to access via phpmyadmin or webmin it doesn't work. I've set the config files to what I believe are correct. phpmyadmin error below, Error *MySQL said: *Documentation http://dev.mysql.com/doc/mysql/en/Error-returns.html | #2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ||Now, I've got user as root and no password, as I haven't set 1 yet. Why am I getting this.? Anyone seen this before.? With webmin, I get this displayed, |*MySQL is not running on your system - database list could not be retrieved. *Click this button to start the MySQL database server on your system with the command /etc/rc.d/init.d/mysql start. This Webmin module cannot administer the database until it is started. even though the server is running, confirmed with the following, [EMAIL PROTECTED] ~]# ps -uxwww | grep mysql Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ root 4640 0.0 0.2 4180 1116 ?S14:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid root 4771 0.0 0.0 1580 124 pts/2R+ 14:36 0:00 grep mysql Is anyone on here running webmin to manage mysql..? I'm curious how you got it to run..? If I stop the server via cli and then click the start mysql server button on the webmin page, it goes back to the same message, but, the server is started. I changed the config module page to reflect my installation. What have I missed, perhaps..? Cheers. Mark Sargent. Hi All, below is the config of webmin mysql module, *Path to mysqlshow command* /usr/bin/mysqlshow *Path to mysqladmin command*/usr/local/mysql/bin/mysqladmin *Path to mysql command* /usr/local/mysql/bin/mysql *Path to mysqldump command* /usr/local/mysql/bin/mysqldump *Path to mysqlimport command* /usr/local/mysql/bin/mysqlimport *Command to start MySQL server* /etc/rc.d/init.d/mysql start *Command to stop MySQL server* /etc/rc.d/init.d/mysql stop *Path to MySQL shared libraries directory* *Path to MySQL databases directory* /var/lib/mysql I hope that helps. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't Access Via Webmin or PhpMyAdmin.
Hi All, I can start mysql with the following cmd, /etc/rc.d/init.d/mysql start although, I had to change bindir=./bin to bindir=/usr/local/mysql/bin to get it to work. I can access the DB with, mysql -h localhost -u root -p successfully, but, when trying to access via phpmyadmin or webmin it doesn't work. I've set the config files to what I believe are correct. phpmyadmin error below, Error *MySQL said: *Documentation http://dev.mysql.com/doc/mysql/en/Error-returns.html | #2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ||Now, I've got user as root and no password, as I haven't set 1 yet. Why am I getting this.? Anyone seen this before.? With webmin, I get this displayed, |*MySQL is not running on your system - database list could not be retrieved. *Click this button to start the MySQL database server on your system with the command /etc/rc.d/init.d/mysql start. This Webmin module cannot administer the database until it is started. even though the server is running, confirmed with the following, [EMAIL PROTECTED] ~]# ps -uxwww | grep mysql Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ root 4640 0.0 0.2 4180 1116 ?S14:19 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid root 4771 0.0 0.0 1580 124 pts/2R+ 14:36 0:00 grep mysql Is anyone on here running webmin to manage mysql..? I'm curious how you got it to run..? If I stop the server via cli and then click the start mysql server button on the webmin page, it goes back to the same message, but, the server is started. I changed the config module page to reflect my installation. What have I missed, perhaps..? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Access denied-phpMyAdmin
Hi Mark: First of all, have you commented out the line Allow networking in the /etc/mysql/my.cnf?. If not, put a # before this line. Probably this error is because of this directive. Second, assuming that you have created the phpMyAdmin database with the script provided, and assuming that you have set the $cfg['Servers'][$i]['auth_type'] variable to http, in the config.inc.php file, have you set the variable $cfg['Servers'][$i]['controluser'] with the proper user and have you given the proper privileges to this user?. And third, check the privileges of the root user (for the localhost and other hosts). Probably the privileges are set to the localhost, but not to remote hosts, so you cannot acces from there. I hope this clues are helpful for you. Best regards, Alvaro - Original Message - From: Mark Sargent [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, April 16, 2005 5:08 AM Subject: Access denied-phpMyAdmin Hi All, I can access the database from the terminal on Fedora 3, [EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.1.10a-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql But, get the following error when accessing via phpMyAdmin with user as root and the correct password, phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. |#1045 - Access denied for user 'root'@'localhost' (using password: YES) I don't understand this. What have I missed..? $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.1-pl3/'; $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = 'password is correct'; // MySQL password (only needed Cheers. Mark Sargent. -- 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]
Access denied-phpMyAdmin
Hi All, I can access the database from the terminal on Fedora 3, [EMAIL PROTECTED] bin]# ./mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.1.10a-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql But, get the following error when accessing via phpMyAdmin with user as root and the correct password, phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. |#1045 - Access denied for user 'root'@'localhost' (using password: YES) I don't understand this. What have I missed..? $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.6.1-pl3/'; $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = 'password is correct'; // MySQL password (only needed Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: No Priviliges and no snort DB in phpmyadmin
Hello. As of MySQL 4.0.2, you see only those databases for which you have some privileges if you don't have the global SHOW DATABASES privilege. Check the rights of user as which phpmyadmin connects. Mark Sargent [EMAIL PROTECTED] wrote: Hi All, I've installed phpmyadmin and have a snort database in mysql, but, it doesn't appear in phpmyadmin. I know it's there, because base is using it to display info from snort on the machine. Why wouldn't it appear in phpmyadmin. It appears with the same set up on my work test machine. What should I look for to fix this..? Also, I have no priviliges for create database. Below is my connection info. Cheers. Welcome to phpMyAdmin 2.6.1-pl3 *MySQL 4.1.10a-standard running on localhost as [EMAIL PROTECTED] Mark Sargent. -- 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]
No Priviliges and no snort DB in phpmyadmin
Hi All, I've installed phpmyadmin and have a snort database in mysql, but, it doesn't appear in phpmyadmin. I know it's there, because base is using it to display info from snort on the machine. Why wouldn't it appear in phpmyadmin. It appears with the same set up on my work test machine. What should I look for to fix this..? Also, I have no priviliges for create database. Below is my connection info. Cheers. Welcome to phpMyAdmin 2.6.1-pl3 *MySQL 4.1.10a-standard running on localhost as [EMAIL PROTECTED] Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpMyAdmin 2.5.4 login in ERROR!
phpMyAdmin 2.5.4 + MySQL 4.17 + PHP 5 When the weclome picture is being shown, i try to login with root ,but error message is occurred. That is as follow: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client Thanks for all and need your help. -- 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: MySQL and phpMyAdmin
Hello. I think you should rebuild php with the 4.1.10 libraries. Search in the archives at http://lists.mysql.com/mysql about successful solution for similar problem(s). See: http://dev.mysql.com/doc/mysql/en/old-client.html Asad Habib [EMAIL PROTECTED] wrote: I just installed phpMyAdmin, made the appropriate changes in the config.inc.php file, and got the following error when accessing it via both IE and Safari on Mac OS X Panther client. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I am using MySQL 4.1.10, the latest stable release, with phpMyAdmin-2.6.1-pl3, which the documentation says are compatible. Any help would be greatly appreciated. Thanks. - Asad -- 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]
MySQL and phpMyAdmin
I just installed phpMyAdmin, made the appropriate changes in the config.inc.php file, and got the following error when accessing it via both IE and Safari on Mac OS X Panther client. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I am using MySQL 4.1.10, the latest stable release, with phpMyAdmin-2.6.1-pl3, which the documentation says are compatible. Any help would be greatly appreciated. Thanks. - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and phpMyAdmin
Did you try searching on the error message first? I got hundreds of hits in Google for this. Searching the mysql docs, the first hit http://dev.mysql.com/doc/mysql/en/old-client.html has the explanation. The short version is that password security has been improved in mysql 4.1, so clients need to be compiled against a 4.1 mysql client library to work. Your copy of php, however, is compiled against an older version of the client library (probably 3.23). You can tell mysql to accept old-style passwords (details in the documentation linked above)for one or all users, but the better solution is to fix your copy of php, either by installing a php package pre-compiled against the newer client library, or by building php from source yourself using your copy of the mysql client library. Either way, you can find directions at the php site and elsewhere. Michael Asad Habib wrote: I just installed phpMyAdmin, made the appropriate changes in the config.inc.php file, and got the following error when accessing it via both IE and Safari on Mac OS X Panther client. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I am using MySQL 4.1.10, the latest stable release, with phpMyAdmin-2.6.1-pl3, which the documentation says are compatible. Any help would be greatly appreciated. Thanks. - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and phpMyAdmin
Even I had the same problem so I moved to using SQLyog and its an awesom client. http://www.webyog.com Karam --- Asad Habib [EMAIL PROTECTED] wrote: I just installed phpMyAdmin, made the appropriate changes in the config.inc.php file, and got the following error when accessing it via both IE and Safari on Mac OS X Panther client. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I am using MySQL 4.1.10, the latest stable release, with phpMyAdmin-2.6.1-pl3, which the documentation says are compatible. Any help would be greatly appreciated. Thanks. - Asad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RES: phpmyadmin can't connect via browser
Robert Restad wrote: I dont remember exactly what you have to do, But there is password incompability between versions of MySQL, latest versions doesnt accept the old password type. (I copied some MySQL raw datafiles from one computer to another, and I got the same problem as you) Research MySQL website for oldpassword or something, then you should find your answer. Regards Robert. -Mensagem original- De: Mark Sargent [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 14 de março de 2005 01:35 Para: mysql Assunto: 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 kB 00:00 Setting up Repo: base repomd.xml100% |=| 1.1 kB 00:00 Setting up Repo: updates-released repomd.xml100% |=| 951 B 00:00 Reading repository metadata in from local files dag : ## 1932/1932 base : ## 2622/2622 primary.xml.gz100% |=| 298 kB 00: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 kB 00: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 kB 00: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 kB 00:01 perl-DBD-MySQL-2.9003-5.i 100% |=| 111 kB 00: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:/sb in:/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. Hi All, ok, am I better off installing an earlier version, since they make it so damn hard just to get a simple thing working in php5..? Absolutely rediculous, this. Cheers. Mark Sargent. -- MySQL General Mailing List
Re: RES: phpmyadmin can't connect via browser
Mark Sargent wrote: Robert Restad wrote: snip snip 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. Hi All, ok, am I better off installing an earlier version, since they make it so damn hard just to get a simple thing working in php5..? Absolutely rediculous, this. Cheers. Mark Sargent. Perhaps the mysql, php and phpmyadmin documentation may help. I had phpmyadmin up and running in about 10 minutes. http://dev.mysql.com/doc/mysql/en/index.html http://www.php.net http://www.phpmyadmin.net The docs are most comprehensive and go over everything you have noted above. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpmyadmin can't connect via browser
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. 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: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]
RES: phpmyadmin can't connect via browser
I dont remember exactly what you have to do, But there is password incompability between versions of MySQL, latest versions doesnt accept the old password type. (I copied some MySQL raw datafiles from one computer to another, and I got the same problem as you) Research MySQL website for oldpassword or something, then you should find your answer. Regards Robert. -Mensagem original- De: Mark Sargent [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 14 de março de 2005 01:35 Para: mysql Assunto: 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 kB 00:00 Setting up Repo: base repomd.xml100% |=| 1.1 kB 00:00 Setting up Repo: updates-released repomd.xml100% |=| 951 B 00:00 Reading repository metadata in from local files dag : ## 1932/1932 base : ## 2622/2622 primary.xml.gz100% |=| 298 kB 00: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 kB 00: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 kB 00: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 kB 00:01 perl-DBD-MySQL-2.9003-5.i 100% |=| 111 kB 00: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:/sb in:/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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe
MySQL Error 1251 / phpMyAdmin
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error 1251 / phpMyAdmin
You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error 1251 / phpMyAdmin
I am still new to the PHP scene could you tell me how I rebuild the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen [EMAIL PROTECTED] wrote: You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Error 1251 / phpMyAdmin
I don't know much about the windows side of things so these are the only
resources I could find.
From the http://www.phpadmin.net site FAQ
[1.17a] I cannot connect to the MySQL server. It always returns the
error message, Client does not support authentication protocol
requested by server; consider upgrading MySQL client
You tried to access MySQL with an old MySQL client library. The version
of your MySQL client library can be checked in your phpinfo() output.
In general, it should have at least the same minor version as your
server - as mentioned in FAQ 1.17.
The only way to fix this problem is manually compiling php and its MySQL
extension against a current MySQL client library.
If you still face this problem, please compile your MySQL client library
against the same or a newer MySQL release.
From the http://www.php.net site mysql_connect function, while not
exactly the same version, the same problem occurs.
maybe you have seen this (using PHP 4.3.9 and MySQL client/server 4.1)
Error w/ php: mysql_connect(): Client does not support authentication
protocol
Solution:
mysql -u root-p
SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD('password');
It is clearly that this is a bug in PHP's mysql module, perhaps it will
be upgraded in the next version
Resource: http://forums.mysql.com/read.php?11,6400,6701#msg-6701
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: GH [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 8 February 2005 3:12 AM
To: mysql@lists.mysql.com; php-general; PHP DB
Subject: MySQL Error 1251 / phpMyAdmin
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8
I am receiving the enclosed error when I attempt to go into
phpMyAdmin and do not know how to solve the issue...
Any assistance would be greatful.
Thank you
Gary
//## ERROR RECIEVED //
Welcome to phpMyAdmin 2.6.1
phpMyAdmin tried to connect to the MySQL server, and the server
rejected the connection. You should check the host, username and
password in config.inc.php and make sure that they correspond to the
information given by the administrator of the MySQL server.
Error
MySQL said:
#1251 - Client does not support authentication protocol requested by
server
--
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]
MySQL insert with PHPMyAdmin
Can using PHPMyAdmin cause problems. What I'm doing is, I'm using PHPMyAdmi as a data entry tool. I create a new record in a table and then fill in the fields with the field editing and insert abilities of PHPMyAdmin. For a remote user of course I'd escape any inserted strings with addslashes or mysql_escape PHP functions. But I wouldn't do anything mailicious to my own DB so I'm just using PHPMyAdmin to insert, edit...anything. Are any problems possible by me doing this? Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL insert with PHPMyAdmin
As far as I know there should not be any problem but I prefer SQLyog for all my MySQL work. It even has HTTP Tunneling to access dbs that dont allow remote access. Karam --- leegold [EMAIL PROTECTED] wrote: Can using PHPMyAdmin cause problems. What I'm doing is, I'm using PHPMyAdmi as a data entry tool. I create a new record in a table and then fill in the fields with the field editing and insert abilities of PHPMyAdmin. For a remote user of course I'd escape any inserted strings with addslashes or mysql_escape PHP functions. But I wouldn't do anything mailicious to my own DB so I'm just using PHPMyAdmin to insert, edit...anything. Are any problems possible by me doing this? Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
It would be nice if phpMyAdmin would kindly note that on their website... Also, when I run a phpInfo()... it says i have the 3.23.49 could this be a contributing factor? On Sat, 1 Jan 2005 15:55:27 +0700, Willy Sudiarto Raharjo [EMAIL PROTECTED] wrote: Has anyone had any problems installing phpMyAdmin with the above configuration? I get an error about the mySql client and authentication methods? MySQL Error: 1251 : Client does not support authentication protocol requested by server MySQL 4.1.x is using a different authentication protocols so it may break phpmyadmin functionality. Use 4.0.x if you want to use phpmyadmin clearly or maybe you should wait for the next release -- Willy Sudiarto Raharjo Registered Linux User : 336579 Public-key : http://www.informatix.or.id/willy/public-key.txt Blog : http://willysr.blogspot.com OOo Documentation Project (ID) : http://project.informatix.or.id -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
The problem is not with phpmyadmin, the problem is with php. If you install 4.3 of php it will not work with mysql 4.1.8 or any version mysql 4.1 or 5.0. It will only work if you turn on the short passwords option in 4.1. I've not tried it on 5.0 lately. You can get it installed but it takes a little work. This is not a phpmyadmin bug it's all, it's not really a php, and it's not a mysql bug. I reported it to both phpmyadmin and php.net over a year ago. Think this is a problem, wait until you get a $40k 64 bit machine and try to install php on it via source because you want to use php 4.3 and mysql 4.1 and you find out you can't install anything because 64 bit installs stuff in different places than php is expecting it. And the php devel team has no plans on fix it. So you have to hack the config script to get it to work. Donny -Original Message- From: GH [mailto:[EMAIL PROTECTED] Sent: Saturday, January 01, 2005 1:15 PM To: Willy Sudiarto Raharjo; php-general; mysql@lists.mysql.com Subject: Re: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8 It would be nice if phpMyAdmin would kindly note that on their website... Also, when I run a phpInfo()... it says i have the 3.23.49 could this be a contributing factor? On Sat, 1 Jan 2005 15:55:27 +0700, Willy Sudiarto Raharjo [EMAIL PROTECTED] wrote: Has anyone had any problems installing phpMyAdmin with the above configuration? I get an error about the mySql client and authentication methods? MySQL Error: 1251 : Client does not support authentication protocol requested by server MySQL 4.1.x is using a different authentication protocols so it may break phpmyadmin functionality. Use 4.0.x if you want to use phpmyadmin clearly or maybe you should wait for the next release -- Willy Sudiarto Raharjo Registered Linux User : 336579 Public-key : http://www.informatix.or.id/willy/public-key.txt Blog : http://willysr.blogspot.com OOo Documentation Project (ID) : http://project.informatix.or.id -- 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]
phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
Has anyone had any problems installing phpMyAdmin with the above configuration? I get an error about the mySql client and authentication methods? MySQL Error: 1251 : Client does not support authentication protocol requested by server Please assist Happy New Year Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpmyadmin cannot create database
Hi folks, I'm trying phpmyadmin 2.6.0-pl3 with mysql 4.0.15 I notice that when I setup and use the pma user in the config, I cannot create database even when I login with root (using cookie auth). But if I don't use the pma options, I can create database. Can you shed a light on me pls? Thanks. -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 00:34:56 up 20:40, Mandrakelinux release 10.1 (Official) for i586 public key: https://www.arinet.org/fajar-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Install problems with phpMyAdmin
Hello experts, according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as following: shell su - enter shell mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ enter shell cd /usr/sbin/ enter shell tar -zxf phpMyAdmin-2.6.0-pl3.tar.tar enter shell rm phpMyAdmin-2.6.0-pl3.tar.tar shell mv phpMyAdmin-2.6.0-pl3/ phpMyAdmin shell phpMyAdmin/ enter At the configuration file I did following changes: shell vi config.inc.php $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin'; $cfg['Servers'][$i]['auth_type'] = 'http'; $cfg['Servers'][$i]['user'] = ''; After that I startet a browser(Mozilla) at that local server and entered: http://localhost/phpMyAdmin/ But unfortunately it appeared only the message The connection was refused when attempting to contact localhost. On that server runs a mysql server (V.4.0.22) which is placed in /usr/sbin/mysqld. I`m just a beginner with linux, mysql and phpMyAdmin. Who can give me support? Is there any additional software for PHP necessary? Thanks in advance Gunter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Install problems with phpMyAdmin
This may be a bit off-topic for the MySQL List but see below: Gunter Götz wrote: Hello experts, according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as following: shell su - enter shell mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ enter shell cd /usr/sbin/ enter shell tar -zxf phpMyAdmin-2.6.0-pl3.tar.tar enter shell rm phpMyAdmin-2.6.0-pl3.tar.tar shell mv phpMyAdmin-2.6.0-pl3/ phpMyAdmin shell phpMyAdmin/ enter phpmyadmin is a web application. You extracted it to your /usr/sbin directory which is probably not where your web server is looking for files (unless you directed it to do so in your httpd.conf). The default for Apache is in the apache install directory (often /usr/local/apache/html). At the configuration file I did following changes: shell vi config.inc.php $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin'; $cfg['Servers'][$i]['auth_type'] = 'http'; $cfg['Servers'][$i]['user'] = ''; After that I startet a browser(Mozilla) at that local server and entered: http://localhost/phpMyAdmin/ But unfortunately it appeared only the message The connection was refused when attempting to contact localhost. Sounds like your web server is either not running or is running on a different port (you would have to alter the std port in httpd.conf) On that server runs a mysql server (V.4.0.22) which is placed in /usr/sbin/mysqld. I`m just a beginner with linux, mysql and phpMyAdmin. Who can give me support? Is there any additional software for PHP necessary? To run phpmyadmin you need: Web Server that supports php (Apache is good, if you get Apache 2.0 use the prefork option with PHP, if you don't know what that is go with the 1.3.x versions for linux)-- www.apache.org MySQL-- www.mysql.com PHP-- www.php.net There are quite a few Linux distro's that can create all of this during install for you if you are unfamiliar with installing software on Linux. hth, Jason McKnight Mgr. Information Services The InSite Group,LLC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Install problems with phpMyAdmin
You might want to consider the following site and collection of s/w http://www.apachefriends.org I have successfully installed XAMPP on both Windoze Linux from their downloads. On Wed, 01 Dec 2004 08:44:49 -0500, Jason McKnight [EMAIL PROTECTED] wrote: This may be a bit off-topic for the MySQL List but see below: Gunter Götz wrote: Hello experts, according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as following: shell su - enter shell mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ enter shell cd /usr/sbin/ enter shell tar -zxf phpMyAdmin-2.6.0-pl3.tar.tar enter shell rm phpMyAdmin-2.6.0-pl3.tar.tar shell mv phpMyAdmin-2.6.0-pl3/ phpMyAdmin shell phpMyAdmin/ enter phpmyadmin is a web application. You extracted it to your /usr/sbin directory which is probably not where your web server is looking for files (unless you directed it to do so in your httpd.conf). The default for Apache is in the apache install directory (often /usr/local/apache/html). At the configuration file I did following changes: shell vi config.inc.php $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin'; $cfg['Servers'][$i]['auth_type'] = 'http'; $cfg['Servers'][$i]['user'] = ''; After that I startet a browser(Mozilla) at that local server and entered: http://localhost/phpMyAdmin/ But unfortunately it appeared only the message The connection was refused when attempting to contact localhost. Sounds like your web server is either not running or is running on a different port (you would have to alter the std port in httpd.conf) On that server runs a mysql server (V.4.0.22) which is placed in /usr/sbin/mysqld. I`m just a beginner with linux, mysql and phpMyAdmin. Who can give me support? Is there any additional software for PHP necessary? To run phpmyadmin you need: Web Server that supports php (Apache is good, if you get Apache 2.0 use the prefork option with PHP, if you don't know what that is go with the 1.3.x versions for linux)-- www.apache.org MySQL-- www.mysql.com PHP-- www.php.net There are quite a few Linux distro's that can create all of this during install for you if you are unfamiliar with installing software on Linux. hth, Jason McKnight Mgr. Information Services The InSite Group,LLC -- 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]
phpMyAdmin don't show table size
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]
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]
error with phpMyAdmin and MySQL 4.1.7
hi, I've just installed MySQL 4.1.7 when I try to launch phpMyAdmin I see this: Witamy w phpMyAdmin 2.5.5-pl1 phpMyAdmin próbowal polaczyc sie z serwerem MySQL, a serwer odrzucil polaczenie. Powinienes sprawdzic nazwe hosta, nazwe uzytkownika i haslo w pliku config.inc.php i upewnic sie, ze odpowiadaja one informacjom danym przez administratora serwera MySQL. Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 14 Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 15 Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 16 Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 17 Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 20 Serwer localhost Blad MySQL zwrócil komunikat: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client [Dokumentacja] in config.inc.php I have: $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = 'my_password';// MySQL password (only needed // with 'config' auth_type) I also have MySQL Connector/ODBC 3.51 installed [windows 2000, php 5] when I earlier installed MySQL 5 beta it worked good... what's wrong and how to correct this? with regards DeRyl -- 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]
phpMyAdmin and MySQL 4.1
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
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]
Problems with phpMyAdmin, GD library, and jpegs
Greetings, Am having some problems with phpMyAdmin, GD library and jpegs. Here is the short version of the story. I installed phpMyAdmin, modified a database to install a graphic image into one of the tables and it showed the graphic from within phpMyAdmin - no problem. I then wrote a very simple php route to connect to the database and display the record. - that failed with mention of a problem relating to GD library. I then went to the O'Reilly Programming PHP book and discovered that I needed the GD library. It stated that I should be able to do a phpinfo() and find the gd section of the report to find out it it was using the GD library. I got that installed and functioning using a simple example from the O'Reilly book and am able to get the black square on the screen. Now if I go to phpMyAdmin, I am not able to see the graphic in the database like before nor can I display the graphic from some basic php code. Am really stumped on this one. Can provide more detail to anybody that can assist in getting this problem solved. Thanks Keith Sys Admin Collins Computer Innovations
Re: Problems with phpMyAdmin, GD library, and jpegs
If you are storing a complete image in MySQL you don't need gd at all. Just output the correct header and the image file. GD is for creating images on the fly. Also if you can store the image in a file on disk and the path to the image in MySQL. -- Eric Bergen [EMAIL PROTECTED] On Mon, 27 Sep 2004 15:06:46 -0700, Keith Brownmiller [EMAIL PROTECTED] wrote: Greetings, Am having some problems with phpMyAdmin, GD library and jpegs. Here is the short version of the story. I installed phpMyAdmin, modified a database to install a graphic image into one of the tables and it showed the graphic from within phpMyAdmin - no problem. I then wrote a very simple php route to connect to the database and display the record. - that failed with mention of a problem relating to GD library. I then went to the O'Reilly Programming PHP book and discovered that I needed the GD library. It stated that I should be able to do a phpinfo() and find the gd section of the report to find out it it was using the GD library. I got that installed and functioning using a simple example from the O'Reilly book and am able to get the black square on the screen. Now if I go to phpMyAdmin, I am not able to see the graphic in the database like before nor can I display the graphic from some basic php code. Am really stumped on this one. Can provide more detail to anybody that can assist in getting this problem solved. Thanks Keith Sys Admin Collins Computer Innovations -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
showing dbs in terminal window opposed to phpmyadmin
How come when I am using the terminal on my mac os x 10.3.x and give the command show databases I only see one database (the 'test' database that is included in the install') as compared to viewing databases with my browser and phpmyadmin I can see 6 databases (that same 'test' database, a 'mysql' database that came with the install, and 4 other databases I created myself while in phpmyadmin)? Shouldn't I have access to all of them from the terminal as well? Thanks again, Doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: showing dbs in terminal window opposed to phpmyadmin
Are you loggin into the terminal and PHPmyadmin as the same user? -Original Message- From: Hull, Douglas D To: Note To MySQL List (E-mail) Sent: 8/23/04 8:30 AM Subject: showing dbs in terminal window opposed to phpmyadmin How come when I am using the terminal on my mac os x 10.3.x and give the command show databases I only see one database (the 'test' database that is included in the install') as compared to viewing databases with my browser and phpmyadmin I can see 6 databases (that same 'test' database, a 'mysql' database that came with the install, and 4 other databases I created myself while in phpmyadmin)? Shouldn't I have access to all of them from the terminal as well? Thanks again, Doug -- 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]
