[PHP-DB] phpmyadmin error
Hi All, Sory if this question not belongs to this forum... I use PhpMyAdmin to control mysql database. and I want to set relationship between tables in mysql database... all things needed to make relationship have been set appears message : 'general relation features : enable' but I just cant get the table-relationship link in PhpMyAdmin... such error msg appears : The additional Features for working with linked Tables have been deactivated. By regard; Sukanto
Re: [PHP-DB] PhpmyAdmin from external computers
However, when i connect to that computer from my windows computer and go to the phpmyadmin url it wont let me do anything. Ive set all the priveleges to allow full access in every way, but it still wont let me access it What error do you get? -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fw: [PHP-DB] PhpmyAdmin from external computers
I do not get an error message as such. I goto http://serverIP/phpmyadmin/index.php - and it logs me inautomatically as localhost, i can see the database lists on the side panel etc. I click on a database or create a new database and the login screen comes up. I try entering the root password and username, but it just comes up with : #1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) and ive tried with a blank password as well. I have the auth_type in config.inc.php (PhpMyAdmin) set to 'config' and the username and password for mysql is in their respective places. - Original Message - From: mike karthauser [EMAIL PROTECTED] To: Sent: Thursday, December 04, 2003 2:34 PM Subject: Re: [PHP-DB] PhpmyAdmin from external computers However, when i connect to that computer from my windows computer and go to the phpmyadmin url it wont let me do anything. Ive set all the priveleges to allow full access in every way, but it still wont let me access it What error do you get? -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fw: [PHP-DB] PhpmyAdmin from external computers
Im afraid ive already tried that. - Original Message - From: mike karthauser [EMAIL PROTECTED] To: Sent: Thursday, December 04, 2003 3:10 PM Subject: Re: [PHP-DB] PhpmyAdmin from external computers I goto http://serverIP/phpmyadmin/index.php - and it logs me inautomatically as localhost, i can see the database lists on the side panel etc. I click on a database or create a new database and the login screen comes up. I try entering the root password and username, but it just comes up with : #1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) and ive tried with a blank password as well. I have the auth_type in config.inc.php (PhpMyAdmin) set to 'config' and the username and password for mysql is in their respective places. Logging in as root with no password remotely is not good. Try making another user logged in locally with user and password, then try that from remote. -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PhpmyAdmin from external computers
Hi I have phpMyAdmin installed on my red hat 8 box with mysql 3. It works fine on that computer and phpmyadmin gives me full access to the database. However, when i connect to that computer from my windows computer and go to the phpmyadmin url it wont let me do anything. Ive set all the priveleges to allow full access in every way, but it still wont let me access it Any clue ? Andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PhpmyAdmin from external computers
Hello!! You need change your Usernames' host to your IP or simply change it to % (Any host). This is all changed in MYSQL. Good Luck!! Dan On Dec 4, 2003, at 9:36 AM, [EMAIL PROTECTED] wrote: Hello Andy, Thursday, December 4, 2003, 3:27:11 PM, you wrote: AL Im afraid ive already tried that. Are you sure your MySQL server is actually configured to ALLOW someone to login remotely? I know most of the ones I work with aren't. This isn't a setting you'll find in phpMyAdmin btw. Most MySQL servers are locked down in this way for (very good) security reasons, to the point that it wouldn't surprise me if this wasn't the default after installation (I don't know for sure it is though). -- Best regards, Richardmailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Fw: [PHP-DB] PhpmyAdmin from external computers
Hello Andy, Thursday, December 4, 2003, 3:27:11 PM, you wrote: AL Im afraid ive already tried that. Are you sure your MySQL server is actually configured to ALLOW someone to login remotely? I know most of the ones I work with aren't. This isn't a setting you'll find in phpMyAdmin btw. Most MySQL servers are locked down in this way for (very good) security reasons, to the point that it wouldn't surprise me if this wasn't the default after installation (I don't know for sure it is though). -- Best regards, Richardmailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PhpmyAdmin from external computers
I goto http://serverIP/phpmyadmin/index.php - and it logs me inautomatically as localhost, i can see the database lists on the side panel etc. I click on a database or create a new database and the login screen comes up. I try entering the root password and username, but it just comes up with : #1045 - Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) and ive tried with a blank password as well. I have the auth_type in config.inc.php (PhpMyAdmin) set to 'config' and the username and password for mysql is in their respective places. Logging in as root with no password remotely is not good. Try making another user logged in locally with user and password, then try that from remote. -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] phpMyAdmin produces error on PHP
I am using Red Hat 9 which comes with PHP. I have installed mySQL and tested it from terminal - it seems to be working fine. I am very new to Linux though. phpMyAdmin is producing the following error message from the browser cannot load MySQL extension, please check PHP configuration. DOCUMENTATION (link) I have checked the documentation, and it says to install a package called PHP-MySQL. I have downloaded this and (i think) installed it. But the error message remains. I am not that great with Linux - so any help you can provide will be very appreciated. Thank you Andy
[PHP-DB] phpmyadmin screwup
Hi all: I was trying to use phpmyadmin for the first time and messed up when trying to give the [EMAIL PROTECTED] a password. I did that because phpmyadmin told me something about lax security using root with no password. Anyhow something went wrong. Now I can't do anything with phpadmin or mysql client.The message is - Error 1045: Access Denied for User: (Using Password:No). Grateful for anyone's help. Thanks - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: [PHP-DB] phpmyadmin screwup
this should fix ya.. http://www.mysql.com/doc/en/Resetting_permissions.html hth Jeff Joffrey Leevy [EMAIL PROTECTED]To: [EMAIL PROTECTED] ahoo.comcc: Subject: [PHP-DB] phpmyadmin screwup 11/04/2003 04:30 PM Hi all: I was trying to use phpmyadmin for the first time and messed up when trying to give the [EMAIL PROTECTED] a password. I did that because phpmyadmin told me something about lax security using root with no password. Anyhow something went wrong. Now I can't do anything with phpadmin or mysql client.The message is - Error 1045: Access Denied for User: (Using Password:No). Grateful for anyone's help. Thanks - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] phpmyadmin screwup
I'm not to familiar with the jargon. Do I use the code (shellmysql...) in a query box because it's giving me a syntax error. thanks J - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
[PHP-DB] phpMyAdmin Query Window Not Working - HELP!
novice here. the phpMyAdmin Query Window fails. If I enter a query, any query, nothing happens when I click Go. The Go button doesn't do anything. querywindow.php displays the login dialog, and appears to accept my password. When the myadmin Query Window loads, the ie status-bar may display Done, but with errors.. If I click the text-box in the query window, the status-bar always displays Error on page. This is before I have entered any query string at all. Please help. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] phpMyAdmin-Problem
hi! i have mysql 3.23.38 running on a IIS4 and php 4.3.2 i used phpmyadmin 2.3.2 with cookie authentication and everything worked well. until i wanted to upgrade phpmyadmin to 2.5.1 (last stable release). i configured everything inside config.inc.php (added a controluser, etc) but now i cannot login anymore by cookie-authenticaion. i do not even get a wrong password or username-error the phpmyadmin-faq contains this question: [1.3] I'm running phpMyAdmin with cookie authentication mode under PHP 4.2.0 or 4.2.1 loaded as an Apache 2+ module but can't enter the script: I'm always displayed the login screen. This is a known PHP bug (see this bug report) from the official PHP bug database. It means there is and won't be any phpMyAdmin fix against it because there is no way to code a fix. is this the same for php 4.3.2 and IIS4 ? thx in advance .ma -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] phpMyAdmin
Ok, maybe this is strictly a phpMyAdmin Q, but I'm sure many of use it =) I have a server at home which runs phpMyAdmin. I also run it locally on my laptop. The cfg_uri for both is http://localhost/phpMyAdmin/ When I open a web browser (IE), I go to http://mydomainonmyserverathome/phpMyAdmin Then when I try to work with my database at home. All of a sudden, it acts as if I were trying to work on the db which is on my laptop. So here are my steps: 1. go to http://mydomainonmyserverathome/phpMyAdmin 2. Try to create a table which exists on my laptop but not on my server at home 3. Get message that table already exists 4. view list of tables on the left nav and they contain all the db's which are on my laptop. Help please!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] phpMyAdmin for Windows?
I have a site that is on a Windows Server : and having problems with the Hoster giving me telnet access to Admin MySQL. Is there some thing like phpMyAdmin for Windows. I want to put it in a folder on my site to manage the DB. I thought of developing my own, but why build it if it exist already. Thanks, Mark. _ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation www.SykesCanada.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] phpMyAdmin for Windows?
phpMyAdmin uses PHP and PHP is available for windows. So if I understand your question, the answer is yes, there is something LIKE phpMyAdmin for Windows. It is not a windows application though. Ryan -Original Message- From: Mark McCulligh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] phpMyAdmin for Windows? I have a site that is on a Windows Server : and having problems with the Hoster giving me telnet access to Admin MySQL. Is there some thing like phpMyAdmin for Windows. I want to put it in a folder on my site to manage the DB. I thought of developing my own, but why build it if it exist already. Thanks, Mark. _ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation www.SykesCanada.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] phpMyAdmin for Windows?
If you have a local webserver with PHP installed, all you should need to do is install phpMyAdmin on your local server and configure phpMyAdmin to look for the databases on the remote machine. Start up your web browser, go to the phpMyAdmin URL that you just installed on your local machine, and you should be able to access the remote DB. The other good thing about phpMyAdmin is you can configure it to access multiple DB servers. I have an installation of phpMyAdmin set up to access DB servers on the local machine (Solaris) and also on a remote machine (Redhat Linux). Works just fine Eugene At 12:48 11-07-02 -0400, Mark McCulligh wrote: I have a site that is on a Windows Server : and having problems with the Hoster giving me telnet access to Admin MySQL. Is there some thing like phpMyAdmin for Windows. I want to put it in a folder on my site to manage the DB. I thought of developing my own, but why build it if it exist already. Thanks, Mark. _ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation www.SykesCanada.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- - Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me. Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] phpMyAdmin for Windows?
Thanks, I didn't know that phpMyAdmin could connect to another server remotely. I will give it a try. Mark _ Mark McCulligh, Application Developer / Analyst Sykes Canada Corporation www.SykesCanada.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] phpmyadmin download
Hi all, Can someone point me in the direction of where to get a copy of phpmyadmin as a .pkg file? Any help would be greatly appreciated. Shawn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] phpmyadmin download
Hi Page Works Web Solutions, Can someone point me in the direction of where to get a copy of phpmyadmin as a .pkg file? a tarball of it you can get via the link http://www.php-center.de There is a links to php-projects and software. Regards, Ruprecht -- Ruprecht Helms - IT-Service Softwareentwicklung == E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 06-Jul-02 Time: 14:54:33 == Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] Phone + Fax +49[0]7621 16 99 16 This message was sent by XFMail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] phpMyAdmin
I'm trying to load phpMyAdmin on, and it seems to work fine, but when I browse a table and run my mouse over the contents of that table I get a jazascript error. Does anyone know a solution for this problem? I doesn't happen in the earlier version of phpMyAdmin .. just this later version. Any help would be great! Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] phpmyadmin and mysql
Anyone know the ins and outs of phpMyAdmin? I have been getting the accessed denied error. The user is set right the passwd is set right and I am using the ip address of the website. Am I missing something. I know the database was orginally created by the admin control panel (maybe cgi) and then used by cgi. Would that matter? [EMAIL PROTECTED] thanks in advance, mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] phpMyAdmin Problem....
I just added phpMyAdmin to a new Apache Server, and I'm getting this error: cannot load MySQL extension, please check PHP Configuration. I did some research on the web, but couldn't come up with a solution to this error and couldn't find anyone listing it. Does anyone know if this is a problem with conf.inc.php in phpMyAdmin or with the MySQL set up in PHP on the server? Any suggestions from there? Sound like you need to recompile with mysql support. check phpinfo() to see if mysql is missing. m: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] phpMyAdmin Problem....
yeah that sounds like apache not being setup right Matt Williams [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I just added phpMyAdmin to a new Apache Server, and I'm getting this error: cannot load MySQL extension, please check PHP Configuration. I did some research on the web, but couldn't come up with a solution to this error and couldn't find anyone listing it. Does anyone know if this is a problem with conf.inc.php in phpMyAdmin or with the MySQL set up in PHP on the server? Any suggestions from there? Sound like you need to recompile with mysql support. check phpinfo() to see if mysql is missing. m: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] phpMyAdmin Problem....
I just added phpMyAdmin to a new Apache Server, and I'm getting this error: cannot load MySQL extension, please check PHP Configuration. I did some research on the web, but couldn't come up with a solution to this error and couldn't find anyone listing it. Does anyone know if this is a problem with conf.inc.php in phpMyAdmin or with the MySQL set up in PHP on the server? Any suggestions from there? Thanks, -Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] phpMyAdmin - blank screen?
hallo guys! i'm a newbie in php..I've installed phpMyAdmin on my pc, together with MySQL and Apache with PHP 4 on Win98. the index.php page is blank! any ideas/suggestions from u ppl? gracias! _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] phpmyadmin
That I can't help you with, as I've never worked with phpmyadmin, always manipulated the database at the MySQL console. By default MySQL stores the database in it's ../var directory, like so: /path/to/mysql/var /mysql - the database which contains info about the other databases /resume /some_other_db /still_another_db and so forth. The fly in this ointment is that the databases can be stored on other drives or directories and symlinked from the default location. Are you thinking that the phpmyadmin is used to build your scripts? If so, you have he wrong impression, as it is a database administration tool. If you need guidance on where to start developing your application, Julie Meloni has some very useful tutorials ar http://www.thickbook.com; there are also tutorials at WeberDev, PHPMonkey, DevShed and so forth. Regards - Miles Thompson At 10:26 PM 1/3/2002 -0500, Viper wrote: OK so great. Where does phpmyadmin store the db file as I am making it? the default area.. I have looked for it on the ftp when I login but do not see it. Thanks - Original Message - From: Miles Thompson [EMAIL PROTECTED] Newsgroups: php.db To: Viper1 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 7:59 PM Subject: Re: [PHP-DB] phpmyadmin You're really asking a database design question, and it can be answered only by asking more questions. The first has to be how much do you know about relational databases? The basic theory on normalization, simple queries, etc., covers about 6~10 pages. There are some very good tutorials on the 'Net; search on something like SQL tutorial Here are a couple: http://www.cs.unibo.it/~ciaccia/COURSES/RESOURCES/SQLTutorial/sqlcont.htm This deals with MySQL, and gets you to third normal form quite painlessly: http://www.mysql.com/articles/ddws/index.html The next question is What information do you want from the database? Write out all the possible questions you will ask of your data. This will tell you what you need to include. When you have this answered, along with some basic table design information, you're in a good position to answer your question. Unfortunately there is no canned answer. Here are a few tips though: For dates, MySQL has a very useful date format. Use it. Most numbers don't have to be stored as a numeric data type, they are more usefully stored as character data. Examples would be phone numbers, street numbers. Numbers which represent quantities, and on which you will do work, multiplying, adding ,dividing, etc., should be stored with a numeric data type. Examples would be price, quantity, number_of_members. MySQL provides an easily used auto-increment field which you can use for a unique primary key on each table. Use it. I know this isn't what you wanted to hear, but I hope it is helpful. The important steps are to determine the possible combinations of data you want to retrieve, and to set up your tables so that you do not needlessly duplicate data, what is otherwise known as third normal form. Will it be somewhat hard work? Yes, but you only have to do it once. I'd also recommend that once you have your perfect design, sit down with some people who are somewhat familiar with your problem and have them ask questions about what is stored and how it will be retrieved. Have fun - Miles Thompson At 06:18 PM 1/3/2002 -0500, Viper1 wrote: I am trying to use the phpmyadmin to create an online resume site. I have created a table and it seems to be fine but I need some more help on the next steps also how to test the database out. I started by making a table called resumes # of fields is 11 first field is name var is 20 and so on. Can someone please help? Thanks, very much appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] phpmyadmin
I am trying to use the phpmyadmin to create an online resume site. I have created a table and it seems to be fine but I need some more help on the next steps also how to test the database out. I started by making a table called resumes # of fields is 11 first field is name var is 20 and so on. Can someone please help? Thanks, very much appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] phpmyadmin user grants
I have a user xyz. I want xyz to able to see table ccl.main_table I go to user xyz's grants I select the database ccl I select the table main_table what do I grant him so he can see but not change or harm ccl.main_table ? An email post reply is always helpful, Thanks John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] phpMyAdmin (well mySQL) and listing DB's
Look closer in the config.inc.php file.. There is a show only this table option /BoNzO http://bonzo.sineleven.nu -Original Message- From: Tom Carter [mailto:[EMAIL PROTECTED]] Sent: den 19 augusti 2001 15:54 To: [EMAIL PROTECTED] Subject: [PHP-DB] phpMyAdmin (well mySQL) and listing DB's Hi All, I was trying to set up phpMyAdmin for a client on my machine, and I've created a mysql account for him such that he can only use his database, yet when I use phpMyAdmin (with the correct setting) he can see all the databases. The security is still there, it just looks messy + reveals all the dbs. Anyone have any advice? TIA, Tom Tom Carter Web Architect roundcorners ltd. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] phpMyAdmin: delete table
Hi I think you don't have php running on your machine. you need php in order to use php myadmin. Joris - Original Message - From: thomas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 03, 2001 3:30 PM Subject: [PHP-DB] phpMyAdmin: delete table Hi, I'm new to phpMyAdmin but they told me to use this programm to delete a table from my mysql database. I've configured the file and when i try to run phpMyAdmin i can see my database on the left frame, however the right frame doesn't show up at all. (instead there's a download dialog box opening all the time). When i download the file and open it in notepad i get an unreadable set of characters what should i do to delete that table?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] phpMyAdmin: delete table
Don't know about phpAdmin, but in straight PHP, after you've connected to database, etc. $sql = drop table tablename; $result = mysql_query( $sql ); Do yuo use PHP anyway? the comment on that was probably it. Otherwise, if you ahve command line access to mysql then the above SQL (DROP TABLE tablename;) should work fine. if you want to test for the table before deleting use $sql = drop table if exist tablename; HTH - Miles At 03:30 PM 8/3/01 +0200, thomas wrote: Hi, I'm new to phpMyAdmin but they told me to use this programm to delete a table from my mysql database. I've configured the file and when i try to run phpMyAdmin i can see my database on the left frame, however the right frame doesn't show up at all. (instead there's a download dialog box opening all the time). When i download the file and open it in notepad i get an unreadable set of characters what should i do to delete that table?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] phpmyadmin troubles - creating tables
you need INT(16) or something, as in in phpmyadmin, enter an integer for the
size of the field as well when defining it :)
// -Original Message-
// From: olinux [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 24 July 2001 2:08 PM
// To: php-db
// Subject: [PHP-DB] phpmyadmin troubles - creating tables
//
//
// OK, I have no idea why but i have spent the past hour trying
// to create this
// stupid table. I am using the latest version of phpmyadmin. I
// created the
// query several times thru the interface and then played with
// the query in the
// textbox. I need help badly.
//
// CREATE TABLE users (id INT (9) not null , user VARCHAR (12)
// not null ,
// pass VARCHAR (45) not null , permission ENUM , package INT
// not null ,
// apartment VARCHAR (75) not null , apt_address VARCHAR (120)
// not null ,
// apt_city VARCHAR (45) not null , apt_state CHAR (2) not
// null , apt_zip
// CHAR (5) not null , con_first VARCHAR (25) not null ,
// con_last VARCHAR
// (30) not null , con_phone VARCHAR (15) not null ,
// con_phone_2 VARCHAR (15)
// not null , con_fax VARCHAR (15) not null , con_email
// VARCHAR (70) not null
// , bill_first VARCHAR (25) not null , bill_last VARCHAR (30)
// not null ,
// bill_address VARCHAR (120) not null , bill_city VARCHAR
// (45) not null ,
// bill_state CHAR (2) not null , bill_zip CHAR (5) not null )
//
// I would like my table to look like this. I have tried
// removing the INT
// limit. I have no idea why this is not working.
//
// the error that returns says:
// MySQL said: You have an error in your SQL syntax near '
// package INT not null
// , apartment VARCHAR (75) not null , apt_address VARCHAR (' at line 1
//
// I have tried creating the table as type myisam and still no luck.
//
// Thank you,
// olinux
//
//
// _
// Do You Yahoo!?
// Get your free @yahoo.com address at http://mail.yahoo.com
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail:
// [EMAIL PROTECTED]
//
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PhpMyAdmin phpPgAdmin Security Issues
I don't know how many of you on this list are also on Bugtraq, but there were some *very* interesting posts there this morning by Shaun Clowes. You can see them at: http://www.securereality.com.au/archives.html The relevant links to look at are A Study in Scarlet: http://www.securereality.com.au/studyinscarlet.txt And: (SRPRE1) phpMyAdmin 2.1.0 and phpPgAdmin 2.2.1 http://www.securereality.com.au/srpre1.html I imagine that many on this list do use phpMyAdmin or phpPgAdmin so this post is very important. Basically, depending on configuration, any user on the web can use phpMyAdmin to view sensitive files (/etc/passwd), etc. There is a patch available. The Study in Scarlet goes into details about other common PHP security breaches, and a little about how to avoid them. The problems aren't *so* bad if you're running your own server and access is only given to a few trusted developers. You could probably retrain everyone to use $HTTP_GET_VARS, etc. However, there could be a multitude of problems on hosts with multiple virtual users. For example, the above exploit could be used to get a list of the users and home directories in /etc/passwd and then a malicious user could view directory listings and file contents from another user's directory. That could lead to database passwords escaping and other local users modifying your data. And that's only the tip of the iceberg. I look forward to seeing Rasmus, Andi, Zeev, Stig etc. respond to this. Sincerely, Paul Burney +-+-+ | Paul Burney | P: 310.825.8365 | | Webmaster Programmer | E: [EMAIL PROTECTED] | | UCLA - GSEIS - ETU | W: http://www.gseis.ucla.edu/ | +-+-+ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
