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

Re: Installed MySQL

Quote Reply
Re: Installed MySQL In reply to
To start mysql you should type:

./safe_mysqld &

to stop mysql you should type:

mysqladmin shutdown

To set a password for the root user, you should type:

mysqladmin password new-password

You should then create a database for links:

mysqladmin create links

and setup a user for links:

mysql mysql

will get you into the mysql monitor, and:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP ON links.* TO someuser@localhost IDENTIFIED BY 'somepassword';

will setup a user 'someuser' with password 'somepassword' who can only access the links database.

I'm not sure what you mean by 'set path for mysql'?

Let me know if this helps, or if you have any other questions.

Cheers,

Alex
Subject Author Views Date
Thread Installed MySQL chilli 3117 Dec 29, 1999, 4:15 AM
Post Re: Installed MySQL
chilli 3032 Dec 28, 1999, 9:20 PM
Post Re: Installed MySQL
chilli 3052 Dec 28, 1999, 9:45 PM
Post Re: Installed MySQL
Michael_Bray 3046 Dec 29, 1999, 5:04 AM
Post Re: Installed MySQL
chilli 3042 Dec 29, 1999, 5:08 AM
Post Re: Installed MySQL
Michael_Bray 3027 Dec 29, 1999, 5:20 AM
Post Re: Installed MySQL
Alex 3048 Dec 29, 1999, 8:15 AM
Post Re: Installed MySQL
pugdog 3039 Dec 29, 1999, 10:53 AM