• Skip to main content
  • Skip to primary sidebar

ProThoughts

Best Product Reviews

WordPress

How to create MySQL database

MySQL is one of the most popular database which is used for php based sites, like WordPress, Question2Answer. Here are simple steps to create MySQL database and grant required permissions to database user.

Login to MySQL by using command
mysql -u USERNAME -p
it will ask for password, enter.

After above step you will see MySQL prompt.
mysql>

Create database
mysql> create database NEWDB;

Add user with password for database
mysql> grant usage on *.* to NEWDBADMIN@localhost identified by ‘YOURSTRONGPASSWORD’;

Grant all permissions for NEWDBADMIN user
mysql> grant all privileges on NEWDB.* to NEWDBADMIN@localhost;

You can use above credentials in wp-config.php for WordPress or qa-config.php for Question2Answer and install.

Filed Under: How-to-Guide, WordPress Tagged With: mysql

Primary Sidebar

Subscribe via Email

Categories

  • 3D Pen
  • Back Scratcher
  • Bath Pillow
  • Best Mattress
  • Electric Can Opener
  • Hot Tub
  • How-to-Guide
  • Magnetic Screen Doors
  • Mosquito Trap
  • Security
  • WordPress
Build Your Mailing List Faster
Landing Pages for WordPress

Better WordPress Content

Thrive Quiz Builder

Copyright © 2010-2020 ProThoughts. All rights reserved.
Contact Us . Disclosure . Disclaimer . Privacy Policy DMCA.com Protection Status