Jump to content
Sign in to follow this  
Carl Filby

create new database

Recommended Posts

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.

 

 

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

quit

 

then

 

./mysqladmin -u root -p create exercise

Share this post


Link to post
Share on other sites

Thank You

 

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.

 

 

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

quit

 

then

 

./mysqladmin -u root -p create exercise

Share this post


Link to post
Share on other sites
Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...