Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Database Creation

Quote Reply
Database Creation
I know that this is probably the easiest question in the world to answer, but I'm new to mySQL. I already tried searching the forum.

How can I create a new database in mySQL, entirely separtate from the Links database?

------------------
Robert Blackstone
Webmaster of Scato Search
www.scato.com
Quote Reply
Re: Database Creation In reply to
You need to do that from the Unix Shell, or from an admin program such as PHPmyAdmin

You issue a command to the MySQL engine through the mysqladmin program:

/path/to/mysqladmin create new_database -p password -u username


I've had a problem using the -p and -u on the command line, so you might have to try it just adding the -p -u without the actual passwords and let it prompt you. This is more system specific quirks in how user information is passed by the shell to the process, so you just have to see what works on your Unix.

Quote Reply
Re: Database Creation In reply to
Just don't put a space between the -u and -p. i.e.:

mysql -uUSERNAME -pPASSWORD

Cheers,

Alex