Free Consultation | Specials | Contact Us

714-676-7905
Home Web Design Online Marketing Graphic Design Portfolio Blog
Home > Blog > Posts Tagged ‘database’

Posts Tagged ‘database’

Create MySQL Database Using cPanel


Wednesday, July 22nd, 2009

MySQL databases are needed for Wordpress, Mediawiki, phpCalendar and many other applications. Fortunately cPanel makes it easy to setup.

• Login to your cPanel account

• Go to the Databases panel and click MySQL Databases:

Databases Panel

• Under Create New Database enter the name and click Create Database:

Create Database

• Click Go Back

• Now you must create a user for the application to use to connect to your database, create a username and strong password, click Create User:

Create database user

• Click Go Back

• Under Add User To Database select the user and database you just created. Click Add:

Add user to database

• Select the privileges the user has to the database. From a security standpoint always give the user the least amount of privileges that are required. From a practicality standpoint most applications will require all privileges. Click Make Changes:

Manage User Privileges

• Click go back

• Your database is now setup. When installing your application use the database name, username and password you created. Make sure you lead it with your cpanel username, in this example yoursite_wordpress, if your on a shared hosting server.

  • Technorati Favorites
  • Digg
  • Delicious
  • StumbleUpon
  • Share/Bookmark