How do i create a database in mysql?

If you signed up for a gigfoot hosting account, you do not need to do this step. If you are learning mysql then read on. Mysql runs a user table. If you are creating a database, you will need to grant yourself privleges in order to get through the front door. First off, open your shell to the server. Do this via an ssh connection (we recommend Putty). Once logged into the server shell, start a mysql program session, create a database and grant permissions with the following commands:

mysql

CREATE DATABASE FOOBAR;

GRANT ALL PRIVILEGES ON FOOBAR.* TO FOOBARUSER@localhost IDENTIFIED BY 'FOOBARPASSWORD' WITH GRANT OPTION;

Prev Question / Next Question / Question Index

What do you think of this Question? Vote Thumbs Up or Thumbs Down.

Reputation: 1 / Feedback: 0