Topic: sql database

[gage]

What is the Mysql database server address? I am trying to connect to a sql database but I figure out what directory it is in
Any Ideas

[Rick]

You should not connect to a directory. You should connect to the localhost. The password is in the files /root/my.cnf

More info is on http://www.mysql.org

[gage]

I could not find my.cnf in the root directory. But I did find it in the etc directory.
 Once I found it, I saw a place that had the user=**** for the user name. But could not find anything with a password. Ive looked through mysql.org and cant find anything on the subject. Is it me or are most of the linux manuals lousy. You would think they would have a topic on this in the setup docs.

[Terry Brummell]

Do a ls-a in your root directory, you'll see it.  It's a hidden file.

gage wrote:
>
> I could not find my.cnf in the root directory. But I did find
> it in the etc directory.
>  Once I found it, I saw a place that had the user=**** for
> the user name. But could not find anything with a password.
> Ive looked through mysql.org and cant find anything on the
> subject. Is it me or are most of the linux manuals lousy. You
> would think they would have a topic on this in the setup docs.

[Dan Brown]

It's actually .my.cnf (note the period at the beginning).

And no, I wouldn't particularly think this would be in the setup docs, as it's tangential to the distribution.  The only reason MySQL is included is for IMP, and that part is already set up.  If you want to do other things with it, that's fine, but you're on your own at that point.

[gage]

Thank you for your help.  Is the user name supposed to be in there also? or do I need to add one to the template

[Rick]

The username is: root