create new database - Printable Version

create new database - Printable Version

+- Linux-Noob Forums (https://www.linux-noob.com/forums)
+-- Forum: Linux Server Administration (https://www.linux-noob.com/forums/forum-8.html)
+--- Forum: LAMP (https://www.linux-noob.com/forums/forum-83.html)
+--- Thread: create new database (/thread-1024.html)

create new database - Carl Filby - 2008-02-15

Using mysql 5.0 how do I create a new database?

create new database - anyweb - 2008-02-15

here's a sample of how to do that

Create a mysql database:

The word "exercise" below being used in the comands is the name of the database change it to what your database name is going to be called.

Code:
cd /usr/local/mysql/bin

./mysql -u root -p

enter the "password"

use mysql;

INSERT INTO db (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Dro
p_priv) values ('localhost','exercise','root','Y','Y','Y','Y','Y','Y');

taken from the LAMP section here

now type

Code:
quit

then

Code:
./mysqladmin -u root -p create exercise

create new database - Carl Filby - 2008-02-15

Thank You

Quote:here's a sample of how to do that

Create a mysql database:

The word "exercise" below being used in the comands is the name of the database change it to what your database name is going to be called.

Code:
cd /usr/local/mysql/bin ./mysql -u root -p enter the "password" use mysql; INSERT INTO db (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Dro p_priv) values ('localhost','exercise','root','Y','Y','Y','Y','Y','Y');

<div>

taken from the LAMP section here

now type

Code:
quit

then

Code:
./mysqladmin -u root -p create exercise

</div>

create new database - magikman - 2008-02-19

mysql -u root -p

create database <name>;</name>