Topic: mysql question

[sidney]

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,

[Dan Brown]

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.

[sidney]

Thanks Dan,

I will give that a try.

[Cory]

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/

[Cory]

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

http://phpmyadmin.sourceforge.net/

[Guck]

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

[sidney]

Thanks cory,


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


Thanks for all the help guys

[NiGhTsPiRiT]

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