0
Linux variant: depending on the distribution you use, there are (most certainly) prepared packages (e.g. Debian, Ubuntu) to install, if you use a more complicated distro like gentoo, you have to download and compile the source packages (check Google for tutorials on that).
Windows variant 1: you can employ a prepared WAMPP package (apache, mysql, php, pear/pecl) - find it here: www.apachefriends.org
Windows variant 2: you can install all desired services manually (check google for tutorials on windows apache iis)
One of the easiest ways I have found to get MySQL running on a LAMP server is to actually install phpmyadmin through the terminal. This will load everything you need to get LAMP running, Apache, PHP and MySQL. You may need to install mysql first before running this but I have found it to be the easiest way to get all of it running on a server. Many hardcore admins may tell you to never use apt-get and install everything from source and compile it yourself but if you are a novice, apt-get is a good way to go. The commands for loading mysql are "sudo apt-get install mysql-server; sudo apt-get install mysql-client;" depending on your version of Linux. If you're on Windows, give up and start a linux box.
Add your answer:
Earn +20 pts
Example of DBMS used in web based application?
SQL server oracle DB2 MYSQL
Would MySQL commands work in a terminal like application Mac OS X if you didn't have an active web server installed like Apache would you be able to create databases without a web server?
MySQL and Apache are two totally different things, you only see them together a lot because a lot of Web apps use MySQL to store info in the database. So yes, you can use mySQL without Apache.
What is a wamp?
It is a web server running on windows which uses at least 4 components. 1. Windows 2. Apache 3. MySQL 4. PHP If you setup a web server on a Linux system then it would be called a LAMP server.
What are the benefits of using mySQL in designing a website?
There are several benefits of using MySql. Here are some1) Open Source2) Easy embedded on php and apache web server.3) Easy to create an integrated web development platform4) MySQL 5.1 is support for horizontal partitioning.many more...
What is MySQL shareware?
It's a very old name for the mysql server daemon.
What kind of web server is best for PHP and MYSQL based website?
Without a doubt, the best web server would be EasyPHP. This is for PHP, MySQL, SQL, Apache, and development tools. It is also portable so you can, for example, put it on your USB stick. The website also has its own forum for extra help/tutorials/support. Try it out!
Why do you keep getting this error Warning mysql connect function mysql-connect Can't connect to local MySQL server through socket 'tmpmysql sock' 2 in mntsdbwww2smut360 comhtdocsincc?
Make sure that the MySQL server is running.
Can I enable drupal hosting at home?
You need to install a web server, a database server, and PHP to support the drupal software. It is common to use the Apache web server and the MySQL database server. Installers are available to install all these at one time. Instructions are available at: http://drupal.org/node/263 .
Can you use mysql instead of sql as backend?
Assuming you have MySQL installed on your server then yes.
Is MySQL a server?
MySQL is an open source relational database management system based on SQL queries. It was developed by the Swedish company MySQL AB and is now a subsidiary of Oracle Corporation. Your could use a MySQL Client, for example dbForge Studio for MySQL, to install and connect to MySQL Server as a first steps to get started with MySQL.
What host do you use when your MySQL database is on a separate server to your PHP scripts?
For the host you need to put the IP address of the MySQL server instead of localhost.
What are PHP and your SQL?
PhP is a primarily web based scripting language. i don't know what your SQL is, but MySQL is a database server, that uses the SQL language.
