Home » questions » PHP & Mysql problem?

PHP & Mysql problem?

4
2006-08-17 11:12:16, Category: Programming & Design
I'm beginner learner of PHP. Is it essential to install phpmyadmin for developing a website? Cause My all mysql server and php soft were successfully installed and worked. But phpmyadmin did not work. I want learn for only developing webapplication.

Answers

  1. sheeple_rancher

    On 2006-08-17 11:37:47


    I found phpmyadmin irritating and went back to the mysql command line interface. There is also a couple of tools called MySQL Workbench and MySQL Administrator which are OK You need to be able to make a direct connection to the mysql server a port 3306 (unless you changed it). The only thing that could be stopping you from using phpmyadmin or any other tool is you don't have the mysql permissions set up properly (including setting up an admin level user).

  2. gruumsh

    On 2006-08-17 12:20:01


    This depends on what features are made available by your hosting service. If you can access the MySQL server directly (typically through port 3306) then you can use a visual client that you install on your computer, connect to the database, and do all your table creation and site maintenance in a visual environment. Many of these are free. I highly recommend SQLYog. If you have shell access, and you don't mind memorizing commands and doing some typing, then you can log into your account via a shell client and interact with the server that way. This can be especially convenient if you feel comfortable setting up automated scripts for certain tasks, like backup for example. A good and free client that can also connect to a shell account via a secure, encrypted connection is Putty. Finally, if you do go the PHPMyAdmin route, be extra careful to read ALL the documentation, because if it's not configured correctly, there will be some security loopholes, and you run the risk of having hackers playing with your database.

  3. jmfc

    On 2006-08-17 11:44:38


    No, you don't need to use phpmyadmin if you don't want to. It isn't neccessary, just gives you a graphical way to created databases objects. If you download the most recent version of mySQL - version 5 - you can get 3 great tools with it for free that are much better then phpmyadmin. The pages to these are listed below. You don't need the data migration one unless you are planning on importing data from other sources. The command line tool is OK but can be a little intimidating for beginers who don't know the syntax very well. Good luck http://mysql.com/downloads/administrator/1.1.html http://mysql.com/downloads/workbench/1.0.html http://mysql.com/downloads/migration-toolkit/1.0.html

  4. John J

    On 2006-08-17 11:41:32


    I don't use PHPmyAdmin unless it is the only thing available (some hosting companies). MySQL has a graphical front end call MySQL Query Browser that is fair (there are some bugs in it), and you can always use the command line. You can also create your own GUI using PHP, but that would take a lot of time.