Hello, I played around making websites with PHP, and I want to create a MySQL database. Ive got a book that tells me how, but do not really tell me how to connect to the server. Iv registered web space that allows MySQL database, but how do I connect to it via a command line on my Windows machine? Is there a software I can install? Thanks for the replys, Ben.
Secured by Super-CAPTCHA © 2009-2010 MLW & Associates, LLP. All rights reserved.
Try phptirad. You can convert your Windows machine on a server with PHP and MySQL. This allows you to create the computer and test PHP pages locally using the MySQL database on the same computer.
PHPTriad can be downloaded from http://www. download. com/PHPTriad/3000-2165_4-10048390. html
To connect to the MySQL database server, you need a MySQL client of some kind. Your hosting provider probably has phpMyAdmin installed, a Web-based client that requires no software installation on your part. If your hosting provider has Webmin, you can use the MySQL module, which is like phpMyAdmin, but not as well designed.
phpMyAdmin will almost certainly be tailored to their needs, but if you can not install a client on your behalf. Just find a client that you like – MySQL offers customers Graphics http://www. MySQL. produced com / / tools /, and also a command-line client, the other popular choices for Windows are SQL-Front (http://www. sql-front. com /) and Navicat (http://www. Navicat . com /). You might also want to watch Power * Architect (http://www. Sqlpower. Ca / page / architect), a data modeling tool that has the functionality to the customer as well.
For security reasons, some hosting providers disable the access from remote clients, so that phpMyAdmin can be the only option.
Once you find a customer wants, you must provide the connection information so you can find the database server (unless you install phpMyAdmin host, which is preconfigured). With your hosting provider will give you the information, which will also have for all PHP scripts that communicate with the database.
software made it easy to use phpMyAdmin! simple and fast way to connect to the database
goodluck
aojunk
http://doshop. ZZL. org
Download "Navicat"
The rest is easy:)
First you need to add an ODBC connection on your computer. You can do this in the control panel. Going to say that the IP address of the MySQL server, and other things.
Then you have the PHP code that initiates the connection and manipulate the data.