How To Use MySQL/phpMyAdmin Under Linux - Web Development

Can any anybody help me by guiding me on how to use mysql database, creating tables and showing database results using Phpmyadmin in a Linux Web Hosting ?

Comment/Reply (w/o sign-up)

The best way I would suggest is the following : use your astahost account and create a photo gallery, add some pictures, and then browse the generated .php programs in order to see how they were written (this is the magic of open-source, you can browse the sources in order to learn and maybe improve).
The astahost tools will also allow you to manipulate the data, the phpmyadmin environment will be automatically configured and you will be able to query the tables and see the objects inside.
Regards
Yordan

Comment/Reply (w/o sign-up)

Phpmyadmin is actually a really easy tool. It let's you do everything possible to your database without using a single line of SQL.

If you are completely unfamiliar with database structures and you don't know how they are usually done (what I mean is that you don't know what is the best way to organize the tables and how you can join them in queries and stuff like that) I recommend you find a tutorial and/or, do as Yordan suggested and install some web software (like forums), put some stuff in there (like threads and posts) and use PHPmyadmin to look how the data you have have been stored in the database. For people who have worked with databases it is obvious that you store, for instance, forum posts in one table and information about the posters in another table. But for unexperienced you easily do mistakes which makes further development of your software quite difficult.

What I'm trying to say is that you should first learn to design databases and learn the important principles, such as storing same data only once in the database. But you can learn from examples quite easy.

 

 

 

Comment/Reply (w/o sign-up)

well, there is no exact difference anyway on having mySQL in a non *NIX webhost and on a NIX webhost.
the creators of mySQL have made the program to behave the same under different environments.

on the other hand, if you can setup your mySQL to allow you to connect using your very own IP, SQLyog is a much better tool than phpmyadmin. SQLyog provides a full system GUI that have all of the functions of the
database in a point and click method, plus the results are sorted in a nicely ordered display list.

it also have a SQL query window which will eats up 30% of the display on default install and can execute multilines and or only a selected line of query.

the SQL behind it is displayed orderly in the history window. in case that you dont have control of allowing access to your webhost then you are much better wayoff using phpmyadmin.

--
phpmyadmin is a great tool, the one i hate about it is that the more recent versions have more and more features and functions added that you cannot easily shutdown. and the installation time is starting to be of a hell since sometimes, it cannot read the configuration files that it have created due to server variances.

the fix i found bout this problems is by installing old versions of phpmyadmin a few relase ago just to make it run.

on the general, phpmyadmin is still a great tool and i always have one handy in each projects that I have.

my test servers, Apache / IIS both have phpmyadmin

NOTE:
on some servers, phpmyadmin is not readily installed and i avoid using a pre installed script since most of the time, they can be problems when you notice the very little control you have and the task that you must perform needs a much fuller control.

Comment/Reply (w/o sign-up)

All major and most minor databases are now available on Linux (with the lone exception of MS-SQL). This is a sea-change compared to summer of 1996, when this list was slim indeed, listing mSQL, Postgres and a handful of others (Solid, Empress, Adabas). But at the end of 1998 and start of 1999, all of the major commercial DB vendors (IBM, Oracle, Informix, Ingres, Sybase) made their wares available on Linux +
There are more SQL database systems available for Linux than anyone would expect

Comment/Reply (w/o sign-up)

Really surprising : Microsoft things which don't work under Linux !

Comment/Reply (w/o sign-up)