How To Create A User And Database For a Web App

This is a generic lesson in how to create a user and a database for a web app, such as WordPress, Joomla, Drupal, and lots of others.

Firstly, go to your site followed by /phpmyadmin

You should see something like this:

 

 

 

 

 

 

 

Login with your defined username and password.

You should see a listing of the available databases etc, as shown below:

Click the Privileges tab at the top (ringed in red above)

Click the Add a new User link at the bottom of the User list, as shown below:

You should see something like this:

Enter the user name.

From the Host: dropdown list, select Local – localhost will appear in the text box.

Enter the password (twice)

Click the radio button that says “Create database with same name and grant all privileges”

Click Go.

That’s it! That’s all you ever need to do to create the necessary back-end for any web app you might want to install. The process is so easy, you’ll be able to do it in your sleep.

When it comes time to fill out a web form upon installation of your new web app, use the details you’ve described above.

For example, for WordPress, you need to edit the file called wp-config.php

If I were to create a new WordPress installation using the above details, my wp-config.php would look something like this:

// ** MySQL settings - You can get this info from your web host ** //

/** The name of the database for WordPress */
define('DB_NAME', 'some_user);

/** MySQL database username */
define('DB_USER', 'some_user);

/** MySQL database password */
define('DB_PASSWORD', '******');

/** MySQL hostname */
define('DB_HOST', 'localhost);

That’s really all there is to it.

And the same holds true for any web app that needs some mySQL parameters.

So once you’ve learned this, there’s no stopping you from downloading, installing and configuring the absolute myriad apps available to you.

Try sourceforge.net, freshmeat.net for starters.

What web apps might you want to install on your own self-hosted server?

sql-ledger? Accounting, with an Australian Chart of Accounts. Free? You betcha!

clipbucket? A YouTube clone. Free? You betcha!

joomla? A content management system like WordPress. Free? You betcha!

drupal? A content management system like WordPress. Free? You betcha!

And so on. I’m sure there’s lots of stuff you can find to download and install.

Each one of them will require a user and a database to operate, so I hope this lesson gives you the idea that no matter what you download and install, you have the background now to know that when the package says “create a database”, you’ll know how to proceed.

Have I left anything out? Is there something I missed? Please let me know in the comments.

 

No related posts.