How to Create a Database on an Apache Server


The Apache server was first introduced in 1995. Apache quickly became the standard server of choice for many web-hosting companies. The stability, reliability and affordable pricing of the Apache web server contributed greatly to the proliferation of websites on the Internet. In fact, the Apache server was the first to surpass the 100 million websites benchmark. Of course, the key to any good website is the ability to use databases, and Apache makes creating databases a breeze. A few simple steps will help you set up a database for your website in no time.

  • Log in to your control panel on the Apache server. At the time you open an account with the web host, they will supply you with instructions on how to access the control panel. Directing your browser to "" typically does this.

  • Scroll down to the "Databases" section of the control panel on the Apache server. Click the button marked "MySQL Databases" to access the database administration section of the control panel.

  • Create the database file. The MySQL Database section of the Apache control panel has an area that is clearly labeled "Create New Database." Type the database name in the box and click "Submit." Apache will then create a MySQL Database using that name.

  • Create a database user for the Apache server. Scroll down on the MySQL Database page until you reach the "Database Users" section. Under "Add New User," fill in a user name and password. Enter the password twice to prevent mistakes, then click the button marked "Create User."

  • Add the user to the database. Scroll to the bottom of the MySQL Database page of the Apache server to get to the section where you link users to databases. Use the first drop-down menu to select the user, and the second drop-down menu to select the database. When asked what permissions to give, select "All Permissions."

Tips & Warnings

  • If you ever need to make changes to a database, log in to the Control Panel and look for a button marked "phpMyAdmin." This button takes you to an administrative area where you can manage your databases.


  • Photo Credit I am a Moose, Creative Commons License
Promoted By Zergnet



You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!