[Wlug] looking for mySql setup info

[eric]

John Stoffel wrote:
>>>>>> "kstratton" == kstratton  <kstratton at fastmail.us> writes:
>>>>>>             
>
> kstratton> Yes, that looks like where I started
> kstratton> (http://gentoo-wiki.com/HOWTO_Setup_MythTV)
>
>   
>>> From the wiki, I found that I need mysql working first.  I used:
>>>       
>
> kstratton> http://www.gentoo.org/doc/en/mysql-howto.xml
>
> kstratton> 1)emerge -DuN mySql builds fine
> kstratton>   emerge --config =dev-db/mysql-5.0.54 seems to execute as I would
> kstratton>   expect
>
> Yeah, that's probably what you wanted.
>
> kstratton> 2) /etc/init.d/mysql start was run before I tried 'mysql -u
> kstratton> root -h localhost -p'.  I get an access error with 'mysql
> kstratton> -u root -h localhost -p'.  I know I will eventually have to
> kstratton> 'rc-update add /etc/init.d/mysql' once I get this working.
>
> Here's the problem, what error are you getting?  If you can't get the
> mysql client to talk to the server, then you're stuck.  Have you
> confirmed that the server is running?
>
> 	  ps -ef |grep mysql
>
> Also, look in /var/log/ for a mysql directory or log file to examine.  
>
> kstratton> What I am looking for is a guide for mysql so that instruct
> kstratton> me how to manually configure the installed mySql to the
> kstratton> point of getting a working mysql prompt (independent of
> kstratton> linux distribution).  This will give me idea of the
> kstratton> configuration files for mysql and possibly allow me to
> kstratton> figure out what is broken with the setup.
>
> kstratton> I guess my next step is to do some reading at
> kstratton>  http://dev.mysql.com/doc/.  For me, linux is just a hobby,
> kstratton>  so this may take awhile.  IF I figure what is causing my
> kstratton>  trouble, I will try to give a good description of the
> kstratton>  problem/solution.  With my luck, 'emerge --sync;emerge
> kstratton>  world -DuN' will fix this before I get a chance to figure
> kstratton>  what is going on....
>
> The mysql.com docs will probably help you alot, but so should the
> gentoo docs as well.  I forget what the default password for mysql is,
> but you can certainly google for 'reset mysql root password' and learn
> how you can start mysql is safe-mode without any password protection
> so you can reset the privs.
>   
Gentoo doesn't provide a default password, it tells you to set it yourself.