Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: sidney on April 01, 2003, 08:54:34 PM

Title: mysql question
Post by: sidney on April 01, 2003, 08:54:34 PM

I have a program that is asking mysql database parameters.  I don't know how to answer them. any help would be greatly appreciated.


question are:
database name ( $db_name ),
hostname ( $host_name ),
user name ( $db_user ),
password ( $password).
choose name for database table ( $table_ads )

Then it says to create Mysql database (with the same name as specified)

Thanks
Sid,

Title: Re: mysql question
Post by: Dan Brown on April 01, 2003, 09:40:00 PM

The only parameter that you know up front is the hostname, which is localhost.  For the rest, do this:

# mysql
mysql> create database somedb;
mysql> grant all on somedb.* to someuser@localhost identified by 'somepass';
mysql> flush privileges;
mysql> quit

the database name will be somedb, user name will be someuser, and password will be somepass (keep the single quotes in the command there).  No idea about the table name, though--that should be in the docs.

Title: Re: mysql question
Post by: sidney on April 02, 2003, 01:28:19 AM

Thanks Dan,

I will give that a try.

Title: Re: mysql question
Post by: Cory on April 02, 2003, 11:34:06 AM

If you are new to mysql you might try to install phpMyAdmin. It is a php program which can help you setup/manage mysql databases. You'll have to install it under an ibay with cgi enabled...

You can get it at :
http://www.phpwizard.net/projects/phpMyAdmin/

Title: Re: mysql question
Post by: Cory on April 02, 2003, 11:38:33 AM

That URL isn't working... try this one if you are interested...

http://phpmyadmin.sourceforge.net/

Title: phpmyadmin rpm's [was Re: mysql question]
Post by: Guck on April 02, 2003, 12:43:06 PM

phpmyadmin has also been compiled into RPMs by shiny happy people.

See
http://forums.contribs.org/index.php?topic=16680.msg64586#msg64586

and search this forum for more...

G

Title: Re: mysql question
Post by: sidney on April 02, 2003, 07:04:45 PM

Thanks cory,


could you give me a crash course on how to answer those question using the mysqlAdmin.


Thanks for all the help guys :)

Title: Re: mysql question
Post by: NiGhTsPiRiT on April 02, 2003, 07:25:32 PM

Here is the latest version of phpMyAdmin:
http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/