stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


GeekSpeak: Installing phpMyAdmin on Linux







GeekSpeak: Installing phpMyAdmin on
Linux

GeekSpeak: Installing phpMyAdmin on
Linux
02/11/2004 09:34 AM

Via a link from php|architect this morning, there's an article from GeekSpeak that will help all of those out there having issues getting that famous PHP tool - phpMyAdmin - installed on their unix/linux machine.




This is a GrokNews Entry: (what is grok?)





Similar Items

GeekSpeak: Installing phpMyAdmin on Linux

Grok Headline matches for GeekSpeak: Installing phpMyAdmin on Linux

Installing phpMyAdmin on Linux


Installing phpMyAdmin on Linux 02/10/2004 08:04 PM
GeekSpeek tells us how to set up phpMyAdmin on Linux."Some of its current capabilities include the ability to create and drop databases, create , drop, and alter tables, execute SQL statements, delete, edit, and add fields, manage keys on fields, and manage privileges. In addition, it has the ability to export your data in a number of different formats. phpMyAdmin is an excellent tool and will make the life of any MySQL database administrator much more enjoyable. "

PHPMac: Installing Multiuser PHPMyAdmin


PHPMac: Installing Multiuser PHPMyAdmin 09/10/2004 07:30 AM
Over on PHPMac.com there's a new article seeking to help you install PHPMyAdmin for MySQL multiuser environments.

Try Linux without installing it on your
system


Try Linux without installing it on your
system
02/10/2004 02:44 AM
My Linux interest was piqued this week when I read that Lindows was soon to give away [LindowsLive] via P2P,...

Linux 2.6: Compiling and Installing


Linux 2.6: Compiling and Installing 04/13/2004 07:52 PM

Article: Installing Slackware Linux


Article: Installing Slackware Linux 01/26/2004 08:53 AM

phpMyAdmin - Mysql DB administration
tool - www.phpmyadmin.net


phpMyAdmin - Mysql DB administration
tool - www.phpmyadmin.net
02/06/2005 03:07 AM
phpMyAdmin - Mysql DB administration tool - www.phpmyadmin.net .. released a new version .. phpMyAdmin 2.3.2 .. phpMyAdmin .. 2.4.0-rc2

phpmyadmin.net
track this site | 3 links


Articles: Installing Linux on a Dead
Badger: User's Notes, by Lucy A. Snyder


Articles: Installing Linux on a Dead
Badger: User's Notes, by Lucy A. Snyder
04/09/2004 09:06 PM
installing linux on a dead badger: user's notes

strangehorizons.com/2004/20040405/badger.shtml
track this site | 6 links


"Articles: Installing Linux on a Dead
Badger: User's Notes, by Lucy A. Snyder"


"Articles: Installing Linux on a Dead
Badger: User's Notes, by Lucy A. Snyder"
04/09/2004 09:09 PM

phpMyAdmin


phpMyAdmin 12/07/2003 04:08 PM
phpMyAdmin 2.5.5-rc1 is released!

phpMyAdmin 2.5.7


phpMyAdmin 2.5.7 06/09/2004 09:16 AM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.5


phpMyAdmin 2.5.5 12/28/2003 04:20 PM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.3.2


phpMyAdmin 2.3.2 10/31/2002 01:15 AM
After over a year of development, the new version of phpMyAdmin (which allows you to manage your mysql databases from a web server)was released this month.

I just downloaded it today. After 10 minutes of testing, my opinion is that it is a step backward. In previous versions, i could enter SQL from nearly every important screen in phpMyAdmin. Now I have to click on a database, then select the SQL tab. Secondly, they have now highlighted the DROP command in red. After selecting a couple of test tables that I had just created, I clicked on DROP to remove the test tables, only to find to my horror that it was DROP DATABASE!

This just reinforces my opinion that good user interface designers are too well paid to contribute to Open Source projects :-)

"zeldman.lod"

phpMyAdmin-2.5.5-rc2 is released!


phpMyAdmin-2.5.5-rc2 is released! 12/16/2003 07:39 PM
This is the second release candidate for 2.5.5. A few problems were discovered and fixed from 2.5.5-rc1. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin 2.5.5-rc1 (Development)


phpMyAdmin 2.5.5-rc1 (Development) 12/08/2003 04:42 PM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.4 is released!


phpMyAdmin 2.5.4 is released! 10/29/2003 12:10 AM
The development team is proud to announce the availability of this version, with over 12 improvements and 20 bug fixes. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin 2.4.0 released


phpMyAdmin 2.4.0 released 02/24/2003 07:04 AM
The development team of phpMyAdmin is proud to present you the latest version, with a new interface for server administrators, and lots of improvements and fixes. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

On the 7th Day God Created phpMyAdmin


On the 7th Day God Created phpMyAdmin 12/10/2002 01:40 AM
phpMyAdmin is by far the most widely used and distributed

Doing More With phpMyAdmin (Part 1)


Doing More With phpMyAdmin (Part 1) 10/28/2003 11:06 PM
You might not know this, but you can do a lot more with phpMyAdmin than just create tables and insert records. This first in a two-part series takes a look at some of the other features hidden under the hood of this popular PHP application, explaining how it can be used to secure access to the MySQL server, manage multiple servers, manipulate user privileges, view reports on server activity, and export MySQL data into different formats.

phpMyAdmin 2.6.0-rc2 (Development)


phpMyAdmin 2.6.0-rc2 (Development) 09/06/2004 11:14 AM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.6 is released


phpMyAdmin 2.5.6 is released 03/06/2004 02:00 AM
Welcome to this new version, aimed at stabilization of the 2.5 branch. Meanwhile, work is continuing on the new 2.6 branch. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin 2.6.0-rc2 is released


phpMyAdmin 2.6.0-rc2 is released 09/07/2004 07:57 PM
Here is the second release candidate for version 2.6.0. Thinks are going well, version 2.6.0-rc1 was tested a lot (with more than 45700 downloads). phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin 2.5.7 is released


phpMyAdmin 2.5.7 is released 06/11/2004 07:06 PM
The main reason of this release is to add support for MySQL 4.1.2 in a stable version. It includes also some bug fixes. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

Mastering phpMyAdmin


Mastering phpMyAdmin 06/03/2004 07:01 AM

phpMyAdmin is usually installed quickly, out of acute necessity. You need to do something with your database, and you can't do it via telnet or SSH or anything else, so you download the latest version, FTP it up, and away you go. More often than not, the install is forgotten about as soon as your need is over.

The downside of this is that you're not getting nearly the value you should out of a phpMyAdmin install. Most people work with phpMyAdmin superficially and in very narrow usage corridors — like kids walking barefoot on a painted line through a very large parking lot. There's so much about the app that you don't know.

Enter this book: "Mastering phpMyAdmin for Effective MySQL Management." This is the first book I know of solely on phpMyAdmin (though a lot of MySQL books cover it briefly in an appendix or something). It was released by Packt Publishing a few weeks ago.

It's a departure from a lot of tech books in that (1) it's short and sweet (just under 200 pages — not nearly the 600-page monolith some of these things become), and (2) it seems more...conversational. Concepts are explained in plain English. I normally hate that cliche, but it fits here. I got a sense of simply having a casual conversation with a fellow geek.

I read it over the course of a week, putting in a chapter or two each night. I learned something new in every chapter, and I'd implement them in my phpMyAdmin install right after reading the chapter. By the end of the book, I'm left with a superb phpMyAdmin install that does a thousand times more than I've ever accomplished with the app before.

There's a lot of phpMyAdmin functionality under the hood that you've likely never seen. For instance, you can set it up to enforce relational integrity in your database. This is just good database design, but it also enriches the interface considerably. Foreign key fields now become drop-down lists to the foreign table with a selection of entries. You can print a PDF summary document with descriptions of all tables and columns and an entity relationship diagram showing field relationships. Bet you haven't seen that trick before.



I suddenly have a sense of liberation with phpMyAdmin. We all hate writing admin interfaces, especially for one-off apps we do in a hurry. Thankfully, phpMyAdmin can support an enormous amount of administration chores in an interface not nearly as utilitarian as the default one you get on install. It won't work for administering the data of every app you right, but I bet it will handle a lot of them.

I can now see writing apps and doing things that I stayed away from before just because I didn't want to write all the data entry and database admin scripts that easily dominate the work required to put these things together. Instead, I can concentrate on the fun of the front-end pages, while phpMyAdmin sucks up all the back-end work.

The book also includes some good information about PHP and MySQL in general. On page 86, in the chapter on importing data, there's a solid little discussion about PHP file upload and execution limits that trumps anything I've read before. I'm a better developer for having read these four paragraphs about the "upload_max_filesize," "memory_limit," and "post_max_filesize" parameters.

As for MySQL, did you know about InnoDB tables? This is a table format that builds referential integrity into MySQL — something the database has been missing for so long. I'll admit to being utterly ignorant about this feature until this point.

There's a chapter at the end of the book about MIME-based transformations that summarizes the general level of apathy about this app. I can't believe I haven't run across a discussion about this feature before —

You may have known on the periphery that you could store files directly into a MySQL database using a BLOB column. But did you know that phpMyAdmin will support this with a file upload field in the interface, so your users can upload files directly? Or that you can sent a MIME Transformation on that field to display a thumbnailed view of stored images in the row when browsing the database? And that you can link that thumbnail to the full-size version or the image, pulled directly from the field? I'll bet the percentage of phpMyAdmin users who know that trick is in the single digits.



So, good book. If you find yourself writing a lot of throwaway admin interfaces and hating every minute of it, the $30 cover price for this text is probably looking mighty attractive right now.

Click here to comment on this entry


phpMyAdmin 2.6.0-beta2


phpMyAdmin 2.6.0-beta2 06/28/2004 06:07 PM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.4.0-rc2 released


phpMyAdmin 2.4.0-rc2 released 02/17/2003 12:15 PM
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields. The test cycle is going well, rc2 contains other fixes, and more polishing of the new privileges and database management pages.

phpMyAdmin 2.3.0 is released


phpMyAdmin 2.3.0 is released 08/12/2002 01:39 AM
You are welcome to use this new stable version, with lots of new features. Details available at http://phpmyadmin.net.

Web Services (XML-RPC) and phpMyAdmin


Web Services (XML-RPC) and phpMyAdmin 07/17/2002 09:05 AM

phpMyAdmin 2.5.5-pl1 is released


phpMyAdmin 2.5.5-pl1 is released 01/05/2004 08:00 PM
This is the patch level 1 release for 2.5.5, fixing a few problems. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin 2.6.0-rc1 (Development)


phpMyAdmin 2.6.0-rc1 (Development) 08/09/2004 02:38 AM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.5-rc2 (Development)


phpMyAdmin 2.5.5-rc2 (Development) 12/15/2003 11:46 AM
Handles the basic adminstration of MySQL over the WWW

PHPMyAdmin Book


PHPMyAdmin Book 05/20/2004 02:26 PM

Packt Book Store :: Mastering phpMyAdmin for Effective MySQL Management: We've talked about Packt Publishing befor e, but now it looks like they're really hitting high gear. Here's a book about PHPMyAdmin, which I never thought we'd see but which is badly needed. You may think you know PHPMyAdmin, but if you look under the hood, there's functionality there that I bet you never knew existed.

They also have a book about eZ Publish, which I've worked with and enjoyed very much.

Click here to comment on this entry


Doing More with phpMyAdmin (Part 2)


Doing More with phpMyAdmin (Part 2) 12/08/2003 11:46 AM
In the first segment of this two-part tutorial, I gave you a quick overview of some of the interesting new features available in phpMyAdmin. In this concluding segment, find out how to use phpMyAdmin to define relationships between tables, maintain a log of commonly-used queries and create entity-relationship diagrams.

phpMyAdmin 2.3.3pl1 released


phpMyAdmin 2.3.3pl1 released 12/05/2002 09:38 AM
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields. As a few errors in some language files slipped in version 2.3.3, here is a patched version.

DevShed: Doing More With phpMyAdmin
(Part 1)


DevShed: Doing More With phpMyAdmin
(Part 1)
10/28/2003 11:07 PM
If you've ever had a shared hosting environment and had to deal with the frustration of not being able to access the command line, then you know the joy that phpMyAdmin can bring. Now, DevShed is looking to share the love with thier latest posting.

phpMyAdmin 2.6.0-alpha is released


phpMyAdmin 2.6.0-alpha is released 04/23/2004 07:13 PM
The phpMyAdmin Project is proud to announce the immediate availability of the first alpha release of phpMyAdmin 2.6.0. Because of significant changes inside the database connection methods and major improvements to the MySQL 4.1 compatibility, the team decided to release this alpha version from phpMyAdmin's current development code. Supporting the new improved MySQL extension of php5 (MySQLi), phpMyAdmin has made a giant step towards the upcoming PHP and MySQL versions. As the new milestone should to be as stable as possible, any feedback about 2.6.0-alpha1 would be appreciated. Please note, that it is not recommended to run this testing release on production environments. (From the announcement text by Alexander Turek).

phpMyAdmin 2.3.0-rc2 (Unstable) released


phpMyAdmin 2.3.0-rc2 (Unstable) released 07/03/2002 01:14 PM
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data and administrate one single database and multiple MySQL servers.

phpMyAdmin 2.6.2-rc1 (Development
branch)


phpMyAdmin 2.6.2-rc1 (Development
branch)
04/03/2005 09:24 PM
Screenshot phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data and administrate one single database and multiple MySQL servers.

phpMyAdmin 2.6.0-beta1 (Development)


phpMyAdmin 2.6.0-beta1 (Development) 06/24/2004 10:46 PM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.6.2 (Default branch)


phpMyAdmin 2.6.2 (Default branch) 04/16/2005 07:32 PM
Screenshot phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data and administrate one single database and multiple MySQL servers.
Grok Description matches for GeekSpeak: Installing phpMyAdmin on Linux
GrokA matches for GeekSpeak: Installing phpMyAdmin on Linux

GeekSpeak: Installing phpMyAdmin on Linux

The following phrases have been identified by the grok system as matching this entry:

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

Community News: Is
MySQL's Licensing
Good?

DOJ lawyers want to
block Oracle

Comcast offers $66
billion for Disney

CNN.com - Digital
evidence raises
doubts - Feb. 10,
2004

Pornographer to sell
Whitehouse.com Web
address

Transformers
Instruction Archive

CNN.com - Original
'Star Wars' films
coming to DVD - Feb.
10, 2004

T-Mobile Not Bidding
for AT&T Wireless

T-Mobile not bidding
in AT&T Wireless
auction-report

What is the impact
of the Iraq bomb
attacks?

DVD release for Star
Wars trilogy

Rattlesnakes' rich
social lives

Inquest opens after
triple murder

39 Sri Lankan
ministers dismissed

UN says Karadzic is
in Belgrade

Bird flu hits US
poultry industry

N Korean defector
'held by China'

Uganda expels
troublesome priest

Football: Agents
under scrutiny

Fishing pair 'deny
manslaughter'

Irish tycoons lift
Man Utd stake

Smoking 'a blight on
fertility'

Desmond enters
Telegraph battle

Stealth Serial Port
available for Power
Mac G5

Panic improves
Unison text
handling, more

Apple updates OWC,
CDW 'Hot Deals'

GNU GTick 0.3.0
PHP Live! 2.5.1
Filer 0.0.5
5th Annual Event,
The Way Ahead for
Optimal Risk &
Capital Management
in the Re/Insurance
Industry

Antitrust Biting
Oracle; Hypocrisy
Ascendant?

Media Consolidation,
Continuing

SourceForge.net
Support

Open QUB
Oracle dealt key
setback on hostile
bid
(SiliconValley.com)

Microsoft Warns
Windows Prone to
Hacking (AP)

T-Mobile Not Bidding
for AT&T Wireless
(Reuters)

South Europe Net
Population Soars;
Seniors Left Out
(Reuters)

Yahoo Rolls Out New
Messenger Service
with Sprint
(Reuters)

Java Tools
Subscribers Get Free
Hardware

W3C Approves Pair of
Semantic Web Specs

Comcast Proposes
Buying Disney

Security Patch
Tuesday: Serious
Windows Flaw
Uncovered

Texas woman faces
trial for selling
sex toys (Reuters)

Rapid application
development tools,
part 2: Visual Linux
BASICs

Flickr
Bush Aims For
'Greater Mideast'
Plan
(washingtonpost.com)

Technorati: Generate
updated attention
file

O'Reilly Network:
O'Reilly Network --
2004 Emerging
Technology
Conference Coverage
[Jan. 16, 2004]

White House Releases
Bush's Military
Records
(washingtonpost.com)

what is grok?