Re: [PHP] PhpMyAdmin in EasyPHP cannot run DROP DATABASE
Hi Bastien, I've create new user but cannot find where to log out to change logged-in user. This is strange... On Thu, Aug 25, 2011 at 12:32 AM, Bastien Koert phps...@gmail.com wrote: On Wed, Aug 24, 2011 at 1:30 PM, Nam Gi VU nam.gi...@gmail.com wrote: Thanks Bastien for your suggestion. Though, I use the `root` account with `All privileges' but it still not allowing me to call `drop database'. What should I do next? On Wed, Aug 24, 2011 at 6:25 PM, Bastien phps...@gmail.com wrote: On 2011-08-23, at 6:44 AM, Nam Gi VU nam.gi...@gmail.com wrote: Hi every one, When trying to run my database script with `drop database` command, the server refuse and said as below screenshot. What should I do to enable this command? Regards, Nam Check that you phpmyadmin user account has the drop privilege. If not, grant that privilege or create another user account that does have more privileges Bastien -- Nam try creating another user account, that isn't root (always a good habit) and giving that account the needed privileges and then configure PMA to use that account. -- Bastien Cat, the other other white meat -- Nam
Re: [PHP] PhpMyAdmin in EasyPHP cannot run DROP DATABASE
On 2011-08-26, at 12:05 AM, Nam Gi VU nam.gi...@gmail.com wrote: Hi Bastien, I've create new user but cannot find where to log out to change logged-in user. This is strange... On Thu, Aug 25, 2011 at 12:32 AM, Bastien Koert phps...@gmail.com wrote: On Wed, Aug 24, 2011 at 1:30 PM, Nam Gi VU nam.gi...@gmail.com wrote: Thanks Bastien for your suggestion. Though, I use the `root` account with `All privileges' but it still not allowing me to call `drop database'. What should I do next? On Wed, Aug 24, 2011 at 6:25 PM, Bastien phps...@gmail.com wrote: On 2011-08-23, at 6:44 AM, Nam Gi VU nam.gi...@gmail.com wrote: Hi every one, When trying to run my database script with `drop database` command, the server refuse and said as below screenshot. What should I do to enable this command? Regards, Nam Check that you phpmyadmin user account has the drop privilege. If not, grant that privilege or create another user account that does have more privileges Bastien -- Nam try creating another user account, that isn't root (always a good habit) and giving that account the needed privileges and then configure PMA to use that account. -- Bastien Cat, the other other white meat -- Nam You don't. Change the config.in.php file to use the new account Bastien
Re: [PHP] PhpMyAdmin in EasyPHP cannot run DROP DATABASE
And in which section Bastien. Please be more specific. On Fri, Aug 26, 2011 at 11:14 AM, Bastien phps...@gmail.com wrote: On 2011-08-26, at 12:05 AM, Nam Gi VU nam.gi...@gmail.com wrote: Hi Bastien, I've create new user but cannot find where to log out to change logged-in user. This is strange... On Thu, Aug 25, 2011 at 12:32 AM, Bastien Koert phps...@gmail.com phps...@gmail.com wrote: On Wed, Aug 24, 2011 at 1:30 PM, Nam Gi VU nam.gi...@gmail.com nam.gi...@gmail.com wrote: Thanks Bastien for your suggestion. Though, I use the `root` account with `All privileges' but it still not allowing me to call `drop database'. What should I do next? On Wed, Aug 24, 2011 at 6:25 PM, Bastien phps...@gmail.com phps...@gmail.com wrote: On 2011-08-23, at 6:44 AM, Nam Gi VU nam.gi...@gmail.com nam.gi...@gmail.com wrote: Hi every one, When trying to run my database script with `drop database` command, the server refuse and said as below screenshot. What should I do to enable this command? Regards, Nam Check that you phpmyadmin user account has the drop privilege. If not, grant that privilege or create another user account that does have more privileges Bastien -- Nam try creating another user account, that isn't root (always a good habit) and giving that account the needed privileges and then configure PMA to use that account. -- Bastien Cat, the other other white meat -- Nam You don't. Change the config.in.php file to use the new account Bastien -- Nam
Re: [PHP] PhpMyAdmin in EasyPHP cannot run DROP DATABASE
On 2011-08-23, at 6:44 AM, Nam Gi VU nam.gi...@gmail.com wrote: Hi every one, When trying to run my database script with `drop database` command, the server refuse and said as below screenshot. What should I do to enable this command? Regards, Nam Check that you phpmyadmin user account has the drop privilege. If not, grant that privilege or create another user account that does have more privileges Bastien -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin in EasyPHP cannot run DROP DATABASE
Thanks Bastien for your suggestion. Though, I use the `root` account with `All privileges' but it still not allowing me to call `drop database'. What should I do next? On Wed, Aug 24, 2011 at 6:25 PM, Bastien phps...@gmail.com wrote: On 2011-08-23, at 6:44 AM, Nam Gi VU nam.gi...@gmail.com wrote: Hi every one, When trying to run my database script with `drop database` command, the server refuse and said as below screenshot. What should I do to enable this command? Regards, Nam Check that you phpmyadmin user account has the drop privilege. If not, grant that privilege or create another user account that does have more privileges Bastien -- Nam
Re: [PHP] PhpMyAdmin in EasyPHP cannot run DROP DATABASE
On Wed, Aug 24, 2011 at 1:30 PM, Nam Gi VU nam.gi...@gmail.com wrote: Thanks Bastien for your suggestion. Though, I use the `root` account with `All privileges' but it still not allowing me to call `drop database'. What should I do next? On Wed, Aug 24, 2011 at 6:25 PM, Bastien phps...@gmail.com wrote: On 2011-08-23, at 6:44 AM, Nam Gi VU nam.gi...@gmail.com wrote: Hi every one, When trying to run my database script with `drop database` command, the server refuse and said as below screenshot. What should I do to enable this command? Regards, Nam Check that you phpmyadmin user account has the drop privilege. If not, grant that privilege or create another user account that does have more privileges Bastien -- Nam try creating another user account, that isn't root (always a good habit) and giving that account the needed privileges and then configure PMA to use that account. -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin, localhost, mysql overhead
I haven't read all your mail, I'm sorry for it in advance, but I think that you should know that overheard is just a blasting phrase for something which was made up by phpmyadmin. Basically, when you run a lot of DELETE or UPDATE queries on a table an overhead is created, generally speaking this overhead is a space between rows in the database file, which will cause mysql engine to insert rows into this space on future INSERT queries. You can imagine your table as a hard drive, every couple of months (some may say weeks) you have to run a de-fragment on it, you can do the same with your database table, look up the query OPTIMIZE TABLE which will do the de-frag for you :) If you have any further questions feel free to bring them up. Regards, Nitsan On Fri, Jun 12, 2009 at 7:02 PM, Jônatas Zechim zechim@gmail.comwrote: Hi there, i have this table running on my localhost: CREATE TABLE `caffecheckout_compra_itens` ( `compra_key` varchar(23) NOT NULL, `item_id` int(5) NOT NULL, `item_valor` decimal(10,2) NOT NULL, `item_peso` decimal(5,3) NOT NULL, `item_qtd` int(3) NOT NULL, `item_data` int(10) NOT NULL, `item_obs` varchar(100) NOT NULL, PRIMARY KEY (`item_id`), KEY `compra_key` (`compra_key`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; It's on my Server, but when I add a row and after remove that I'd overhead this table (58bytes/row), anyone know why is this happening? I run this SQL: INSERT INTO caffecheckout_compra_itens (compra_key,item_id,item_valor,item_peso,item_qtd,item_data) VALUES ('12448259804a32897ce1116','2','19.90','0.250',1,'1244825980') ON DUPLICATE KEY UPDATE item_qtd=item_qtd+1 And after: DELETE FROM caffecheckout_compra_itens WHERE compra_key='12448259804a32897ce1116' Zechim -Mensagem original- De: Andrew Ballard [mailto:aball...@gmail.com] Enviada em: sexta-feira, 12 de junho de 2009 09:38 Para: revDAVE Cc: php-general@lists.php.net Assunto: Re: [PHP] Field type for american money On Thu, Jun 11, 2009 at 4:08 PM, revDAVEc...@hosting4days.com wrote: Php - MySQL - newbie question - Field type for american money - int(11) seems to work fine - but also I tried decimal(10,2) Is one a better choice than another for american money usage? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] It depends on what you need to store, honestly. If all your dollar amounts are integers, int would work fine. If you need decimals, decimal(10, 2) would be fine for a lot of applications. However, a lot of financial applications need a little more precision. SQL Server has a money datatype that looks like it's about equivalent to decimal(19, 4) and a smallmoney type that looks like it's equivalent to decimal(10, 4). That handles things like gas prices that always have that extra 9/10 of a penny tacked onto them, or items that are 3 for a dollar. If you enter a price of 0.33 in a decimal(10, 2) field, multiplying that by 3 will result in 0.99, whereas three items priced at 0. will come to 0., which when formatted to two digits will round to 1.00. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin, localhost, mysql overhead
There is no way to avoid it since whenever you delete a row in a myisam table you create a space in the order of the rows, this space is expressed by a little bit of extra file size of the database. This extra file size is called in phpmyadmin as overhead, you can kill this over head either by running some INSERT queries which will fill the space with the inserted rows or running an OPTIMISE query. In general, I don't think that there is anything that you should do or take care of, it is not rocket science and your tables will be good with or without the overhead ;) Nitsan On Fri, Jun 12, 2009 at 7:41 PM, Jônatas Zechim zechim@gmail.comwrote: I have other tables running but only this give me ‘overhead’. I’d know why this table does this and if is bad for my MySQL Server? Is there anyway to avoid it? Zechim De: nit...@binnun.co.il [mailto:nit...@binnun.co.il] Em nome de Nitsan Bin-Nun Enviada em: sexta-feira, 12 de junho de 2009 14:33 Para: Jônatas Zechim Cc: php-general@lists.php.net Assunto: Re: [PHP] phpMyAdmin, localhost, mysql overhead I haven't read all your mail, I'm sorry for it in advance, but I think that you should know that overheard is just a blasting phrase for something which was made up by phpmyadmin. Basically, when you run a lot of DELETE or UPDATE queries on a table an overhead is created, generally speaking this overhead is a space between rows in the database file, which will cause mysql engine to insert rows into this space on future INSERT queries. You can imagine your table as a hard drive, every couple of months (some may say weeks) you have to run a de-fragment on it, you can do the same with your database table, look up the query OPTIMIZE TABLE which will do the de-frag for you :) If you have any further questions feel free to bring them up. Regards, Nitsan On Fri, Jun 12, 2009 at 7:02 PM, Jônatas Zechim zechim@gmail.com wrote: Hi there, i have this table running on my localhost: CREATE TABLE `caffecheckout_compra_itens` ( `compra_key` varchar(23) NOT NULL, `item_id` int(5) NOT NULL, `item_valor` decimal(10,2) NOT NULL, `item_peso` decimal(5,3) NOT NULL, `item_qtd` int(3) NOT NULL, `item_data` int(10) NOT NULL, `item_obs` varchar(100) NOT NULL, PRIMARY KEY (`item_id`), KEY `compra_key` (`compra_key`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; It's on my Server, but when I add a row and after remove that I'd overhead this table (58bytes/row), anyone know why is this happening? I run this SQL: INSERT INTO caffecheckout_compra_itens (compra_key,item_id,item_valor,item_peso,item_qtd,item_data) VALUES ('12448259804a32897ce1116','2','19.90','0.250',1,'1244825980') ON DUPLICATE KEY UPDATE item_qtd=item_qtd+1 And after: DELETE FROM caffecheckout_compra_itens WHERE compra_key='12448259804a32897ce1116' Zechim -Mensagem original- De: Andrew Ballard [mailto:aball...@gmail.com] Enviada em: sexta-feira, 12 de junho de 2009 09:38 Para: revDAVE Cc: php-general@lists.php.net Assunto: Re: [PHP] Field type for american money On Thu, Jun 11, 2009 at 4:08 PM, revDAVEc...@hosting4days.com wrote: Php - MySQL - newbie question - Field type for american money - int(11) seems to work fine - but also I tried decimal(10,2) Is one a better choice than another for american money usage? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] It depends on what you need to store, honestly. If all your dollar amounts are integers, int would work fine. If you need decimals, decimal(10, 2) would be fine for a lot of applications. However, a lot of financial applications need a little more precision. SQL Server has a money datatype that looks like it's about equivalent to decimal(19, 4) and a smallmoney type that looks like it's equivalent to decimal(10, 4). That handles things like gas prices that always have that extra 9/10 of a penny tacked onto them, or items that are 3 for a dollar. If you enter a price of 0.33 in a decimal(10, 2) field, multiplying that by 3 will result in 0.99, whereas three items priced at 0. will come to 0., which when formatted to two digits will round to 1.00. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin, localhost, mysql overhead
Some important differences: InnoDB: -row level locking -transactional support -foreign key support MyISAM: -table-level locking -no transactions -no foreign keys If that doesn't sell you, definitely head to google :) On Fri, Jun 12, 2009 at 2:12 PM, Jônatas Zechim zechim@gmail.comwrote: I really don’t know the differences betwen MyISAM and InnoDB yet but I’ll google for it right now. Thank u. *Zechim* *De:* Eddie Drapkin [mailto:oorza...@gmail.com] *Enviada em:* sexta-feira, 12 de junho de 2009 15:05 *Para:* Nitsan Bin-Nun *Cc:* Jônatas Zechim; php-general@lists.php.net *Assunto:* Re: [PHP] phpMyAdmin, localhost, mysql overhead The better question is why are you using MyISAM tables? Unless there's a legitimate reason to prefer MyISAM over InnoDB, you should be using InnoDB. On Fri, Jun 12, 2009 at 2:01 PM, Nitsan Bin-Nun nitsa...@gmail.com wrote: There is no way to avoid it since whenever you delete a row in a myisam table you create a space in the order of the rows, this space is expressed by a little bit of extra file size of the database. This extra file size is called in phpmyadmin as overhead, you can kill this over head either by running some INSERT queries which will fill the space with the inserted rows or running an OPTIMISE query. In general, I don't think that there is anything that you should do or take care of, it is not rocket science and your tables will be good with or without the overhead ;) Nitsan On Fri, Jun 12, 2009 at 7:41 PM, Jônatas Zechim zechim@gmail.com wrote: I have other tables running but only this give me ‘overhead’. I’d know why this table does this and if is bad for my MySQL Server? Is there anyway to avoid it? Zechim De: nit...@binnun.co.il [mailto:nit...@binnun.co.il] Em nome de Nitsan Bin-Nun Enviada em: sexta-feira, 12 de junho de 2009 14:33 Para: Jônatas Zechim Cc: php-general@lists.php.net Assunto: Re: [PHP] phpMyAdmin, localhost, mysql overhead I haven't read all your mail, I'm sorry for it in advance, but I think that you should know that overheard is just a blasting phrase for something which was made up by phpmyadmin. Basically, when you run a lot of DELETE or UPDATE queries on a table an overhead is created, generally speaking this overhead is a space between rows in the database file, which will cause mysql engine to insert rows into this space on future INSERT queries. You can imagine your table as a hard drive, every couple of months (some may say weeks) you have to run a de-fragment on it, you can do the same with your database table, look up the query OPTIMIZE TABLE which will do the de-frag for you :) If you have any further questions feel free to bring them up. Regards, Nitsan On Fri, Jun 12, 2009 at 7:02 PM, Jônatas Zechim zechim@gmail.com wrote: Hi there, i have this table running on my localhost: CREATE TABLE `caffecheckout_compra_itens` ( `compra_key` varchar(23) NOT NULL, `item_id` int(5) NOT NULL, `item_valor` decimal(10,2) NOT NULL, `item_peso` decimal(5,3) NOT NULL, `item_qtd` int(3) NOT NULL, `item_data` int(10) NOT NULL, `item_obs` varchar(100) NOT NULL, PRIMARY KEY (`item_id`), KEY `compra_key` (`compra_key`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; It's on my Server, but when I add a row and after remove that I'd overhead this table (58bytes/row), anyone know why is this happening? I run this SQL: INSERT INTO caffecheckout_compra_itens (compra_key,item_id,item_valor,item_peso,item_qtd,item_data) VALUES ('12448259804a32897ce1116','2','19.90','0.250',1,'1244825980') ON DUPLICATE KEY UPDATE item_qtd=item_qtd+1 And after: DELETE FROM caffecheckout_compra_itens WHERE compra_key='12448259804a32897ce1116' Zechim -Mensagem original- De: Andrew Ballard [mailto:aball...@gmail.com] Enviada em: sexta-feira, 12 de junho de 2009 09:38 Para: revDAVE Cc: php-general@lists.php.net Assunto: Re: [PHP] Field type for american money On Thu, Jun 11, 2009 at 4:08 PM, revDAVEc...@hosting4days.com wrote: Php - MySQL - newbie question - Field type for american money - int(11) seems to work fine - but also I tried decimal(10,2) Is one a better choice than another for american money usage? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] It depends on what you need to store, honestly. If all your dollar amounts are integers, int would work fine. If you need decimals, decimal(10, 2) would be fine for a lot of applications. However, a lot of financial applications need a little more precision. SQL Server has a money datatype that looks like it's about equivalent to decimal(19, 4) and a smallmoney type that looks like it's equivalent to decimal(10, 4). That handles things like gas prices that always have
Re: [PHP] phpMyAdmin, suhosin, proper solutions
Yes, I read the documentation on how to make them play nice, and to me it is unacceptable to change suhosin settings intended to protect my users and my site from a malicious user so that I can use a web app that is not open to the public. No idea what the problems are (couldn't find a list of what the problems are) but Can you change the suhosin settings with a .htaccess? With the apache htpasswd protection it should be ok to disable some stuff for a particular directory. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin, suhosin, proper solutions
Chris wrote: Yes, I read the documentation on how to make them play nice, and to me it is unacceptable to change suhosin settings intended to protect my users and my site from a malicious user so that I can use a web app that is not open to the public. No idea what the problems are (couldn't find a list of what the problems are) but Can you change the suhosin settings with a .htaccess? With the apache htpasswd protection it should be ok to disable some stuff for a particular directory. I don't think you can change suhosin directive in a .htaccess file. I know you can't in a script itself (at least I couldn't) I think I'll try the php4 method. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] [solved] Re: [PHP] phpMyAdmin, suhosin, proper solutions
Michael A. Peters wrote: Chris wrote: Yes, I read the documentation on how to make them play nice, and to me it is unacceptable to change suhosin settings intended to protect my users and my site from a malicious user so that I can use a web app that is not open to the public. No idea what the problems are (couldn't find a list of what the problems are) but Can you change the suhosin settings with a .htaccess? With the apache htpasswd protection it should be ok to disable some stuff for a particular directory. I don't think you can change suhosin directive in a .htaccess file. Yes - you can (well, I didn't try in .htaccess - I did so in the apache config file itself). That solves everything :) Directory /srv/shastaherps/phpMyAdmin-3.1.3.1-english AuthUserFile /somesecretpath/.htpasswd AuthType basic Require valid-user AuthName Authentication Required php_flag suhosin.executor.disable_eval Off /Directory At least that works (allowing me to disable eval everywhere else) - so I'm guessing it should work with the other stuff as well. Thanks for the suggestion, I just assumed it wouldn't work as changing suhosin stuff via ini_set doesn't seem to work (understandably). -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Phpmyadmin password
VamVan schreef: .. May be u can do a bowl fish encryption ... Thanks, V LOL. 'bowl fish' ... 'fish bowl' ... I guess you meant to write 'blow' :-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Phpmyadmin password
Yeah true thanks for pointing out. Thats what I meant !!! :) Blowfish (http://en.wikipedia.org/wiki/Blowfish_(cipher)) On Thu, Dec 18, 2008 at 6:11 AM, Jochem Maas joc...@iamjochem.com wrote: VamVan schreef: .. May be u can do a bowl fish encryption ... Thanks, V LOL. 'bowl fish' ... 'fish bowl' ... I guess you meant to write 'blow' :-)
Re: [PHP] Phpmyadmin password
Yeah I felt the same. It should be config.inc.php. Well I dont think its in clear text though (alteast in the latest version). May be u can do a bowl fish encryption of your new custom password and reset it in the file. Thanks, V On Wed, Dec 17, 2008 at 9:01 AM, Jim Lucas li...@cmsws.com wrote: Micah Gersten wrote: It flance wrote: Hi, I lost phpmyadmin password. Is there anyway to recover it? Thank you PHPMyAdmin uses MySQL's internal authentication. Log into your MySQL server and reset your password. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com That is the case, but only if the op is using http auth if they are using config or cookie based, then it might/should be stored in the config.inc.php file. -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Phpmyadmin password
Micah Gersten wrote: It flance wrote: Hi, I lost phpmyadmin password. Is there anyway to recover it? Thank you PHPMyAdmin uses MySQL's internal authentication. Log into your MySQL server and reset your password. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com That is the case, but only if the op is using http auth if they are using config or cookie based, then it might/should be stored in the config.inc.php file. -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Phpmyadmin password
It flance wrote: Hi, I lost phpmyadmin password. Is there anyway to recover it? Thank you PHPMyAdmin uses MySQL's internal authentication. Log into your MySQL server and reset your password. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Phpmyadmin password
It flance wrote: Hi, I lost phpmyadmin password. Is there anyway to recover it? ask phpmyadmin: http://www.phpmyadmin.net/home_page/support.php -- Postgresql php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin
Ronald Wiplinger [EMAIL PROTECTED] wrote: I would like to use this time phpmyadmin (2.11.3) to setup for a new user a database, which he can use to setup his own tables for his web site. User abc should get his own database xyz. Yup, you can do this. Depending on how you are setting this up, you could theoretically put a separate phpmyadmin folder in each of the web folders of the users who use your services. Have you RTFM and set it up as the documentation stated and then tested it by logging in as the new user? http://www.phpmyadmin.net/home_page/docs.php Wolf -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpmyadmin
This is more of a SQL question that PHP. If you want to grant all privileges to abc to database xyz (minus GRANT), you should run these queries: CREATE DATABASE xyz; GRANT ALL PRIVILEGES ON xyz.* TO 'abc'@'somehost' IDENTIFIED BY 'somepassword'; -Original Message- From: Ronald Wiplinger [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2008 9:22 AM To: php-general@lists.php.net Subject: [PHP] phpmyadmin I would like to use this time phpmyadmin (2.11.3) to setup for a new user a database, which he can use to setup his own tables for his web site. User abc should get his own database xyz. I am not sure if I did it correct, and if it is safe to do so: A == 1. I created an empty database xyz (main page of phpmyadmin) 2. I added a new user on the Privileges page with: User: abc Host: Any (%) Password: (yes) Global privileges: (Data:) SELECT, INSERT, UPDATE, DELETE, FILE (Structure:) CREATE, ALTER, INDEX, DROP, CREATE TEMPORARY TABLES (Administration:)(nothing ticked) (Resource limits:) (nothing ticked) What does it mean so far? Can the user abc already access data of any database? B == I found Database-specific privileges for the user abc, where I added the database xyz and ticked: (Data:) SELECT, INSERT, UPDATE, DELETE (Structure:) CREATE, ALTER, INDEX, DROP, CREATE TEMPORARY TABLES (Administration:)(nothing ticked) What confuses me is that I have already some databases setup for my own web, but none of the users has B attached. Currently I am going away from a single person using the database to allow others also to use the database. Thanks for enlightening me. bye Ronald -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin slow on windows but fast on linux
Don Don wrote: Hi all how can i make my phpmyadmin run fast on windows ? I installed phpmyadmin on a linux and windows machines, but the windows version runs (executes) too slow, i.e. it takes to long for a page to be loaded, while it take less that 3 secs for the linux version. Both however run on the same system config. Linux tries using sockets by default if (mysql)host='localhost', that's almost twice as fast as host='127.0.0.1' (using a tcp connection). On a win box you need enable-named-pipe in your my.cnf and connect using host='.' for connecting not using tcp. skip-name-resolve can speed up things a bit as well. For finding the bottleneck you can try and connect the linux mysqld from your script on the win webserver and vice versa (using tcp of course). -- View this message in context: http://www.nabble.com/PhpMyAdmin-slow-on-windows-but-fast-on-linux-tf3627944.html#a10135939 Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PhpMyAdmin slow on windows but fast on linux
Hi Logan, yes reason being the linux box is live and the windows box is dev. Buesching, Logan J [EMAIL PROTECTED] wrote: You say they both have the same config, so do you mean that they both have the same version of PHP, same computer setup (Memory, CPU speed, HDD speed), both running the same version of Apache, and that both are running as either CGI or an apache module? -Logan -Original Message- From: Don Don [mailto:[EMAIL PROTECTED] Sent: Sunday, April 22, 2007 4:34 PM To: PHP List Subject: [PHP] PhpMyAdmin slow on windows but fast on linux Hi all how can i make my phpmyadmin run fast on windows ? I installed phpmyadmin on a linux and windows machines, but the windows version runs (executes) too slow, i.e. it takes to long for a page to be loaded, while it take less that 3 secs for the linux version. Both however run on the same system config. Cheers - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos.
Re: [PHP] PhpMyAdmin slow on windows but fast on linux
On Sunday 22 April 2007 22:33, Don Don wrote: Hi all how can i make my phpmyadmin run fast on windows ? Why would you when you got linux up and running? I installed phpmyadmin on a linux and windows machines, but the windows version runs (executes) too slow, i.e. it takes to long for a page to be loaded, while it take less that 3 secs for the linux version. Both however run on the same system config. It's not phpmyadmins fault, I've never had speed problem with/in windows in such manner. Of course that doesn't do much for suckiness Cheers - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. -- --- Børge http://www.arivene.net --- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PhpMyAdmin slow on windows but fast on linux
You say they both have the same config, so do you mean that they both have the same version of PHP, same computer setup (Memory, CPU speed, HDD speed), both running the same version of Apache, and that both are running as either CGI or an apache module? -Logan -Original Message- From: Don Don [mailto:[EMAIL PROTECTED] Sent: Sunday, April 22, 2007 4:34 PM To: PHP List Subject: [PHP] PhpMyAdmin slow on windows but fast on linux Hi all how can i make my phpmyadmin run fast on windows ? I installed phpmyadmin on a linux and windows machines, but the windows version runs (executes) too slow, i.e. it takes to long for a page to be loaded, while it take less that 3 secs for the linux version. Both however run on the same system config. Cheers - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin slow on windows but fast on linux
On 4/23/07, Don Don [EMAIL PROTECTED] wrote: Hi all how can i make my phpmyadmin run fast on windows ? I installed phpmyadmin on a linux and windows machines, but the windows version runs (executes) too slow, i.e. it takes to long for a page to be loaded, while it take less that 3 secs for the linux version. Both however run on the same system config. The phpmyadmin guys will be able to help you a lot better than we can: http://sourceforge.net/mail/?group_id=23067 -- Postgresql php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin for FC6
[EMAIL PROTECTED] wrote: Dear All, Which version of phpMyadmin are you using with FC6 ? Edward. Always the latest. cajb. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin for FC6
# [EMAIL PROTECTED] / 2007-02-23 21:23:37 +0800: Which version of phpMyadmin are you using with FC6 ? none -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin for FC6
cajbecu wrote: [EMAIL PROTECTED] wrote: Dear All, Which version of phpMyadmin are you using with FC6 ? Edward. Always the latest. cajb. Hello, For phpMyAdmin-2.10.0-rc1, http://192.168.0.1/error.php?lang=zh-TWdir=ltrtype=%E9%8C%AF%E8%AA%A4error= phpMyAdmin - error For phpMyAdmin-2.9.2, When I try to modify a record set, display from IE : tbl_replace.php: Missing parameter: goto (FAQ 2.8) ./Documentation.html#faqmissingparameters http://192.168.0.1/Documentation.html#faqmissingparameters Here are a few points to check: * In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] #cfg_PmaAbsoluteUri directive empty. See also FAQ 4.7 #faq4_7. But the default is empty. * Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134. How to Upgrade Zend Optimizer ? * If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint). The php is come from FC 6 System. * In the php.ini directive arg_separator.input, a value of ; will cause this error. Replace it with ;. Just try to modify the config and restart the web service, but still problem. * If you are using Hardened-PHP http://www.hardened-php.net/, you might want to increase request limits http://www.hardened-php.net/hphp/troubleshooting.html. No. Edward.
Re: [PHP] phpmyadmin mysql extensions
Move your dll's to C:\PHP\ext and restart apache... On Thu, 18 Jan 2007 10:20:23 -, Ross [EMAIL PROTECTED] wrote: did the following... -installed apache -installed php (C:\PHP) with the windows installer -moved my websites to the htdocs folder..so far so good can access pages - downlaoded php my admin to htdocs -downloaded the FULL php version -copied the extensions folder (C:\PHP\ext) -changd the line in php.ini extension_dir = C:\PHP\ext - the extensions in .ini look like this ;extension=php_mbstring.dll ;extension=php_bz2.dll ;extension=php_curl.dll ;extension=php_dba.dll ;extension=php_dbase.dll ;extension=php_exif.dll ;extension=php_fdf.dll ;extension=php_filepro.dll ;extension=php_gd2.dll ;extension=php_gettext.dll ;extension=php_ifx.dll ;extension=php_imap.dll ;extension=php_interbase.dll ;extension=php_ldap.dll ;extension=php_mcrypt.dll ;extension=php_mhash.dll ;extension=php_mime_magic.dll ;extension=php_ming.dll extension=php_mssql.dll extension=php_msql.dll extension=php_mysql.dll ;extension=php_oci8.dll ;extension=php_openssl.dll ;extension=php_oracle.dll ;extension=php_pgsql.dll ;extension=php_shmop.dll ;extension=php_snmp.dll ;extension=php_sockets.dll ;extension=php_sqlite.dll ;extension=php_sybase_ct.dll ;extension=php_tidy.dll ;extension=php_xmlrpc.dll ;extension=php_xsl.dll The .dll file is in C:\PHP\ext\mysql Phpmyadmin cannot load I get the error Cannot load mysql extension. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
You can, but it has nothing to do with PHP, and you shouldn't anyway. If you *CARE* about the ID numbers, then you're doing something wrong in the first place. On Sun, April 16, 2006 1:46 am, alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex At the top of the Structure page ( or any other when viewing a detailed table view) you should have an Empty tab at the top left. Hit that and it should reset the counter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
Jim Lucas wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex At the top of the Structure page ( or any other when viewing a detailed table view) you should have an Empty tab at the top left. Hit that and it should reset the counter also running the command: DELETE FROM `table_name` from the SQL box, should do the same trick -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
On 4/16/06, Jim Lucas [EMAIL PROTECTED] wrote: Jim Lucas wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex At the top of the Structure page ( or any other when viewing a detailed table view) you should have an Empty tab at the top left. Hit that and it should reset the counter also running the command: DELETE FROM `table_name` from the SQL box, should do the same trick That won't reset the counter. You'll probably need to do this after you delete all the data: update table set id=0; -- Postgresql php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
chris smith wrote: On 4/16/06, Jim Lucas [EMAIL PROTECTED] wrote: Jim Lucas wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex At the top of the Structure page ( or any other when viewing a detailed table view) you should have an Empty tab at the top left. Hit that and it should reset the counter also running the command: DELETE FROM `table_name` from the SQL box, should do the same trick That won't reset the counter. You'll probably need to do this after you delete all the data: update table set id=0; -- Postgresql php tutorials http://www.designmagick.com/ Well, I just tried it on a temp table that I have for my blog under Mysql and it did reset the autoindex to 1. Seems to work the way I said. Jim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
On 4/16/06, Jim Lucas [EMAIL PROTECTED] wrote: chris smith wrote: On 4/16/06, Jim Lucas [EMAIL PROTECTED] wrote: Jim Lucas wrote: alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex At the top of the Structure page ( or any other when viewing a detailed table view) you should have an Empty tab at the top left. Hit that and it should reset the counter also running the command: DELETE FROM `table_name` from the SQL box, should do the same trick That won't reset the counter. You'll probably need to do this after you delete all the data: update table set id=0; -- Postgresql php tutorials http://www.designmagick.com/ Well, I just tried it on a temp table that I have for my blog under Mysql and it did reset the autoindex to 1. Seems to work the way I said. Hmm, well there you go. Thanks for letting us know :) -- Postgresql php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex Select the desired database on the left. The browser will reload and show the STRUCTURE page. Click on the SQL tab; the browser should now load a page with a textarea that says Run SQL query/queries on database FOOBAR. Enter the following in the textarea: ALTER TABLE footable auto_increment=0; and then press the GO button. You can set the auto_increment number to any positive integer, AFAIK, though there might be a limit. :-) Kevin Kinsey -- Just because you're paranoid doesn't mean they AREN'T after you. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
At 4:46 PM +1000 4/16/06, alex wrote: hi everyone i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex Alex: This always works for me in mySQLAdmin. 1. Delete the first record. 2. Reset the auto_increment to whatever you want. 3. Insert a record. 4. Delete that record. After that, the next record will start at the new auto_increment. Don't ask why, that's just the way it works. If you want to reset the ID from within php, try this: // Renumber the Existing 'id' Sequence alter table $table_name drop id, add id int unsigned not null auto_increment first, auto_increment = 1; But, don't tell anyone that you did it AND especially don't tell anyone I gave you the code. This is a big no-no as decreed by the dB Gods and is seldom committed to written word. :-) tedd -- http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
Alex, Heres a very simple way to do exactly what you want as long as you are deleting all the records from the table: once you are in phpmyadmin you should have a frame with the database name(s) on the left and the tables on the right, click on the database name so that you have a list of tables in the right frame...click the table you want to reset on the left frame, the right frame will reload with that tables details then on the top right you will find a link that says empty click that and it will delete everything and reset everything Another way would be to simply export the table structure, drop the table and create it again... HTH Cheers, Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin--resetting auto increments to 0
Oops sorry, I made a little mistake here: click on the database name so that you have a list of tables in the *right* frameI meant: click on the database name so that you have a list of tables in the *LEFT* frameCheers,Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpMyAdmin--resetting auto increments to 0
[snip] i have delete a few entries in my database as they were entered for testing purposes and are no longer need (actually 102 entries)... and even thought that db is empty i noticed that when the next entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful [/snip] Darned basic SQL; TRUNCATE table Will empty the table and reset the auto-increment back to the beginning. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin import
On Mon, 23 Jan 2006 15:37:37 +0200 William Stokes [EMAIL PROTECTED] wrote: When importing data from file with phpmyadmin the file max size is 2 048kb. Can this be changed to accept larger files? Yes. Look at your php.ini file - change the upload_max_filesize to the filesize you want. Regards, Ozz. pgpMZkXrJgP7a.pgp Description: PGP signature
Re: [PHP] phpmyadmin import
Thanks. Got that one changed to 8Mb. I ran into another issue though. I'm tryin to import a 2,5 Mb table. PhpMyAdmin import ends with fatal error while importing. Here's the error message. Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 2247907 bytes) in /srv/www/htdocs/phpmyadmin/libraries/read_dump.lib.php on line 23 Something else that needs to be changed? I checked that file but it doesn't say much to me... Thanks Again -Will Austin Denyer [EMAIL PROTECTED] kirjoitti viestissä:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpmyadmin import
Hey Will, Following example will give you correct idea where to look. http://www.weberdev.com/get_example-3688.html Thanks, Richard Correia -Original Message- From: William Stokes [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 7:08 PM To: php-general@lists.php.net Subject: [PHP] phpmyadmin import Hello, When importing data from file with phpmyadmin the file max size is 2 048kb. Can this be changed to accept larger files? It would be more convenient to import data to my test DB if this could be done via single file export/import. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin import
Richard Correia wrote: Hey Will, Following example will give you correct idea where to look. http://www.weberdev.com/get_example-3688.html Will that take him to the phpMyAdmin site? ;) -- John C. Nichel IV Programmer/System Admin (ÜberGeek) Dot Com Holdings of Buffalo 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin import
On Mon, 23 Jan 2006 19:24:57 +0200 William Stokes [EMAIL PROTECTED] wrote: Thanks. Got that one changed to 8Mb. I ran into another issue though. I'm tryin to import a 2,5 Mb table. PhpMyAdmin import ends with fatal error while importing. Here's the error message. Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 2247907 bytes) in /srv/www/htdocs/phpmyadmin/libraries/read_dump.lib.php on line 23 Something else that needs to be changed? I checked that file but it doesn't say much to me... Check the following entry in your php.ini file: memory_limit It's possible you may also need to check this one, too: post_max_size Regards, Ozz. pgpWM0iEwMeiU.pgp Description: PGP signature
Re: [PHP] phpmyadmin import
On Mon, 2006-01-23 at 13:00 -0500, Austin Denyer wrote: Check the following entry in your php.ini file: memory_limit It's possible you may also need to check this one, too: post_max_size I realise that I may get flamed for this on a PHP list, but, generally when I import sql files to mysql larger than the PHP seetings can handle, I would use the mysql command line to do it: mysql \. /path/to/file.sql That way, in the case that it is just once off test data, you don't have to worry about fixing your PHP config later. OTOH if you do a lot of large imports then it probably is worth your while changing the php.ini in the ways described in this thread. --Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin problems with quoting exported text
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 -- 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin authentication error
I haven't used mysqli, so I'm not as familiar with errors related to that library, but you said you downloaded the latest package of MySQL, which is hopefully 4.1.12. This version shouldn't cause this error with mysqli. In my experience, this error has always been a case of PHP compiled against MySQL 3.x libraries, so that the PHP client is using the older authentication protocol of 3.23. See below for more information: http://dev.mysql.com/doc/mysql/en/old-client.html kgt Richard Lynch wrote: On Fri, May 13, 2005 3:56 pm, Sam Smith said: Because the install was from mysql.com I don't want to believe the client is out of date. I also don't know how to install another client. Most likely, it's Apple that's a bit behind the curve... So your phpMyAdmin is probably trying to use the mysqli client, but your MySQL server from Apple can only handle mysql client. See if you can get phpMyAdmin for the version of MySQL you have.
RE: [PHP] phpMyAdmin authentication error
I have experience with this on windows, and solved by change my root password on mySQL. I don't know, if this wil work on your OS X rgds -Original Message- From: Sam Smith [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 5:57 AM To: PHP Subject: [PHP] phpMyAdmin authentication error On OS X 10.3 I installed the latest MySQL from dev.mysql.com for OS X 10.3. It was a Apple style installer package with a binary of the server and the client. The docs weren't exactly written for OS X but I survived the set up and am able to login as the root MySQL user with the command line MySQL client. From version tracker I got phpMyAdmin-2.6.2-pl1.tar.bz2 which is just a .tar of a bunch of files you drop into the web server path. But phpMyAdmin gives the error, Client does not support authentication protocol requested by server; consider upgrading MySQL client. I don't see a way to change the auth protocol in the phpMyAdmin conf file: config.inc.php. If I create a MySQL user with no password phpMyAdmin works. Because the install was from mysql.com I don't want to believe the client is out of date. I also don't know how to install another client. Any one have any ideas? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin authentication error
On Fri, May 13, 2005 3:56 pm, Sam Smith said: Because the install was from mysql.com I don't want to believe the client is out of date. I also don't know how to install another client. Most likely, it's Apple that's a bit behind the curve... So your phpMyAdmin is probably trying to use the mysqli client, but your MySQL server from Apple can only handle mysql client. See if you can get phpMyAdmin for the version of MySQL you have. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin blank screen.
1- are you loading the mssql extensions or the mysql extensionsyou keep interchanging the two and they ARE NOT the same 2- in addition you may have to load the mysqli extension if you want to run phpMyAdmin. 3- re read the php manual and the phpMyAdmin If the screen is blank trying to read the source code to see if there is anything at all there. Then make sure php is running correctly and your databases are running correctly...i have a feeling one or both might not be. THEN, you have to make sure your extensions are compatible with the new password authenticaiton method begin used by phpMyAdmin. (this is where mysqli come into play). Ross wrote: Thanks for the replies to my php_mssql problem. I have a problem that when I try and run phpmyadmin locally the screen is just blank. Any ideas? R. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
On Sat, 1 Jan 2005 14:15:27 -0500, GH [EMAIL PROTECTED] wrote: It would be nice if phpMyAdmin would kindly note that on their website... http://www.phpmyadmin.net/documentation/ snip Note: phpMyAdmin's MySQL 4.1 support is experimental! /snip -- Greg Donald Zend Certified Engineer http://gdconsultants.com/ http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
does anyone know of a simular tool that will work/has 4.1 support? thanks On Sat, 1 Jan 2005 14:33:05 -0600, Greg Donald [EMAIL PROTECTED] wrote: On Sat, 1 Jan 2005 14:15:27 -0500, GH [EMAIL PROTECTED] wrote: It would be nice if phpMyAdmin would kindly note that on their website... http://www.phpmyadmin.net/documentation/ snip Note: phpMyAdmin's MySQL 4.1 support is experimental! /snip -- Greg Donald Zend Certified Engineer http://gdconsultants.com/ http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
Donny Simonton wrote: 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. If you use the mysqli extension with it, it works *fine*. But you need PHP 5 for that... 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. that has already been fixed a couple of weeks ago... 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] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
On Sat, 2005-01-01 at 16:48, Donny Simonton wrote: 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. Try paying someone on the PHP dev team $40k to fix it. You might find it fixed the same day. You are, after all, using free and open source software, the onus is on you to make things work the way you want when it deviates from the default. It's funny when someone complains about free software when they have $40k hardware. Makes me want to cry... NOT! As a side comment... did you happen to kick back a patch to the PHP team for the changes you made to the config script? Cheers, Rob. -- .. | InterJinn Application Framework - http://www.interjinn.com | :: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
Yes, I did send in a patch just like the 3 or 4 other people who had the same problem. I'm not complaining about php, I was just commenting about the person complaining that it was a problem with phpmyadmin. I complained about the problem over a year ago, when I first installed mysql 4.1.0, but the problem was definitely not with phpmyadmin. It was a combination of php not working well with mysql 4.1.0. Why would have pay somebody 40k a year, I can do it myself or anyone of my other 20 programmers. When php says it's not a bug, then obviously they don't see it as being a problem. Since all 32 bit servers will be phased out by mid-May because of the opteron and the new intel procs, I'll just sit back and watch the bug submissions come in next year as everybody gets their new hardware in. I won't complain, I know how to fix it. Donny -Original Message- From: Robert Cummings [mailto:[EMAIL PROTECTED] Sent: Saturday, January 01, 2005 6:55 PM To: Donny Simonton Cc: 'GH'; '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 On Sat, 2005-01-01 at 16:48, Donny Simonton wrote: 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. Try paying someone on the PHP dev team $40k to fix it. You might find it fixed the same day. You are, after all, using free and open source software, the onus is on you to make things work the way you want when it deviates from the default. It's funny when someone complains about free software when they have $40k hardware. Makes me want to cry... NOT! As a side comment... did you happen to kick back a patch to the PHP team for the changes you made to the config script? Cheers, Rob. -- .. | InterJinn Application Framework - http://www.interjinn.com | :: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
Donny Simonton wrote: Yes, I did send in a patch just like the 3 or 4 other people who had the same problem. I'm not complaining about php, I was just commenting about the person complaining that it was a problem with phpmyadmin. I complained about the problem over a year ago, when I first installed mysql 4.1.0, but the problem was definitely not with phpmyadmin. It was a combination of php not working well with mysql 4.1.0. How is this a 'problem' with PHP? It was MySQL who changed how passwords were handled by default. However, it's not even a MySQL problem...it's not a problem at all. MySQL added in backwards capabiilty for passwords. Why would have pay somebody 40k a year, I can do it myself or anyone of my other 20 programmers. When php says it's not a bug, then obviously they don't see it as being a problem. It's not a problem. There is a workaround for it. It's that simple. Why should the PHP people rewrite the MySQL functions when a) the amount of people using php v4.x and MySQL = 4.1.x are small, and b) it will work if you take the time to read. Since all 32 bit servers will be phased out by mid-May because of the opteron and the new intel procs, I'll just sit back and watch the bug submissions come in next year as everybody gets their new hardware in. All phased out by mid-May??? All where? Maybe at Intercosmos (even though I doubt that), but 32 bit servers will still exist, more that likely as the majority, long after May. Most companies are not going to shell out the duckies to 'upgrade' to 64-bit when a) alot of the software hasn't been battle tested, b) there are no big advantages to it in the LAMP world, and c) there is no big outcry from the customer base to make the switch. I won't complain, I know how to fix it. And I'll refrain from getting personal. -- By-Tor.com ...it's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin equivalent
Watty wrote: Does anyone know of a program equivalent to phpMyAdmin for managing PostgreSQL databases? Watty bet you didn't google for phppgadmin -- Raditha Dissanayake. http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 128 KB | with progress bar. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpMyAdmin equivalent
You can't google for something you don't know about ;) Thanks for that, looks exactly what I was looking for Watty -Original Message- From: raditha dissanayake [mailto:[EMAIL PROTECTED] Sent: 14 August 2004 16:29 Cc: [EMAIL PROTECTED] Subject: Re: [PHP] phpMyAdmin equivalent Watty wrote: Does anyone know of a program equivalent to phpMyAdmin for managing PostgreSQL databases? Watty bet you didn't google for phppgadmin -- Raditha Dissanayake. http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 128 KB | with progress bar. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin equivalent
* Thus wrote Watty: You can't google for something you don't know about ;) Haven't you heard? Google has ESP and can read your mind.. You just have to keep thinking this phrase: Google: phpMyAdmin PostgreSQL equivalent Curt -- First, let me assure you that this is not one of those shady pyramid schemes you've been hearing about. No, sir. Our model is the trapezoid! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin equivalent
On Saturday 14 August 2004 23:25, Watty wrote: You can't google for something you don't know about ;) Surely it would have crossed your mind to check on the postgresql site? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Pascal is not a high-level language. -- Steven Feiner */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpMyAdmin equivalent
I'm an ignorant human being :| Watty -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED] Sent: 14 August 2004 17:11 To: [EMAIL PROTECTED] Subject: Re: [PHP] phpMyAdmin equivalent On Saturday 14 August 2004 23:25, Watty wrote: You can't google for something you don't know about ;) Surely it would have crossed your mind to check on the postgresql site? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Pascal is not a high-level language. -- Steven Feiner */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpmyadmin and UTF
[snip] Guten Morgen habe gerade im Apache den Default Zeichensatz auf UTF-8 gesetzt und in der phpmyadmin ebenfalls. In der phpadmin GUI habe ich de-utf-8 ausgewählt. Nun kommt folgende Fehlermeldung von phpmyadmin: Die PHP-Erweiterungen iconv und recode, welche für die Zeichensatzkonvertierung benötigt werden, konnten nicht geladen werden. Bitte ändern Sie Ihre PHP-Konfiguration und aktivieren Sie diese Erweiterungen oder deaktivieren Sie die Zeichensatzkonvertierung in phpMyAdmin. Wie kann man das beheben ? [snip] Sie müssen um dieses auf der phpmyadminliste bitten. Sie wünschen Ihre Anzeige zu Englisch übersetzen, bevor Sie senden. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin
On Monday 24 May 2004 04:04 pm, Chris W wrote: It sounds like this is for adding the date and time to file name for the backup but I can't figure out how it works. Maybe an email to the phpMyAdmin list will get you an answer faster than in here? James -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin
From: Chris W [EMAIL PROTECTED] I am using phpmyadmin to backup my mysql database. I have it setup to backup all databases and at the bottom there is this foot note . . . * Use __DB__ for database name, __TABLE__ for table name and any strftime http://www.php.net/manual/function.strftime.php options for time specification, extension will be automagically added. Any other text will be preserved. It sounds like this is for adding the date and time to file name for the backup but I can't figure out how it works. Using a filename such as dbdump.__DB__.__TABLE__.%B.sql would result in a filename of dbdump.mydatabasename.mytablename.may.sql for example. I assume all of this, actually, as I've never used this system/feature. That's how it should work, though. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin Problems
Helpful, isn't he. If you can't find it in your config file, post again and I'll show you what i have in mine. John Jason Wong wrote: This has nothing to do with PHP. Please ask on the relevant list/forum. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin Problems
John Taylor-Johnston wrote: Helpful, isn't he. If you can't find it in your config file, post again and I'll show you what i have in mine. John Jason Wong wrote: This has nothing to do with PHP. Please ask on the relevant list/forum. Thanks. Actually, I have another question: Can someone recommend a relevant list/forum? I visited phpmyadmin.net and finally found their help forum (listed under Feedback), but it's temporarily out of commission. The relevant newsgroup appears to be out of action, too. In the meantime, I posted my question on a general web design forum and was told to not worry about it because you probably won't need those functions anyway. If true, then I won't complain; saves a lot of time. I did fix the DATE problem I referenced in the URL I provided. It was just a matter of changing it to NOT NULL, though my table still isn't working properly. I'm not sure what the it I'm supposed to find in my config file is, but I'd love to see what you have in yours! :) You could either post it here or e-mail me at [EMAIL PROTECTED] I've been thinking it might be kind of cool to start a new website that features nothing but properly tweaked scripts that people can check out - the infamous Apache conf file, PHP config, etc. Most are probably available somewhere or other, but bringing them together under one roof could be a big help. Thanks again. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin Problems
On Wednesday 11 February 2004 16:42, John Taylor-Johnston wrote: Helpful, isn't he. If you can't find it in your config file, post again and I'll show you what i have in mine. John It's hardly helpful asking your tailor about a problem with your leaky roof is it? Ask the right questions at the right place and hopefully you'll get the right answer. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Take your Senator to lunch this week. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin Problems
Jason Wong wrote: On Wednesday 11 February 2004 16:42, John Taylor-Johnston wrote: Helpful, isn't he. If you can't find it in your config file, post again and I'll show you what i have in mine. John It's hardly helpful asking your tailor about a problem with your leaky roof is it? It is if my landlord's married to a tailor! :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin Problems
Freedomware wrote: I've been using both phpMyAdmin and EMS MySQL Manager to work with MySQL tables and PHP. Things are generally going OK, but I'm still ironing out a few kinks. I suspect some of my problems might be related to an error message I get when I click on a Database in phpMyAdmin: Error: The additional Features for working with linked Tables have been deactivated. To find out why click here. When I click the link, I get a page that lists six different problems, each linked to a pretty complex solution in the phpMyAdmin Manual. Does anyone here know if there's an easier solution? Would fixing one or two key problems automatically fix the others? Can you download files that have already been fixed, add your username and password and paste them into the proper folders? I put a couple screenshots that illustrate what I described online at http://geowebworks.geobop.org/test/phpmyadmin/index.php Thanks. You can happily work with phpmyadmin with the features turned off. You did not tell us what the kicks are - no help. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin Problems
Hi, perhaps this is best posted on the phpmyadmin list? Freedomware wrote: I've been using both phpMyAdmin and EMS MySQL Manager to work with MySQL tables and PHP. Things are generally going OK, but I'm still ironing out a few kinks. I suspect some of my problems might be related to an error message I get when I click on a Database in phpMyAdmin: Error: The additional Features for working with linked Tables have been deactivated. To find out why click here. When I click the link, I get a page that lists six different problems, each linked to a pretty complex solution in the phpMyAdmin Manual. Does anyone here know if there's an easier solution? Would fixing one or two key problems automatically fix the others? Can you download files that have already been fixed, add your username and password and paste them into the proper folders? I put a couple screenshots that illustrate what I described online at http://geowebworks.geobop.org/test/phpmyadmin/index.php Thanks. -- Raditha Dissanayake. http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 150 KB | with progress bar. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin Problems
On Wednesday 11 February 2004 12:47, Freedomware wrote: I've been using both phpMyAdmin and EMS MySQL Manager to work with MySQL tables and PHP. Things are generally going OK, but I'm still ironing out a few kinks. I suspect some of my problems might be related to an error message I get when I click on a Database in phpMyAdmin: [snip] This has nothing to do with PHP. Please ask on the relevant list/forum. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* It's fabulous! We haven't seen anything like it in the last half an hour! -- Macy's */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin foulup
Did you set the password for root user in mysql? Then you need to enter the password in [phpmyadmin directory]/config.inc.php. Find line: $cfg['Servers'][$i]['password'] = ''; and enter the password here ---^ Leevy, Joffrey L wrote: Hi all: I was trying to use phpmyadmin for the first time and messed up when trying to give the [EMAIL PROTECTED] a password. I did that because phpmyadmin told me something about lax security using root with no password. Anyhow something went wrong. Now I can't do anything with phpadmin or mysql client.The message is - Error 1045: Access Denied for User: (Using Password:No). Grateful for anyone's help. Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin form onsubmit
Again, check phpmyadmin html source code. If your query begins with anything potentionaly destructive (DELETE, ALTER, DROP ...) it displays a confirm (not alert). John Taylor-Johnston wrote: What about some javascript to alert() and decide if the form executes like phpmyadmin does: http://ccl.flsh.usherbrooke.ca/example.jpg This would save me time coding PHP. How can I accomplish this? What does the onsubmit look like? John * Thus wrote John Taylor-Johnston ([EMAIL PROTECTED]): Any ideas? I want to avoid having two mysql_query($sql). I'm basically looking for better functionality and wanting to learn how to clean up my code. there are a couple options, the insert has a extra option, 'ON DUPLICATE KEY': http://www.mysql.com/doc/en/INSERT.html Or use the REPLACE syntax: http://www.mysql.com/doc/en/REPLACE.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin form onsubmit
What about some javascript to alert() and decide if the form executes like phpmyadmin does: http://ccl.flsh.usherbrooke.ca/example.jpg This would save me time coding PHP. How can I accomplish this? What does the onsubmit look like? John * Thus wrote John Taylor-Johnston ([EMAIL PROTECTED]): Any ideas? I want to avoid having two mysql_query($sql). I'm basically looking for better functionality and wanting to learn how to clean up my code. there are a couple options, the insert has a extra option, 'ON DUPLICATE KEY': http://www.mysql.com/doc/en/INSERT.html Or use the REPLACE syntax: http://www.mysql.com/doc/en/REPLACE.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin to output CSV to excel (including fieldnames)
At 21:33 16-6-2003, you wrote: I see all the options in phpMyAdmin for CSV/excel output but I can't get it to export the fieldnames, headers as well. It'd be nice to have it automatically do that into excel so the output is easier to follow and provide to someone else. Am I just missing the option in phpMyAdmin or does it not output the fieldnames into CSV/excel? There are quite some choices in phpMyAdmin, i did not check but they are pretty self explanatory. I wrote myself a script that, when linked from a browser, returns a csv file. I still have some problems with the delimitations in some version of Excel and with opening it from Mozille Firebird, but you may like it. If all data ends op in row A of Excel, the field delimiter goes wrong. (a)nticopyright 2003 Chris - as many examples over the net inspired me (but i did not particularly copy any of them) ?PHP //**// //* QUERY PART *// //**// include('config.php'); // with $config array containing host etc. mysql_connect($config['dbhost'], $config['dbuname'], $config['dbpass']); mysql_select_db($config['dbname']) or die (brfont color=\red\Unable to select database./font); $query=SELECT time, Titles,Initials,First_Name,Family_Name,Institute,E_mail,Telephone FROM SYMP2003 ORDER BY time; // query depends on url variable 'n': if ($_GET['n']==2) $query=SELECT time, Titles, Initials, First_Name,Family_Name,Position,SENSE_Institute,Address,E_mail,Telephone,Fax FROM SYMP2003 ; if ($_GET['n']==3) $query=SELECT * FROM SYMP2003 ; $result=mysql_query($query) or die (mysql_error()); //**// //* BUILD DATA PART *// //**// $string_csv=''; while ($myrow = mysql_fetch_array($result,MYSQL_ASSOC)) { foreach ($myrow as $value) {$string_csv .= \.str_replace('','',str_replace(\r,'',$value)).\,;} $string_csv .= \n; // line end } //**// //* SEND AS FILE*// //**// if (strstr($_SERVER[HTTP_USER_AGENT],MSIE 5.5)) {$att = ;} else {$att = attachment;;} header(Expires: Mon, 26 Jul 1997 05:00:00 GMT); // Date in the past header(Last-Modified: . gmdate(D, d M Y H:i:s) . GMT); // always modified header(Cache-Control: no-store, no-cache, must-revalidate); // HTTP/1.1 header(Cache-Control: post-check=0, pre-check=0, false); header(Pragma: no-cache); // HTTP/1.0 header(Content-type: text/csv); header('Content-Disposition: inline; filename=MyFileName.csv'); echo $string_csv; exit; ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin duplication of sql
have you attempted to simply create the table and column using the sql text box (ie not using the create table interface)? eg pasting and submitting something like: CREATE TABLE t2 ( y varchar(5) ) TYPE=MyISAM; (I appreciate this does not address the reason behind the actual problem you are having but it should get the job done) David -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin duplication of sql
Duplicate column name 'y' Back It means what it said. You are trying to create a table with two columns with the same name. --- Michael Gaab [EMAIL PROTECTED] wrote: i am using the phpmyadmin interface to develop a small web based application. when i create a table i get the following error. for some reason the query inserts a duplicate. any help appreciated, mike Error SQL-query : CREATE TABLE `t2` ( `y` VARCHAR( 5 ) NOT NULL , `y` VARCHAR( 5 ) NOT NULL ) MySQL said: Duplicate column name 'y' Back -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin duplication of sql
Daniel Guerrier [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Duplicate column name 'y' Back It means what it said. You are trying to create a table with two columns with the same name. no i use the textfields presented with the interface. i create a new table with 1 field and name that field 'y' ..., submit the request and then phpmyadmin generates the error but i have only create a table with one field. i am simple trying to specify what that one field is. thanks,mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin for Microsoft SQL
There is nothing for MS SQL that I know. phpMyAdmin was used for mySQL initially and then some volunteers like you made postreSQL and Oracle versions of it. So, you might want to try one on your own on SourceForge :) -- Maxim Maletsky [EMAIL PROTECTED] Joshua E Minnie [EMAIL PROTECTED] wrote... : Hey all, Does any body know of anything similar to phpMyAdmin for MS SQL? I have been doing some googling and haven't come across anything that would help me out. I have also checked out www.sourceforge.net and can't seem to come across anything either. I am looking for something that will be easy enough for my client to utilize to update/manipulate a database, rather than having me re-create the wheel so-to-speak. -- Joshua Minnie Advantage Computer Services, LLC Senior Project Manager [EMAIL PROTECTED] www.advantagecomputerservices.com Tel: 269.276.9690 Fax : 269.342.8750 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin for Microsoft SQL
I might just have to do that, thanks. Maxim Maletsky wrote: There is nothing for MS SQL that I know. phpMyAdmin was used for mySQL initially and then some volunteers like you made postreSQL and Oracle versions of it. So, you might want to try one on your own on SourceForge :) -- Maxim Maletsky [EMAIL PROTECTED] Joshua E Minnie [EMAIL PROTECTED] wrote... : Hey all, Does any body know of anything similar to phpMyAdmin for MS SQL? I have been doing some googling and haven't come across anything that would help me out. I have also checked out www.sourceforge.net and can't seem to come across anything either. I am looking for something that will be easy enough for my client to utilize to update/manipulate a database, rather than having me re-create the wheel so-to-speak. -- Joshua Minnie Advantage Computer Services, LLC Senior Project Manager [EMAIL PROTECTED] www.advantagecomputerservices.com Tel: 269.276.9690 Fax : 269.342.8750 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin : password and user (Help)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Try changing the username from username to [EMAIL PROTECTED] On Sunday 01 December 2002 01:21 pm, Iguider wrote: Hi Please I need a help, I used to work with asp and now I am migrating to php, my site web works perfectly on my PC (windows). I am runing phpMyAdmin 2.2.6, and easyphp on local machine . when my host give me a username and password, I want to change the file phpMyAdmin/config.inc.php from user=root to user=username and from password= to password=password, the phpMyAdmin show me Host 'localhost' is not allowed to connect to this MySQL server even if i setup the default values. the phpMyAdmin/config.inc.php is : $cfgServers[$i]['host'] = 'localhost'; // MySQL hostname $cfgServers[$i]['port'] = ''; // MySQL port - leave blank for default port $cfgServers[$i]['socket']= ''; // Path to the socket - leave blank for default socket $cfgServers[$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') $cfgServers[$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfgServers[$i]['controlpass'] = ''; // access to the mysql/user // and mysql/db tables) $cfgServers[$i]['auth_type'] = 'config';// Authentication method (config, http or cookie based)? $cfgServers[$i]['user'] = 'root'; // MySQL user $cfgServers[$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) $cfgServers[$i]['only_db'] = ''; // If set to a db-name, only // this db is displayed // at left frame // It may also be an array // of db-names $cfgServers[$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname $cfgServers[$i]['bookmarkdb']= ''; // Bookmark db - leave blank for no bookmark support $cfgServers[$i]['bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support $cfgServers[$i]['relation'] = ''; // table to describe the relation between links (see doc) // - leave blank for no relation-links support $i++; $cfgServers[$i]['host'] = ''; $cfgServers[$i]['port'] = ''; $cfgServers[$i]['socket']= ''; $cfgServers[$i]['connect_type'] = 'tcp'; $cfgServers[$i]['controluser'] = ''; $cfgServers[$i]['controlpass'] = ''; $cfgServers[$i]['auth_type'] = 'config'; $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = ''; $cfgServers[$i]['verbose'] = ''; $cfgServers[$i]['bookmarkdb']= ''; $cfgServers[$i]['bookmarktable'] = ''; $cfgServers[$i]['relation'] = ''; $i++; $cfgServers[$i]['host'] = ''; $cfgServers[$i]['port'] = ''; $cfgServers[$i]['socket']= ''; $cfgServers[$i]['connect_type'] = 'tcp'; $cfgServers[$i]['controluser'] = ''; $cfgServers[$i]['controlpass'] = ''; $cfgServers[$i]['auth_type'] = 'config'; $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = ''; $cfgServers[$i]['verbose'] = ''; $cfgServers[$i]['bookmarkdb']= ''; $cfgServers[$i]['bookmarktable'] = ''; $cfgServers[$i]['relation'] = ''; - -- To assert that the earth revolves around the sun is as erroneous as to claim that Jesus was not born of a virgin. - -Cardinal Bellarmino -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE96oVe/rncFku1MdIRAlGnAKCCeUAyjFNuM+2iPzxzbH8vgNwRVACfWchW z5zyWAUzYF4UI89dVFmdv/o= =AvD/ -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin 2.2.6
On Sun, 12 Nov 2000 22:25:59 - Iguider [EMAIL PROTECTED] wrote: I am running normally a phpMyAdmin 2.2.6, until yesterday it shows me : So it works now? I will assume no... Describe your system to the list and what could have possibly be changed yesterday. You might have an solution soon. -- Maxim Maletsky [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin please help
Hi thanks a lot John Nichel and Stephan , I understand now. I put blank in password and it works. thanks. but after that in the next day (as I said my previous email) : Mysql stop working and shows : Host 'localhost' is not allowed to connect to this MySQL server thanks for help - Original Message - From: John Nichel [EMAIL PROTECTED] To: Iguider [EMAIL PROTECTED] Cc: PHP List [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 12:20 AM Subject: Re: [PHP] phpMyAdmin please help See below Iguider wrote: in my dtabase.php : $dbHost = ; $dbUser = Amazigh; $dbPassword = mcamca; $dbName = Forum; $db = mysql_connect($dbHost, $dbUser, $dbPassword); mysql_select_db($dbName, $db); $dbHost is empty. If the script is on the same machine as the MySQL db, set it to localhost. If the script is on a different machine, set it to the name of that machine (and make sure that your $dbUser has rights to access the database remotly). MySQL usernames and passwords are case sensitive. and in phpMyAdmin's config.inc.php : $cfgServers[$i]['user'] = 'root'; // MySQL user $cfgServers[$i]['password'] = ''; // MySQL password If you have a root password, fill it in. Seeing that it won't let you connect via phpMyAdmin, the db probably has a root password. - Original Message - From: Stephen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: PHP List [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:14 PM Subject: Re: [PHP] phpMyAdmin please help You may also want to check your forum's database.php after checking the phpMyAdmin's config.inc.php. - Original Message - From: John Nichel [EMAIL PROTECTED] To: Iguider [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 11, 2002 4:47 PM Subject: Re: [PHP] phpMyAdmin please help Look at the config.inc.php file in the phpMyAdmin install directory. Iguider wrote: Hi I have a furom working under php 4.0 and when I upgrade it to php 4.2 by installing the new version of easyphp 1.6.0.0 . the new phpMyAdmin is 2.2.6 . when I run the forum or I tried to re-create a tables in mySQL database with a install.php it shows me the following errors : Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp\www\forum\database.php on line 8 are there in phpMyAdmin where to give a database username and password ? when I copy the old database and i try to start the forum it shows me acces denied to name@localhost (password : ok) . Please help -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w -- By-Tor.com It's all about the Rush http://www.by-tor.com __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin please help
Look at the config.inc.php file in the phpMyAdmin install directory. Iguider wrote: Hi I have a furom working under php 4.0 and when I upgrade it to php 4.2 by installing the new version of easyphp 1.6.0.0 . the new phpMyAdmin is 2.2.6 . when I run the forum or I tried to re-create a tables in mySQL database with a install.php it shows me the following errors : Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp\www\forum\database.php on line 8 are there in phpMyAdmin where to give a database username and password ? when I copy the old database and i try to start the forum it shows me acces denied to namelocalhost (password : ok) . Please help -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin please help
You may also want to check your forum's database.php after checking the phpMyAdmin's config.inc.php. - Original Message - From: John Nichel [EMAIL PROTECTED] To: Iguider [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 11, 2002 4:47 PM Subject: Re: [PHP] phpMyAdmin please help Look at the config.inc.php file in the phpMyAdmin install directory. Iguider wrote: Hi I have a furom working under php 4.0 and when I upgrade it to php 4.2 by installing the new version of easyphp 1.6.0.0 . the new phpMyAdmin is 2.2.6 . when I run the forum or I tried to re-create a tables in mySQL database with a install.php it shows me the following errors : Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp\www\forum\database.php on line 8 are there in phpMyAdmin where to give a database username and password ? when I copy the old database and i try to start the forum it shows me acces denied to name@localhost (password : ok) . Please help -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin please help
in my dtabase.php : $dbHost = ; $dbUser = Amazigh; $dbPassword = mcamca; $dbName = Forum; $db = mysql_connect($dbHost, $dbUser, $dbPassword); mysql_select_db($dbName, $db); and in phpMyAdmin's config.inc.php : $cfgServers[$i]['host'] = 'localhost'; // MySQL hostname $cfgServers[$i]['port'] = ''; // MySQL port - leave blank for default port $cfgServers[$i]['socket']= ''; // Path to the socket - leave blank for default socket $cfgServers[$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or socket') $cfgServers[$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfgServers[$i]['controlpass'] = ''; // access to the mysql/user // and mysql/db tables) $cfgServers[$i]['auth_type'] = 'config';// Authentication method (config, http or cookie based)? $cfgServers[$i]['user'] = 'root'; // MySQL user $cfgServers[$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) $cfgServers[$i]['only_db'] = ''; // If set to a db-name, only thanks - Original Message - From: Stephen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: PHP List [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:14 PM Subject: Re: [PHP] phpMyAdmin please help You may also want to check your forum's database.php after checking the phpMyAdmin's config.inc.php. - Original Message - From: John Nichel [EMAIL PROTECTED] To: Iguider [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 11, 2002 4:47 PM Subject: Re: [PHP] phpMyAdmin please help Look at the config.inc.php file in the phpMyAdmin install directory. Iguider wrote: Hi I have a furom working under php 4.0 and when I upgrade it to php 4.2 by installing the new version of easyphp 1.6.0.0 . the new phpMyAdmin is 2.2.6 . when I run the forum or I tried to re-create a tables in mySQL database with a install.php it shows me the following errors : Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp\www\forum\database.php on line 8 are there in phpMyAdmin where to give a database username and password ? when I copy the old database and i try to start the forum it shows me acces denied to name@localhost (password : ok) . Please help -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin please help
Your username and passwords are different. Try changing the forum's name and password to root for user and leave password blank. - Original Message - From: Iguider [EMAIL PROTECTED] To: PHP List [EMAIL PROTECTED] Sent: Monday, November 11, 2002 5:41 PM Subject: Re: [PHP] phpMyAdmin please help in my dtabase.php : $dbHost = ; $dbUser = Amazigh; $dbPassword = mcamca; $dbName = Forum; $db = mysql_connect($dbHost, $dbUser, $dbPassword); mysql_select_db($dbName, $db); and in phpMyAdmin's config.inc.php : $cfgServers[$i]['host'] = 'localhost'; // MySQL hostname $cfgServers[$i]['port'] = ''; // MySQL port - leave blank for default port $cfgServers[$i]['socket']= ''; // Path to the socket - leave blank for default socket $cfgServers[$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or socket') $cfgServers[$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfgServers[$i]['controlpass'] = ''; // access to the mysql/user // and mysql/db tables) $cfgServers[$i]['auth_type'] = 'config';// Authentication method (config, http or cookie based)? $cfgServers[$i]['user'] = 'root'; // MySQL user $cfgServers[$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) $cfgServers[$i]['only_db'] = ''; // If set to a db-name, only thanks - Original Message - From: Stephen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: PHP List [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:14 PM Subject: Re: [PHP] phpMyAdmin please help You may also want to check your forum's database.php after checking the phpMyAdmin's config.inc.php. - Original Message - From: John Nichel [EMAIL PROTECTED] To: Iguider [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 11, 2002 4:47 PM Subject: Re: [PHP] phpMyAdmin please help Look at the config.inc.php file in the phpMyAdmin install directory. Iguider wrote: Hi I have a furom working under php 4.0 and when I upgrade it to php 4.2 by installing the new version of easyphp 1.6.0.0 . the new phpMyAdmin is 2.2.6 . when I run the forum or I tried to re-create a tables in mySQL database with a install.php it shows me the following errors : Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp\www\forum\database.php on line 8 are there in phpMyAdmin where to give a database username and password ? when I copy the old database and i try to start the forum it shows me acces denied to name@localhost (password : ok) . Please help -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin please help
See below Iguider wrote: in my dtabase.php : $dbHost = ; $dbUser = Amazigh; $dbPassword = mcamca; $dbName = Forum; $db = mysql_connect($dbHost, $dbUser, $dbPassword); mysql_select_db($dbName, $db); $dbHost is empty. If the script is on the same machine as the MySQL db, set it to localhost. If the script is on a different machine, set it to the name of that machine (and make sure that your $dbUser has rights to access the database remotly). MySQL usernames and passwords are case sensitive. and in phpMyAdmin's config.inc.php : $cfgServers[$i]['user'] = 'root'; // MySQL user $cfgServers[$i]['password'] = ''; // MySQL password If you have a root password, fill it in. Seeing that it won't let you connect via phpMyAdmin, the db probably has a root password. - Original Message - From: Stephen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: PHP List [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:14 PM Subject: Re: [PHP] phpMyAdmin please help You may also want to check your forum's database.php after checking the phpMyAdmin's config.inc.php. - Original Message - From: John Nichel [EMAIL PROTECTED] To: Iguider [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 11, 2002 4:47 PM Subject: Re: [PHP] phpMyAdmin please help Look at the config.inc.php file in the phpMyAdmin install directory. Iguider wrote: Hi I have a furom working under php 4.0 and when I upgrade it to php 4.2 by installing the new version of easyphp 1.6.0.0 . the new phpMyAdmin is 2.2.6 . when I run the forum or I tried to re-create a tables in mySQL database with a install.php it shows me the following errors : Warning: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: MySQL Connection Failed: Unknown MySQL Server Host 'mySQL' (22) in e:\program files\easyphp\www\forum\database.php on line 7 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in e:\program files\easyphp\www\forum\database.php on line 8 are there in phpMyAdmin where to give a database username and password ? when I copy the old database and i try to start the forum it shows me acces denied to name@localhost (password : ok) . Please help -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w __ Modem offert : 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Haut débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Phpmyadmin HELP!!!
On Monday 04 November 2002 07:16, Rodrigo de Oliveira Costa wrote: Hi people, After I installed phpmyadmin on my computer that runs an Apache I've worked almost everything out. The only problem I seem to have is that when I create a Database I can't put more than 8 columns and if I do it simply doesnt accept it. Another problem that it looks like I'm having is that when I log into a database it shows all the tables in that database on my left but if I click on a table with more than 8 columns, that I created in the DOS, it simply doesnt show the details. HELP!!! I think phpmyadmin has its own mailing list. You should be asking on there. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* I used to be disgusted, now I find I'm just amused. -- Elvis Costello */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin Help Needed
What web server are u using? If you are using apache you need to make sure you have the user directive set up properly for this. Plus, in the user directory u need to have the appropriate directory too. By default apache has it set to look for public_html... So in the user directory you would have ~username/public_html On Wed, 2002-10-16 at 16:08, Pushpinder Singh Garcha wrote: Hi I am wanting to use PhpMyAdmin for my project . I am developing using PHP and MySQl and the OS is Jaguar I have downloaded the latest version of phpmyadmin and have made necessary changes in the 'config.inc.php' file When I try to access PhpMyAdmin using http://localhost/~pgarcha/phpmyadmin/index.php; I get the folowing error Not Found The requested URL /~pgarcha/phpmyadmin/index.php was not found on this server. Apache/1.3.26 Server at pushpinder-garchas-computer.local Port 80 This is the list of things that I have changed: 1). $cfg['PmaAbsoluteUri'] = 'http://localhost/~pgarcha/phpmyadmin/'; 2). $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)? 3). $cfg['Servers'][$i]['user'] = 'root'; // MySQL user 4). $cfg['Servers'][$i]['password'] = 'sunny'; // MySQL password (only needed // with 'config' auth_type) I am not sure about the user attribute that I have put above actually pgarcha' is the admin of the system. Please help me out. Thanks in advance Pushpinder Pushpinder Singh Garcha _ Web Developer T. Falcon Napier and Associates, Inc. Off : 704 987 6500 Cell : 704 236 2939 Fax : 704 987 5002 _ -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin Help Needed
sounds like an apache config problem to me, if it is not even getting there... perhaps you should check the httpd.conf file to look into the UserDir settings to make sure the path is a web accessible path. -Brad Pushpinder Singh Garcha wrote: Hi I am wanting to use PhpMyAdmin for my project . I am developing using PHP and MySQl and the OS is Jaguar I have downloaded the latest version of phpmyadmin and have made necessary changes in the 'config.inc.php' file When I try to access PhpMyAdmin using http://localhost/~pgarcha/phpmyadmin/index.php; I get the folowing error Not Found The requested URL /~pgarcha/phpmyadmin/index.php was not found on this server. Apache/1.3.26 Server at pushpinder-garchas-computer.local Port 80 This is the list of things that I have changed: 1). $cfg['PmaAbsoluteUri'] = 'http://localhost/~pgarcha/phpmyadmin/'; 2). $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)? 3). $cfg['Servers'][$i]['user'] = 'root'; // MySQL user 4). $cfg['Servers'][$i]['password'] = 'sunny'; // MySQL password (only needed // with 'config' auth_type) I am not sure about the user attribute that I have put above actually pgarcha' is the admin of the system. Please help me out. Thanks in advance Pushpinder Pushpinder Singh Garcha _ Web Developer T. Falcon Napier and Associates, Inc. Off : 704 987 6500 Cell : 704 236 2939 Fax : 704 987 5002 _ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin Help Needed
Hi, This doesn't seem to be a PHP error at all, but rather Apache telling you that it's unable to find your files. Are you sure you're pointing your browser to the correct location? Try putting a simple HTML file in your PHPMyAdmin directory and calling that one up. If you still get an error, then you're pointing your browser to the wrong location. Cheers, Marco On Wed, 2002-10-16 at 18:08, Pushpinder Singh Garcha wrote: Hi I am wanting to use PhpMyAdmin for my project . I am developing using PHP and MySQl and the OS is Jaguar I have downloaded the latest version of phpmyadmin and have made necessary changes in the 'config.inc.php' file When I try to access PhpMyAdmin using http://localhost/~pgarcha/phpmyadmin/index.php; I get the folowing error Not Found The requested URL /~pgarcha/phpmyadmin/index.php was not found on this server. Apache/1.3.26 Server at pushpinder-garchas-computer.local Port 80 This is the list of things that I have changed: 1). $cfg['PmaAbsoluteUri'] = 'http://localhost/~pgarcha/phpmyadmin/'; 2). $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)? 3). $cfg['Servers'][$i]['user'] = 'root'; // MySQL user 4). $cfg['Servers'][$i]['password'] = 'sunny'; // MySQL password (only needed // with 'config' auth_type) I am not sure about the user attribute that I have put above actually pgarcha' is the admin of the system. Please help me out. Thanks in advance Pushpinder Pushpinder Singh Garcha _ Web Developer T. Falcon Napier and Associates, Inc. Off : 704 987 6500 Cell : 704 236 2939 Fax : 704 987 5002 _ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin Help Needed
Try something for me change the localhost to 127.0.0.1 Also look at the public_html settings for each user... Timothy Hitchens (HiTCHO) [EMAIL PROTECTED] Pushpinder Singh Garcha wrote: Hi I am wanting to use PhpMyAdmin for my project . I am developing using PHP and MySQl and the OS is Jaguar I have downloaded the latest version of phpmyadmin and have made necessary changes in the 'config.inc.php' file When I try to access PhpMyAdmin using http://localhost/~pgarcha/phpmyadmin/index.php; I get the folowing error Not Found The requested URL /~pgarcha/phpmyadmin/index.php was not found on this server. Apache/1.3.26 Server at pushpinder-garchas-computer.local Port 80 This is the list of things that I have changed: 1). $cfg['PmaAbsoluteUri'] = 'http://localhost/~pgarcha/phpmyadmin/'; 2). $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)? 3). $cfg['Servers'][$i]['user'] = 'root'; // MySQL user 4). $cfg['Servers'][$i]['password'] = 'sunny'; // MySQL password (only needed // with 'config' auth_type) I am not sure about the user attribute that I have put above actually pgarcha' is the admin of the system. Please help me out. Thanks in advance Pushpinder Pushpinder Singh Garcha _ Web Developer T. Falcon Napier and Associates, Inc. Off : 704 987 6500 Cell : 704 236 2939 Fax : 704 987 5002 _ -- Timothy Hitchens (HiTCHO) Web Application Analyst and Developer e-mail: [EMAIL PROTECTED] mobile: 0419 521 440 - HiTCHO Group - ABN: 85 816 540 110 Web Site: http://www.hitcho.com.au/ Snail Mail: PO Box 101 Arana Hills QLD 4054 Telephone: 07 3351 0951 - Facsimile: 07 3351 0952 IMPORTANT: This email may be the view of the individual and not that of the organisation. The contents of this electronic mail (including attachments) may be privileged and commercially confidential. Any unauthorised use of the contents is expressly prohibited. If you have received this document in error, please advise us by telephone immediately and then delete the document. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin Help Needed
On Wed, 16 Oct 2002 18:08:30 -0400 Pushpinder Singh Garcha [EMAIL PROTECTED] wrote: Hi I am wanting to use PhpMyAdmin for my project . I am developing using PHP and MySQl and the OS is Jaguar I have downloaded the latest version of phpmyadmin and have made necessary changes in the 'config.inc.php' file When I try to access PhpMyAdmin using http://localhost/~pgarcha/phpmyadmin/index.php; I get the folowing error Not Found The requested URL /~pgarcha/phpmyadmin/index.php was not found on this server. hm.. let me guess, First of all, I hope you are sure you accessed the right file. Second, make sure the URL you set in $cfg['PmaAbsoluteUri'] is something accessible via browser. Apache/1.3.26 Server at pushpinder-garchas-computer.local Port 80 This is the list of things that I have changed: 1). $cfg['PmaAbsoluteUri'] = 'http://localhost/~pgarcha/phpmyadmin/'; 2). $cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)? 3). $cfg['Servers'][$i]['user'] = 'root'; // MySQL user 4). $cfg['Servers'][$i]['password'] = 'sunny'; // MySQL you shouldn't have left this part :) password (only needed // with 'config' auth_type) I am not sure about the user attribute that I have put above actually pgarcha' is the admin of the system. Please help me out. user is what you use for connectingto mySQL database, password is mySQL's passwrd. If you are the root, you might as well be able just set user:root and password and empty string. Should work. Maxim maletsky [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PhpMyAdmin Help Needed
On Wednesday, Oct 16, 2002, at 23:08 Europe/London, Pushpinder Singh Garcha wrote: I am wanting to use PhpMyAdmin for my project . I am developing using PHP and MySQl and the OS is Jaguar I have downloaded the latest version of phpmyadmin and have made necessary changes in the 'config.inc.php' file When I try to access PhpMyAdmin using http://localhost/~pgarcha/phpmyadmin/index.php; I get the folowing error Not Found The requested URL /~pgarcha/phpmyadmin/index.php was not found on this server. That error is being generated by Apache and is therefore nothing to do with the phpMyAdmin configuration file. My guess is that you have the case wrong. Try http://localhost/~pgarcha/phpMyAdmin/index.php -- Stuart -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php